August 27, 2003 at 2:29 pm
I understand that the commonly accepted answer to this is no, but:
Is there any way to apply a transaction log backup to a database that has been restored and is already online?
In other words, when the DBA restored the database, he forgot to check "leave non-operational but able to apply transaction log backups". This is a VLDB that we don't want to have to restore again. Any help will be greatly appreciated!!!!
Josh Jones
Joshua Jones
Director, Global Database Services
PGi
August 27, 2003 at 6:49 pm
The answer is still 'No', unfortunaly.
August 27, 2003 at 8:41 pm
Use this syntax to change recovery state...
restore database northwind with recovery
Change northwind with database name...
Let me know what happened
Cheers..
Prakash Heda
Sr Consultant DBA
Bangalore, India
Chat: hedafriends@yahoo.com
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply