Поделиться через

DBCC DBRECOVER finally removed from SQL Server

  • Статья

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.

Comments

  • Anonymous
    August 07, 2012
    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....

  • Anonymous
    March 27, 2014
    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

  • Anonymous
    March 27, 2014
    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