March 13, 2012 at 4:57 am
Hi,
Before moving the system databases do we have to disable the service broker on MSDB.
Kindly clarify my doubt.
Thanks,
Dev.
March 13, 2012 at 1:00 pm
No. For msdb, model and tempdb issue ALTER DATABASE...MODIFY FILE to set them to the new location, shut down the instance, move the files (except tempdb, just delete files), then bring the instance up.
For master you must change the location in the startup parameters, shut down the instance, move the files, then bring the instance up.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 14, 2012 at 12:09 am
My question is do we have to disable the service broker by issuing the command alter database msdb set disable_broker.
After moving it to the new drive we can enable it know. Will it lead to any problem??
Thanks,
Dev
March 14, 2012 at 12:25 am
devanandiiway (3/14/2012)
My question is do we have to disable the service broker by issuing the command alter database msdb set disable_broker.
No. I have moved msdb with no problem without disbaling and enabling broker before and after the move. The only time I think you need to worry about that is if you're rebuilding and instance from a backup where you are not also restoring master as well.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply