November 26, 2005 at 10:24 am
I restored a Database with RECOVERY. After some time I found that I have to apply some more log file and after apply these log file and recovery the database.
Is any option to ADD log files after RECOVER a database?
Regards
Mathew
November 26, 2005 at 5:43 pm
If you used the WITH RECOVERY option, the database is brought back on-line for use. After that, no, you can't apply more log files. You need to use the WITH NORECOVERY or WITH STANDBY option to be able to apply more backups (such as a tran log backup or a differential).
You can find more information on the options in SQL Server Books Online:
Index tab >>
RESTORE >>
RESTORE (described)
K. Brian Kelley
@kbriankelley
November 28, 2005 at 12:15 pm
If this is not a live DB then all you need to do is drop the DB, restore the DB again and apply all the relevent trans logs . If it is a Live DB, then you have no option but to restore the DB Bak somewhere else apply trans logs and figure out the missing data based on timestamp or PK and then DTS that missing data to the live db.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply