select ‘kill ‘,s.spid, sd.name, * from sys.sysprocesses s
inner join sys.sysdatabases sd on s.dbid=sd.dbid where spid>50
and sd.name=‘SmartOperation‘
sp_readerrorlog
RESTORE database [SmartOperation] with norecovery
原文：https://www.cnblogs.com/newlangwen/p/10184407.html