Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
mssql: Recovery database in suspect mode
USE master
GO
ALTER DATABASE milleniumfox SET EMERGENCY
GO
DBCC CHECKDB (milleniumfox )
GO
ALTER DATABASE milleniumfox SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB (milleniumfox, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE milleniumfox SET MULTI_USER
GO
@dario61081

This comment has been minimized.

Copy link
Owner Author

@dario61081 dario61081 commented May 31, 2021

Script to recover ddbb in suspect mode, execute in a new query with the ddbb in offline mode

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment