Skip to content

Instantly share code, notes, and snippets.

@davidsheardown

davidsheardown/MS-SQL Recover Suspect Database.sql

Created July 8, 2022 11:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidsheardown/82fb5d6dc095900084057a210e950771 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidsheardown/82fb5d6dc095900084057a210e950771 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. davidsheardown created this gist Jul 8, 2022.
    12 changes: 12 additions & 0 deletions MS-SQL Recover Suspect Database.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    SELECT DATABASEPROPERTYEX (N'SQL-Examples', N'STATUS') AS N'Status';

    ALTER DATABASE [SQL-Examples] SET EMERGENCY;
    GO
    ALTER DATABASE [SQL-Examples] SET SINGLE_USER;
    GO
    DBCC CHECKDB (N'SQL-Examples', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;
    GO

    -- Remember to set back to multi-user
    ALTER DATABASE [SQL-Examples] SET MULTI_USER;
    GO