Sunday, 15 November 2015

How to Repair a database with Suspect

Please execute the following sql command with replacing “YourDatabase”

EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER




Avast logo
This email has been checked for viruses by Avast antivirus software.
www.avast.com

No comments:

Post a Comment