June 16, 2009 at 11:01 am
I have restored a DB backup image sent to us from our client in Standby mode.
After I have restored the DB backup image in Standby mode, I restore daily transaction logs that are shipped to me.
Every month I would like to a backup of this Database so that if something fails, I only have to restore the backup taken at the end of the month rather then catching up on 4-5 months of T-logs.
What I tried to do is as follows:
-Restore the DB backup image (sent by client) in Standby Mode for Jan 1/09.
-Apply T-logs (sent by client) to this Standby Database up until Jan 30/09
-For the Jan 31 T-log, I applied this against the DB but the option I selected to apply this T-log was in Restore Recovery mode
-Purpose was to be able to take a backup image.
-After I took the backup image, I restored the backup image into Standby Mode so that it can accept the Feb 1/09 T-log
-When I tried to apply the T-log I got the error
'This backup set cannot be applied because it is on a recovery path that is inconsistent with the database'
Why is that? Anyone have a workaround?
June 16, 2009 at 11:10 am
June 16, 2009 at 11:11 am
By doing that, you have broken the log chain from the source database (client). About the only way I can see around this would be do shut SQL Server down and then make a copy of the mdf/ldf files. Not sure if this will work, but it is worth a try.
June 16, 2009 at 11:45 am
If I make a copy of the .mdf and .ldf of the StandBy Database and then drop the Standby Databse, how do I restore it?
June 16, 2009 at 11:56 am
Tried it but no luck..any other ideas?
June 16, 2009 at 12:54 pm
If you have the .mdf and .ldf you can simply attach the database, no restore involved. If it's truly a .bak, then it's restore database.
-- You can't be late until you show up.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply