ADSM-L

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
------------------------------------
<Prev in Thread] Current Thread [Next in Thread>