Check数据库是否有错的SQL:
DBCC CHECKDB('数据库名')
发现出错之后,就修复数据库。使用命令如下:
exec sp_dboption '数据库名',N'single',N'true'
dbcc checkdb('数据库名',REPAIR_ALLOW_DATA_LOSS)
exec sp_dboption '数据库名',N'single',N'FALSE'
use master exec sp_dboption 'rs0000data',N'single',N'true'
use master dbcc checkdb('rs0000data',REPAIR_ALLOW_DATA_LOSS)
use master exec sp_dboption 'rs0000data',N'single',N'FALSE'
use master ALTER DATABASE rs0000data SET SINGLE_USER WITH ROLLBACK IMMEDIATE
use master dbcc checkdb('rs0000data',REPAIR_ALLOW_DATA_LOSS)
use master ALTER DATABASE rs0000data SET MULTI_USER WITH ROLLBACK IMMEDIATE
查看用户模式:
select user_access, user_access_desc, * from sys.databases