Larry,


Is this for SQL 7.0?

Restore into for SQL 7.0 has to be done as follows:
(The following note is from the book and online help.)

 ========================================================================
SQL Application Client: Restore, Restore Database Options

SQL Application Client administrators can restore an existing
SQL database into a new SQL database with a different name.
For example, to change the name of a database from "Sales" to
"Marketing", backup the "Sales" database, create the "Marketing"
database, and then restore the backed up "Sales" database
into the newly created "Marketing" database.


* Restore Into Entry Field

Use this field to identify the SQL database that is the target
for the restore.  The target database is the database into which
the backed up version in the TSM backup inventory is copied.
Enter or select the target database with this entry field.

Hint: SQL Server Version 7.0 databases are created with logical volumes
      that are mapped to physical files.  The database name identified
      within the restore into option must be pre-defined with
      the same logical name that existed in the original
      database, but with a different physical file name.  For example:

Existing Database Definition:

  Logical File Name           Physical File Name
  -----------------------     --------------------------
  OldDb_Data                  c:\OldDb_Data.MDF
  OldDb2_Data                 c:\OldDb2_Data.NDF
  OldDb_Log                      e:\OldDb_Log.LDF

New Database Definition:

  Logical File Name           Physical File Name
  -----------------------     --------------------------
  OldDb_Data                  d:\NewDb_Data.MDF
  OldDb2_Data                 d:\NewDb2_Data.NDF
  OldDb_Log                   d:NewDb_log.LDF
 ========================================================================

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com


Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>@VM.MARIST.EDU> on
03/23/2000 12:35:05 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: Autodelete of SQL backups



Hi Joe:
Thanks. Downloaded it and it worked fine. However, we still have a problem
with restoreing a database to a empty copy using the restore into option
from the GUI. Is that a known nug?
Regards,
Larry Clark
NYS Thruway