blocks|key|3683641|text|我更喜欢使用SMO恢复备份：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3683642|Microsoft.SqlServer.Management.Smo.Server+smoServer+=+
+++++new+Server(new+ServerConnection(server));

Database+db+=+smoServer.Databases['MyDataBase'];
string+dbPath+=+Path.Combine(db.PrimaryFilePath,+'MyDataBase.mdf');
string+logPath+=+Path.Combine(db.PrimaryFilePath,+'MyDataBase_Log.ldf');
Restore+restore+=+new+Restore();
BackupDeviceItem+deviceItem+=+
++++new+BackupDeviceItem('d:\MyDATA.BAK',+DeviceType.File);
restore.Devices.Add(deviceItem);
restore.Database+=+backupDatabaseTo;
restore.FileNumber+=+restoreFileNumber;
restore.Action+=+RestoreActionType.Database;
restore.ReplaceDatabase+=+true;
restore.SqlRestore(smoServer);

db+=+smoServer.Databases['MyDataBase'];
db.SetOnline();
smoServer.Refresh();
db.Refresh();|code-block|syntax|javascript|3683643|您需要对Microsoft.SqlServer.Smo、Microsoft.SqlServer.SmoExtended和Microsoft.SqlServer.Management.Sdk.Sfc的引用|3683644|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I prefer to use SMO to restore a backup:

<pre><code>Microsoft.SqlServer.Management.Smo.Server smoServer = 
 new Server(new ServerConnection(server));

Database db = smoServer.Databases['MyDataBase'];
string dbPath = Path.Combine(db.PrimaryFilePath, 'MyDataBase.mdf');
string logPath = Path.Combine(db.PrimaryFilePath, 'MyDataBase_Log.ldf');
Restore restore = new Restore();
BackupDeviceItem deviceItem = 
 new BackupDeviceItem('d:\MyDATA.BAK', DeviceType.File);
restore.Devices.Add(deviceItem);
restore.Database = backupDatabaseTo;
restore.FileNumber = restoreFileNumber;
restore.Action = RestoreActionType.Database;
restore.ReplaceDatabase = true;
restore.SqlRestore(smoServer);

db = smoServer.Databases['MyDataBase'];
db.SetOnline();
smoServer.Refresh();
db.Refresh();
</code></pre>

You'll need references to Microsoft.SqlServer.Smo, Microsoft.SqlServer.SmoExtended, and Microsoft.SqlServer.Management.Sdk.Sfc

blocks|key|3683605|text|您的DB连接最有可能与您试图还原的数据库连接。因此，有一个DB共享锁，它阻止您的db的恢复。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3683606|尝尝这个|3683607|SQL+=+@"USE+master+BACKUP+DATABASE+MyDataBase+TO+DISK='d:\MyDATA.BAK'";|code-block|syntax|javascript|3683608|或更改连接详细信息以使用主DB。|3683609|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Your DB connection is most likely to the database you're trying to restore. So there is a DB shared lock which prevents the restore of your db

Try this

<pre><code>SQL = @"USE master BACKUP DATABASE MyDataBase TO DISK='d:\MyDATA.BAK'";
</code></pre>

Or change the connection details to use master DB

blocks|key|3683564|text|必须通过不同的数据库连接到数据库服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3683565|所以您的连接字符串应该让您在服务器上说"Master“或其他数据库，然后您就可以完成手头的任务了。|3683566|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You must connect to the database server via a different database.

So your connection string should take you to say "Master" or another database on the server, then you can complete the task at hand.

blocks|key|1919295|text|连接字符串应该有一个master数据库作为默认目录连接到。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1919296|entityMap^0|A|6|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Your connection string should have a <code>master</code> database as default catalog to connect to.

blocks|key|3641027|text|我已经用这个解决方案结束了。我的数据库名为Stats，这将在没有安装MSSQL管理工作室的情况下工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3641028|++++public+void+BackUpDB(string+fname)
++++{
++++++++using+(SqlConnection+cn+=+new+SqlConnection(_cstr))
++++++++{
++++++++++++cn.Open();
++++++++++++string+cmd+=+"BACKUP+DATABASE+[Stats]+TO+DISK='"+%2B+fname+%2B+"'";
++++++++++++using+(var+command+=+new+SqlCommand(cmd,+cn))
++++++++++++{
++++++++++++++++command.ExecuteNonQuery();
++++++++++++}
++++++++}
++++}

