July 16, 2003 at 11:59 am
There is the database problems, I send to the vendor, they repaired and send it back to me, but I found that the databse file was two day ago when I tried to restore it. Can I restore the transaction logs till now after I restore the database? Many thanks!
July 16, 2003 at 12:07 pm
quote:
There is the database problems, I send to the vendor, they repaired and send it back to me
In general, you should be able to restore those transaction log backups that were created after the full database backup once full database backup is restored with norecovery option. But I am not sure after some kind of repair has been done to the database. You may try but I guess you can't.
July 16, 2003 at 7:11 pm
Hi
"Sent it back to you", do you mean the full backup file or the physical database files?? how did you get the DB up and running again (sp_attach?) or using restore commands?
If its the restore, you may be in luck. Their "repair" may have screwed up LSN's though but its worth a go applying the full then looping through the logs (see help for assistance).
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply