September 16, 2013 at 9:05 am
Hello,
I am not sure if this has been addressed already. I have been a long time reader but this is my first post. I need assistance with a database restore solution. I recieve a full BAK and the transaction logs 30 minutes from a supplier. I would like to restore the DB and process the TRN files nightly. The database has to be in a mode where I can query and insert the new information into a reporting database after the TRN files have been processed and then repeat the process the next night. It seems no matter what I try I get the "Different Recovery Path" error or I can process everything only for that day. I am running SQL Server 2008 R2 standard and have been banging my head on this one for about a week now. :w00t:
Any help or pointers would be appreciated.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply