Re: TDP for SQLserver ignore /restoreinto option
2001-03-01 10:42:45
Subject: |
Re: TDP for SQLserver ignore /restoreinto option |
From: |
Robert L King <bobking AT US.IBM DOT COM> |
Date: |
Thu, 1 Mar 2001 10:43:01 -0500 |
Davide,
To restore into a database you have to make sure you are not restoring to a
physical name that already exists. When the database you are restoring into
is on the same host as the original database, the original physical name
does already exist. To get around this with TDP for SQL Version 1 you have
to create the database you are restoring into with the database's logical
names specifying different physical names. You MUST use the original
logical names.
In your case create database "restore" with logical name
"SqlPBgestitiPr_Data" specifying physical name "d:
\mssql7\data\restore_Data.MDF". You will also have to change the
transaction log location: logical name "SqlPBgestitiPr_Log" specifying
physical name "d:\mssql7\data\restore_Data.LDF", for example.
With TDP for SQL Version 2 you don't have to create the restore into
database ahead of time but you do have to specify the new physical names
for the original logical names.
Bob King bobking AT us.ibm DOT com
------------------------------------
|
|
|