|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > question about restore
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
question about restore
|
|
|
| Hi,
I backuped my database, I would like to use this backup
file to create another identical database on a new machine
with different partitions.
After I copyed the **_200211200030.bak to the new box. I
am in enterprise manager to do restore. After I choosed
the the file which I copyed, in the Option tab, under
Restore database as, I don't need to change the logical
name, but as for the "Move to physical file name" shows
the the old path, can I change to the new path like change
from d:\Program.. to M:\program...? I tried to cahnge but
I got error:
"Device activiation error. The physical file
name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
identify a valid localtion for the file". What should I do?
Thanks
| |
| Keith Kratochvil 2002-11-20, 4:23 pm |
| Yes, you need to change the path to one that exists on the new server.
Perhaps you tried changing the path to 'M:\pro...\.mdf', but does that path
exist on this box?
You can also key in the RESTORE DATABASE.....WITH MOVE into Query Analyzer.
Syntax can be found within Books Online (in the SQL Server program group).
--
Keith, SQL Server MVP
"Jen" <follower1999@yahoo.com> wrote in message
news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
> Hi,
>
> I backuped my database, I would like to use this backup
> file to create another identical database on a new machine
> with different partitions.
> After I copyed the **_200211200030.bak to the new box. I
> am in enterprise manager to do restore. After I choosed
> the the file which I copyed, in the Option tab, under
> Restore database as, I don't need to change the logical
> name, but as for the "Move to physical file name" shows
> the the old path, can I change to the new path like change
> from d:\Program.. to M:\program...? I tried to cahnge but
> I got error:
> "Device activiation error. The physical file
> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
> identify a valid localtion for the file". What should I do?
> Thanks
| |
|
| Thanks. Yes, there is extra string after \MSSQL, after I
added in, it works well.
After I finish the resotre in EM, is there anything else I
need to do cleanup? Thw way to verify the restore is fine?
Thanks
>-----Original Message-----
>Yes, you need to change the path to one that exists on
the new server.
>Perhaps you tried changing the path to 'M:\pro...\.mdf',
but does that path
>exist on this box?
>
>You can also key in the RESTORE DATABASE.....WITH MOVE
into Query Analyzer.
>Syntax can be found within Books Online (in the SQL
Server program group).
>
>--
>Keith, SQL Server MVP
>
>
>"Jen" <follower1999@yahoo.com> wrote in message
> news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
>> Hi,
>>
>> I backuped my database, I would like to use this backup
>> file to create another identical database on a new
machine
>> with different partitions.
>> After I copyed the **_200211200030.bak to the new box. I
>> am in enterprise manager to do restore. After I choosed
>> the the file which I copyed, in the Option tab, under
>> Restore database as, I don't need to change the logical
>> name, but as for the "Move to physical file name" shows
>> the the old path, can I change to the new path like
change
>> from d:\Program.. to M:\program...? I tried to cahnge
but
>> I got error:
>> "Device activiation error. The physical file
>> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
>> identify a valid localtion for the file". What should I
do?
>> Thanks
>
>
>.
>
| |
| Keith Kratochvil 2002-11-20, 4:23 pm |
| ....access the database.
If you can access it, the restore worked!
No cleanup is needed.
--
Keith, SQL Server MVP
"Jen" <follower1999@yahoo.com> wrote in message
news:cac701c290e1$1a6b0da0$89f
82ecf@TK2MSFTNGXA01...
> Thanks. Yes, there is extra string after \MSSQL, after I
> added in, it works well.
> After I finish the resotre in EM, is there anything else I
> need to do cleanup? Thw way to verify the restore is fine?
>
> Thanks
>
> >-----Original Message-----
> >Yes, you need to change the path to one that exists on
> the new server.
> >Perhaps you tried changing the path to 'M:\pro...\.mdf',
> but does that path
> >exist on this box?
> >
> >You can also key in the RESTORE DATABASE.....WITH MOVE
> into Query Analyzer.
> >Syntax can be found within Books Online (in the SQL
> Server program group).
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Jen" <follower1999@yahoo.com> wrote in message
> > news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
> >> Hi,
> >>
> >> I backuped my database, I would like to use this backup
> >> file to create another identical database on a new
> machine
> >> with different partitions.
> >> After I copyed the **_200211200030.bak to the new box. I
> >> am in enterprise manager to do restore. After I choosed
> >> the the file which I copyed, in the Option tab, under
> >> Restore database as, I don't need to change the logical
> >> name, but as for the "Move to physical file name" shows
> >> the the old path, can I change to the new path like
> change
> >> from d:\Program.. to M:\program...? I tried to cahnge
> but
> >> I got error:
> >> "Device activiation error. The physical file
> >> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
> >> identify a valid localtion for the file". What should I
> do?
> >> Thanks
> >
> >
> >.
> >
| |
|
| Thank you very much. I can access it. The table, view,
procedure, trigger are good. But the jobs are not there.
So I guess I need to add in. Maintanence plan is not there
either. Anything else I need to check?
>-----Original Message-----
>Yes, you need to change the path to one that exists on
the new server.
>Perhaps you tried changing the path to 'M:\pro...\.mdf',
but does that path
>exist on this box?
>
>You can also key in the RESTORE DATABASE.....WITH MOVE
into Query Analyzer.
>Syntax can be found within Books Online (in the SQL
Server program group).
>
>--
>Keith, SQL Server MVP
>
>
>"Jen" <follower1999@yahoo.com> wrote in message
> news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
>> Hi,
>>
>> I backuped my database, I would like to use this backup
>> file to create another identical database on a new
machine
>> with different partitions.
>> After I copyed the **_200211200030.bak to the new box. I
>> am in enterprise manager to do restore. After I choosed
>> the the file which I copyed, in the Option tab, under
>> Restore database as, I don't need to change the logical
>> name, but as for the "Move to physical file name" shows
>> the the old path, can I change to the new path like
change
>> from d:\Program.. to M:\program...? I tried to cahnge
but
>> I got error:
>> "Device activiation error. The physical file
>> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
>> identify a valid localtion for the file". What should I
do?
>> Thanks
>
>
>.
>
| |
| Keith Kratochvil 2002-11-20, 4:23 pm |
| Jobs are stored within msdb
Do the SQL users exist?
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;EN-US;q246133
http://support.microsoft.com/?kbid=246133
--
Keith, SQL Server MVP
"Jen" <folloer199@yahoo.com> wrote in message
news:cb2001c290e2$939f6260$89f
82ecf@TK2MSFTNGXA01...
> Thank you very much. I can access it. The table, view,
> procedure, trigger are good. But the jobs are not there.
> So I guess I need to add in. Maintanence plan is not there
> either. Anything else I need to check?
>
> >-----Original Message-----
> >Yes, you need to change the path to one that exists on
> the new server.
> >Perhaps you tried changing the path to 'M:\pro...\.mdf',
> but does that path
> >exist on this box?
> >
> >You can also key in the RESTORE DATABASE.....WITH MOVE
> into Query Analyzer.
> >Syntax can be found within Books Online (in the SQL
> Server program group).
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Jen" <follower1999@yahoo.com> wrote in message
> > news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
> >> Hi,
> >>
> >> I backuped my database, I would like to use this backup
> >> file to create another identical database on a new
> machine
> >> with different partitions.
> >> After I copyed the **_200211200030.bak to the new box. I
> >> am in enterprise manager to do restore. After I choosed
> >> the the file which I copyed, in the Option tab, under
> >> Restore database as, I don't need to change the logical
> >> name, but as for the "Move to physical file name" shows
> >> the the old path, can I change to the new path like
> change
> >> from d:\Program.. to M:\program...? I tried to cahnge
> but
> >> I got error:
> >> "Device activiation error. The physical file
> >> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE to
> >> identify a valid localtion for the file". What should I
> do?
> >> Thanks
> >
> >
> >.
> >
| |
|
| You mean all the database user? No, it's not there. How
can bring up the missing pieces, ie, uses, jobs, etc.
Thanks
>-----Original Message-----
>Jobs are stored within msdb
>Do the SQL users exist?
>
>INF: How To Transfer Logins and Passwords Between SQL
Servers
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q246133
>http://support.microsoft.com/?kbid=246133
>
>--
>Keith, SQL Server MVP
>
>
>"Jen" <folloer199@yahoo.com> wrote in message
> news:cb2001c290e2$939f6260$89f
82ecf@TK2MSFTNGXA01...
>> Thank you very much. I can access it. The table, view,
>> procedure, trigger are good. But the jobs are not there.
>> So I guess I need to add in. Maintanence plan is not
there
>> either. Anything else I need to check?
>>
>> >-----Original Message-----
>> >Yes, you need to change the path to one that exists on
>> the new server.
>> >Perhaps you tried changing the path
to 'M:\pro...\. mdf',
>> but does that path
>> >exist on this box?
>> >
>> >You can also key in the RESTORE DATABASE.....WITH MOVE
>> into Query Analyzer.
>> >Syntax can be found within Books Online (in the SQL
>> Server program group).
>> >
>> >--
>> >Keith, SQL Server MVP
>> >
>> >
>> >"Jen" <follower1999@yahoo.com> wrote in message
>> > news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
>> >> Hi,
>> >>
>> >> I backuped my database, I would like to use this
backup
>> >> file to create another identical database on a new
>> machine
>> >> with different partitions.
>> >> After I copyed the **_200211200030.bak to the new
box. I[col
or=darkred]
>> >> am in enterprise manager to do restore. After I[/color]
choosed
>> >> the the file which I copyed, in the Option tab, under
>> >> Restore database as, I don't need to change the
logical
>> >> name, but as for the "Move to physical file name"
shows
>> >> the the old path, can I change to the new path like
>> change
>> >> from d:\Program.. to M:\program...? I tried to cahnge
>> but
>> >> I got error:
>> >> "Device activiation error. The physical file
>> >> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE
to[co
lor=darkred]
>> >> identify a valid localtion for the file". What[/color]
should I
>> do?
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>
>.
>
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| You can script jobs on the original server and create them on the dest server. See Keith's post
regarding logins and users.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Jen" <follower1999@yahoo.com> wrote in message
news:cb7201c290e3$df3abde0$89f
82ecf@TK2MSFTNGXA01...
> You mean all the database user? No, it's not there. How
> can bring up the missing pieces, ie, uses, jobs, etc.
> Thanks
>
> >-----Original Message-----
> >Jobs are stored within msdb
> >Do the SQL users exist?
> >
> >INF: How To Transfer Logins and Passwords Between SQL
> Servers
> >http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;q246133
> >http://support.microsoft.com/?kbid=246133
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Jen" <folloer199@yahoo.com> wrote in message
> > news:cb2001c290e2$939f6260$89f
82ecf@TK2MSFTNGXA01...
> >> Thank you very much. I can access it. The table, view,
> >> procedure, trigger are good. But the jobs are not there.
> >> So I guess I need to add in. Maintanence plan is not
> there
> >> either. Anything else I need to check?
> >>
> >> >-----Original Message-----
> >> >Yes, you need to change the path to one that exists on
> >> the new server.
> >> >Perhaps you tried changing the path
> to 'M:\pro...\. mdf',
> >> but does that path
> >> >exist on this box?
> >> >
> >> >You can also key in the RESTORE DATABASE.....WITH MOVE
> >> into Query Analyzer.
> >> >Syntax can be found within Books Online (in the SQL
> >> Server program group).
> >> >
> >> >--
> >> >Keith, SQL Server MVP
> >> >
> >> >
> >> >"Jen" <follower1999@yahoo.com> wrote in message
> >> > news:c32c01c290d9$7cfb1d50$8df
82ecf@TK2MSFTNGXA02...
> >> >> Hi,
> >> >>
> >> >> I backuped my database, I would like to use this
> backup
> >> >> file to create another identical database on a new
> >> machine
> >> >> with different partitions.
> >> >> After I copyed the **_200211200030.bak to the new
> box. I
> >> >> am in enterprise manager to do restore. After I
> choosed
> >> >> the the file which I copyed, in the Option tab, under
> >> >> Restore database as, I don't need to change the
> logical
> >> >> name, but as for the "Move to physical file name"
> shows
> >> >> the the old path, can I change to the new path like
> >> change
> >> >> from d:\Program.. to M:\program...? I tried to cahnge
> >> but
> >> >> I got error:
> >> >> "Device activiation error. The physical file
> >> >> name 'M:\pro...\.mdf' may be incorrect. use WITHMOVE
> to
> >> >> identify a valid localtion for the file". What
> should I
> >> do?
> >> >> Thanks
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
|
|
|
|
|