Transaction log sequence number
Hi guys, I' m near to reach the maximum transaction log sequence number and I have clear in my mind what I have to do to restart the sequence as I found in the Kb
http://support.microsoft.com/kb/830408
What I don't understand is about my old backup. What I have to do if I need to restore a MB from a backup of the last year??
Many Thanks
June 11th, 2008 4:11pm
Hi,
We cannot restore a MB from a backup of the latest year to an Up-To-Date status as there are two transaction log sequences. The transaction logs of new sequence cannot be replayed into the restored database file. Nevertheless, after backup the older transaction log files, you can restore the database to the state before the new Transaction Log sequence is started in case you need to restore some information from old database..
In addition, I suggest that you fully back up the information store immediately after restarting a new transaction log sequence.
Mike
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2008 12:21pm