sql server 数据库维护

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