DBCC DBRECOVER finally removed from SQL Server

DBCC DBRECOVER finally removed from SQL Server

  • Comments 3

For those of you who relied on that command, typically used in data recovery learning labs, just wanted to warn you, if you haven’t noticed already, that it has been removed from the product starting with SQL Server 2012 RTM.

The supported way to do what that undocumented DBCC command did would be using ALTER DATABASE DatabaseName SET ONLINE.

Leave a Comment
  • Please add 1 and 6 and type the answer here:
  • Post
  • I am reestoring backup in mssql 2008 mdf and ldf file ic created but it making catlogstatus.dat is not created that time it shows operating system returned '(null)'...please suggest me some solutoin....

  • Actually , the partner was set wrong in my case and database went to InRecovery State, then ran below Transact

    ALTER DATABASE [DBNAME] SET PARTNER OFF

    Then worked fine

  • In my case the mirror partner was set wrong and secondary went to inrecovery state, then ran below Transact

    ALTER DATABASE [DBNAME] SET PARTNER OFF

    Then worked fine

Page 1 of 1 (3 items)