检查数据库的一致性
0 views
Skip to first unread message
Wayn...@gmail.com
Apr 18, 2008, 2:46:20 AM4/18/08
to 就是怕忘了
1.打开master数据库：执行 exec sp_dboption 'GZRL','single user','true'
2.DBCC CHECKDB('DBNAME',REPAIR_ALLOW_DATA_LOSS)
3.执行 exec sp_dboption 'GZRL','single user','false'
2.DBCC CHECKDB('DBNAME',REPAIR_ALLOW_DATA_LOSS)
3.执行 exec sp_dboption 'GZRL','single user','false'
Reply all
Reply to author
Forward
0 new messages