22,209
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 还原数据库
/// </summary>
/// <param name="dbName"></param>
/// <param name="backupFile"></param>
/// <returns></returns>
public void restoreDb(string dbName, string backupFile)
{
string sql = @"use master;ALTER DATABASE " + dbName + " SET OFFLINE WITH ROLLBACK IMMEDIATE;restore database "
+ dbName + " from disk='" + backupFile + "' WITH REPLACE;ALTER database " + dbName + " set online;";
ExecuteSql(sql, read.ReadStrcn());
}
declare @DBName,@Sql nvarchar(4000)
set @DBName='Test'
set @Sql=char(13)+char(10)
select
@Sql=@Sql+char(13)+char(10)+' Kill '+rtrim(spid)+';'
from sysprocesses where dbid =db_id(@DBName) AND spid=@@SPID
exec (@Sql)