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 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy