Showing posts with label itry. Show all posts
Showing posts with label itry. Show all posts

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.
>
>

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.
ThanksArchie
Have a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071&ID=kb;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.aspx?scid=kb;en-us;Q224071&ID=kb;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
>
>

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 l
ooking 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.
ThanksArchie
Have a look at
1" target="_blank">http://support.microsoft.com/defaul...Q22407
1
"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
> 071" target="_blank">http://support.microsoft.com/defaul...Q224
071
>
> "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.
>
>