++++public+void+RestoreDB(string+fname)
++++{
++++++++using+(SqlConnection+cn+=+new+SqlConnection(_cstr))
++++++++{
++++++++++++cn.Open();
++++++++++++#region+step+1+SET+SINGLE_USER+WITH+ROLLBACK
++++++++++++string+sql+=+"IF+DB_ID('Stats')+IS+NOT+NULL+ALTER+DATABASE+[Stats]+SET+SINGLE_USER+WITH+ROLLBACK+IMMEDIATE";
++++++++++++using+(var+command+=+new+SqlCommand(sql,+cn))
++++++++++++{
++++++++++++++++command.ExecuteNonQuery();
++++++++++++}
++++++++++++#endregion
++++++++++++#region+step+2+InstanceDefaultDataPath

++++++++++++sql+=+"SELECT+ServerProperty(N'InstanceDefaultDataPath')+AS+default_file";
++++++++++++string+default_file+=+"NONE";
++++++++++++using+(var+command+=+new+SqlCommand(sql,+cn))
++++++++++++{
++++++++++++++++using+(var+reader+=+command.ExecuteReader())
++++++++++++++++{
+++++++++++++++++++if+(reader.Read())
++++++++++++++++++++{
++++++++++++++++++++++++default_file+=+reader.GetString(reader.GetOrdinal("default_file"));
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++++++sql+=+"SELECT+ServerProperty(N'InstanceDefaultLogPath')+AS+default_log";
++++++++++++string+default_log+=+"NONE";
++++++++++++using+(var+command+=+new+SqlCommand(sql,+cn))
++++++++++++{
++++++++++++++++using+(var+reader+=+command.ExecuteReader())
++++++++++++++++{
++++++++++++++++++++if+(reader.Read())
++++++++++++++++++++{
++++++++++++++++++++++++default_log+=+reader.GetString(reader.GetOrdinal("default_log"));
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++++++#endregion
++++++++++++#region+step+3+Restore
++++++++++++sql+=+"USE+MASTER+RESTORE+DATABASE+[Stats]+FROM+DISK='"+%2B+fname+%2B+"'+WITH++FILE+=+1,+MOVE+N'Stats'+TO+'"+%2B+default_file+%2B+"Stats.mdf',+MOVE+N'Stats_Log'+TO+'"%2B+default_log%2B+"Stats_Log.ldf',+NOUNLOAD,++REPLACE,++STATS+=+1;";
++++++++++++using+(var+command+=+new+SqlCommand(sql,+cn))
++++++++++++{
++++++++++++++++command.ExecuteNonQuery();
++++++++++++}
++++++++++++#endregion
++++++++++++#region+step+4+SET+MULTI_USER
++++++++++++sql+=+"ALTER+DATABASE+[Stats]+SET+MULTI_USER";
++++++++++++using+(var+command+=+new+SqlCommand(sql,+cn))
++++++++++++{
++++++++++++++++command.ExecuteNonQuery();
++++++++++++}
++++++++++++#endregion
++++++++}
++++}|code-block|syntax|javascript|3641029|entityMap^0|L|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I've ended with this solution. Name of my database was Stats This will work without installed MSSQL management studio

<pre><code> public void BackUpDB(string fname)
 {
 using (SqlConnection cn = new SqlConnection(_cstr))
 {
 cn.Open();
 string cmd = "BACKUP DATABASE [Stats] TO DISK='" + fname + "'";
 using (var command = new SqlCommand(cmd, cn))
 {
 command.ExecuteNonQuery();
 }
 }
 }

 public void RestoreDB(string fname)
 {
 using (SqlConnection cn = new SqlConnection(_cstr))
 {
 cn.Open();
 #region step 1 SET SINGLE_USER WITH ROLLBACK
 string sql = "IF DB_ID('Stats') IS NOT NULL ALTER DATABASE [Stats] SET SINGLE_USER WITH ROLLBACK IMMEDIATE";
 using (var command = new SqlCommand(sql, cn))
 {
 command.ExecuteNonQuery();
 }
 #endregion
 #region step 2 InstanceDefaultDataPath

 sql = "SELECT ServerProperty(N'InstanceDefaultDataPath') AS default_file";
 string default_file = "NONE";
 using (var command = new SqlCommand(sql, cn))
 {
 using (var reader = command.ExecuteReader())
 {
 if (reader.Read())
 {
 default_file = reader.GetString(reader.GetOrdinal("default_file"));
 }
 }
 }
 sql = "SELECT ServerProperty(N'InstanceDefaultLogPath') AS default_log";
 string default_log = "NONE";
 using (var command = new SqlCommand(sql, cn))
 {
 using (var reader = command.ExecuteReader())
 {
 if (reader.Read())
 {
 default_log = reader.GetString(reader.GetOrdinal("default_log"));
 }
 }
 }
 #endregion
 #region step 3 Restore
 sql = "USE MASTER RESTORE DATABASE [Stats] FROM DISK='" + fname + "' WITH FILE = 1, MOVE N'Stats' TO '" + default_file + "Stats.mdf', MOVE N'Stats_Log' TO '"+ default_log+ "Stats_Log.ldf', NOUNLOAD, REPLACE, STATS = 1;";
 using (var command = new SqlCommand(sql, cn))
 {
 command.ExecuteNonQuery();
 }
 #endregion
 #region step 4 SET MULTI_USER
 sql = "ALTER DATABASE [Stats] SET MULTI_USER";
 using (var command = new SqlCommand(sql, cn))
 {
 command.ExecuteNonQuery();
 }
 #endregion
 }
 }
</code></pre>

I try to restore the database like this:

<pre><code>SQL = @"RESTORE DATABASE MyDataBase TO DISK='d:\MyDATA.BAK'";
 Cmd = new SqlCommand(SQL, Conn);
 Cmd.ExecuteNonQuery();
 Cmd.Dispose();
</code></pre>

but I always get error:

<blockquote>
 Msg 3102, Level 16, State 1, Line 7 
 RESTORE cannot process database 'MyDataBase ' because it is in use
 by this session. It is recommended that the master database be used
 when performing this operation. 
 Msg 3013, Level 16, State 1, Line 7 
 RESTORE DATABASE is terminating abnormally.
</blockquote>

How to restore SQL Server database through C# code

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我试图像这样恢复数据库：SQL = @"RESTORE DATABASE MyDataBase TO DISK='d:\MyDATA.BAK'";                Cmd = new SqlCommand(SQL, Conn);                Cmd.ExecuteNonQuery();                Cmd.Dispose();但我总是会犯错： Ms

问如何通过C#代码恢复Server数据库
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何通过C#代码恢复Server数据库EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何通过C#代码恢复Server数据库
EN