ALTER DATABASE AdventureWorks SET EMERGENCY
DBCC CHECKDB ('AdventureWorks');
ALTER DATABASE AdventureWorks SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB ('AdventureWorks', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE AdventureWorks SET MULTI_USER
No comments:
Post a Comment