要实现数据库的还原，需要数据库在没有使用的情况下才能进行数据库的还原，所以在本例中通过在master数据库中创建一个杀死数据库进程的存储过程，传入参数为数据库名称，存储过程名称代码如下：
create proc p_killspid
@dbname sysname
as
declare @s nvarchar(1000)
declare tb cursor local for
select s='kill '+cast(spid as varchar)
from master..sysprocesses
where dbid=db_id(@dbname)
open tb
fetch next from tb into @s
while @@fetch_status=0
begin
exec(@s)
fetch next from tb into @s
end
close tb
deallocate tb
go
C#实现数据库的备份代码
1 public bool Backup(string fileName,string dataBaseName) 2 { 3 string backUpSql = string.Format("use master;backup database {0} to disk = '{1}';", dataBaseName, fileName); 4 return this.m_DataAccess.ExecuteNonQuery(backUpSql) >= 0 ? true : false; 5 }
C#实现数据库的还原代码：
1 public bool Restore(string fileName,string dataBaseName) 2 { 3 string restoreSql = string.Format("use master;exec p_killspid '{0}';restore database {0} From disk = '{1}' with replace;", dataBaseName, fileName); 4 return this.m_DataAccess.ExecuteNonQuery(restoreSql) >= 0 ? true : false; 5 }