使用Admin权限自动将mdf文件附加到DataBase [英] Automatically attach mdf file to DataBase with Admin permission

问题描述

我使用此代码将mdf ldf文件附加到sql但是它创建了一个异常。

当我手动附加但是当我启动sql时发生此异常

管理员将消失。

I using this code for attach mdf ldf files to sql but it Create an exception.
this exception happen also when I do attach manually but when I start sql
as administrator will be disappear.

SqlConnection myConn = new SqlConnection(@"Server=\SQLEXPRESS;Integrated security=True;Initial Catalog=master");

           string query1 = "select name from sys.databases where name='test'";
           SqlDataAdapter da = new SqlDataAdapter(query1 , myConn);
           DataTable dt = new DataTable();
           myConn.Open();
           da.Fill(dt);
           if (dt.Rows.Count == 0)
           {
              string query2 = " CREATE DATABASE [database_name] ON" +
                   "( FILENAME ='test.mdf' )," +
                   "( FILENAME ='test_log.ldf' )" +
                   "FOR ATTACH ;";
              SqlCommand myCommand = new SqlCommand(query2, myConn);
                   myConn.Close();
                   myConn.Open();
                   myCommand.ExecuteNonQuery();
                   MessageBox.Show("DataBase is Created Successfully", "MyProgram",                     MessageBoxButtons.OK, MessageBoxIcon.Information);

错误：

.. {无法打开物理文件\ test.mdf \。操作系统错误5：\5（无法检索此错误的文本。原因：15105）\。}

error:
..{"Unable to open the physical file \"test.mdf\". Operating system error 5: \"5(failed to retrieve text for this error. Reason: 15105)\"."}

推荐答案

这篇关于使用Admin权限自动将mdf文件附加到DataBase的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！