Skip to content

Instantly share code, notes, and snippets.

@shaxxx

shaxxx/repaird_suspect_db.sql

Created November 10, 2014 09:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shaxxx/ba301af99c714d73a066 to your computer and use it in GitHub Desktop.
Save shaxxx/ba301af99c714d73a066 to your computer and use it in GitHub Desktop.
Download ZIP
Auto repair suspected DB in MSSQL
Raw
repaird_suspect_db.sql
USE master
GO
ALTER DATABASE DatabaseName SET EMERGENCY
GO
USE DatabaseName
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
ALTER DATABASE DatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB (DatabaseName, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE DatabaseName SET MULTI_USER
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment