[ADSM-L] SV: [ADSM-L] How to restore >100 DB to another server ????
2008-07-03 04:38:22
Del,
many thanks for the help.
Regards
Bo
-----Oprindelig meddelelse-----
Fra: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] På vegne af
Del Hoobler
Sendt: 2. juli 2008 15:05
Til: ADSM-L AT VM.MARIST DOT EDU
Emne: Re: [ADSM-L] How to restore >100 DB to another server ????
Bo,
Take a look at this:
http://www-1.ibm.com/support/docview.wss?uid=swg21289895
If you are using Data Protection for SQL 5.5, you should also look at the new
RELOCATEDIR option:
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmfd.doc/dpsql.htm
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/02/2008
08:46:56 AM:
> I want to restore more than 100 DB's to a another server.
>
> And I don't want to define all the new DATA and LOG files, before
> restoring.
>
> I have found this command: tdpsqlc res ApplinX full
> /Fromsqlserver=cdkalb008 /to="F:\MSSQL$DEMO3\Data\" /relocate /create
>
> I get this error msg.: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Device activation error. The phyical file name
> 'F:\MSSQL\DATA\ApplinX_Data.MDF' may be incorrect.
>
> It is not the path that I want to restore to.
>
> So is there a command to do the restore?
|
|
|