DBCC DBRECOVER finally removed from SQL Server

DBCC DBRECOVER finally removed from SQL Server

  • Comments 2

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 3 and 3 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....

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


    Then worked fine

Page 1 of 1 (2 items)