May 27, 2008 at 1:00 pm
Hi
I have msdb full backup.what are the steps to be taken to restore the msdb.
Binu
May 27, 2008 at 4:27 pm
Check Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ce3aa9eb-300d-46e7-b56b-505fc5d84571.htm
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 27, 2008 at 9:35 pm
Hi Binu,
The restore is similar to normal restore. To restore system databases you need to have the same build and edition of Sql Server i.e example,
If your msdb full backup was taken when Sql Server was 9.00.3054 and now you have uninstalled it and reinstalled Sql with 9.003042 you will not be able to restore them since they have different builds namely 3054 and 3042.
So you need to apply the hotfix to Sql Server to make it to 3054 and then only restore it using the below command,
Use master
go
Alter database msdb set single_user with rollback immediate
go
Restore database msdb from disk='Path\filename.bak' With Init
go
Alter database msdb set multi_user
go
[font="Verdana"]- Deepak[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply