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?