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