October 7, 2008 at 1:40 am
Hi Folks,
are you able to restore a master database on a different sql server or instance. I am doing this for replay.
It seems I can restore the master if it is from the same instance but if I get the backup from another server it doesn't like it.
My restore look like
restore database master from disk = ' ', MOVE mastlog to 'path', REPLACE
October 7, 2008 at 1:58 am
bodhilove (10/7/2008)
Hi Folks,are you able to restore a master database on a different sql server or instance. I am doing this for replay.
It seems I can restore the master if it is from the same instance but if I get the backup from another server it doesn't like it.
My restore look like
restore database master from disk = ' ', MOVE mastlog to 'path', REPLACE
Hey,
You can, but you need to ensure the build is the exact same, otherwise you'll get an error. Also, you'll need to start SQL Server in single user mode (e.g. sqlservr -c -m -f) and run restore command from sqlcmd.
Thanks,
Phillip Cox
October 7, 2008 at 2:01 am
thanks Phil.
October 7, 2008 at 2:20 am
Glad I can help!
Thanks,
Phillip Cox
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply