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

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