May 23, 2005 at 10:24 am
guys,
restore is failing with the below error.Any idea what can be the cause? It was running w/o problem till few days before.
Error string: Log file 'u:\log\sti_log.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
I have a job that does stand by restore on hot spare using production backup file.Below is the cmd used :
restore database sti
from disk = 'f:\restore\daily_current\sti_db.bak'
with standby = 'f:\restore\sti_undo.txt',replace,
move 'sti_data1' to 'g:\sqldata\sti_1.mdf',
move 'sti_data2' to 'g:\sqldata\sti_2.mdf',
move 'sti_log' to 'u:\log\sti_log.ldf'
Thanks,
--jp
May 24, 2005 at 8:58 am
Hi JP,
The error means that somehow your backups got out of sequence. To figure out what happened you can look at the header information on your backups to see where the backup chain was broken. Once your know when it was broken you can look through the application and system event logs along with the Sql errorlogs to see if there is any indication of why it happened.
To fix it you will have to take a new full backup and restore it to restart the backup chain.
Richard L. Dawson
Microsoft Sql Server DBA/Data Architect
I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply