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

sql server 数据库维护

标签：where   数据库维护   join   log   RoCE   数据库   HERE   read   opera