Monday, February 20, 2012

Restore master db to new server with different drive paths

I am trying to restore a a system to another server with different paths. I can restore the master db ok but when itry to start it up using sqlservr -c -m etc i get a device activation error on the model db because it is still looking to the old path. is
there any way around this.
If not what are the implications of keeping the base installed master db on the new server and attaching all the other databases.
Thanks
Archie
Have a look at
http://support.microsoft.com/default...;en-us;Q224071
"Archie" <Archie@.discussions.microsoft.com> wrote in message
news:52B86D59-3CCF-4986-838F-B1AE3D1F5D38@.microsoft.com...
> I am trying to restore a a system to another server with different paths.
I can restore the master db ok but when itry to start it up using
sqlservr -c -m etc i get a device activation error on the model db because
it is still looking to the old path. is there any way around this.
> If not what are the implications of keeping the base installed master db
on the new server and attaching all the other databases.
> Thanks
|||Thanks for reply
Got it resolved, wasn't thinking at first got roun dby using the t3068 flag and changing.
Thanks
"Uri Dimant" wrote:

> Archie
> Have a look at
> http://support.microsoft.com/default...;en-us;Q224071
>
> "Archie" <Archie@.discussions.microsoft.com> wrote in message
> news:52B86D59-3CCF-4986-838F-B1AE3D1F5D38@.microsoft.com...
> I can restore the master db ok but when itry to start it up using
> sqlservr -c -m etc i get a device activation error on the model db because
> it is still looking to the old path. is there any way around this.
> on the new server and attaching all the other databases.
>
>

No comments:

Post a Comment