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

posted @ 2018-12-27 13:13  newlangwen  阅读(301)  评论(0)    收藏  举报