October 4, 2010 at 4:08 am
hi guys,
I have lost the standby file of an old database, and I need to bring online that database, do you know any procedure to do that?
Thansks in advance
Francisco Racionero
twitter: @fracionero
October 4, 2010 at 4:53 am
You can try these two options.
1) Find the un-applied transaction log backup on the primary server (the one created after the successful restore) and restore it WITH RECOVERY on the secondary database.
2) I would not recommend this on a Production Instance. Please take necessary precuations before doing this. Since SQL Server 2000 allows updates to system catalogs, you can give this a try. Execute line by line
sp_configure 'allow updates', 1
reconfigure WITH override
BEGIN TRAN
UPDATE sysdatabases SET status = 16 where name = 'SecondaryDatabaseName'
sp_helpdb 'SecondaryDatabaseName'
-- If the database is shown as ONLINE, COMMIT TRAN else ROLLBACK TRAN
If both these do not work the only option left is to reconfigure Log Shipping.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 4, 2010 at 5:22 am
First option is not available.
Second option doesn't run and fails to update the table.
Thanks
Francisco Racionero
twitter: @fracionero
October 4, 2010 at 10:02 am
To confirm, are you using SQL Server 2000? If yes, the update should not fail.
Please post the error message that you get.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
October 4, 2010 at 10:25 am
Maybe I think SQL had some redo with databases status , I restarted the instance, and then performed a restore database xxx with recovery and worked.
Many thanks for your help.
Francisco Racionero
twitter: @fracionero
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply