-
recovering msdb
Hi, I am in the process of writing some backup and recovery procedures for
our SQL Server system and have run into the following problem:
I have been testing the recovery of the msdb database and have had
no luck recovering the full database.
To test the full backup and recovery, I have performed a backup of the msdb database, made
a change (ie. add a task) and then performed an incremental backup.
Following this, I will manually delete the database or shutdown the server and rename
the msdb data device.
I am able to recreate the database and load the database dump, but upon trying
to load the transaction log, I get an error saying that the transaction log dump is out
of sequence. Restart from initial load. This error continues to occur and I have repeated
this process many times.
I was able to restore this database (database dump and transaction log) to another database
named 'test' and then rename it to 'msdb' . This is the only way I have been
able to sucessfully recreate the full msdb database.
I have not been able to find any documentation regarding this and was wondering
if there is a set of procedures around restoring the msdb database after a failure?
Thanks in Advance!
Jason
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|