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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment