ADSM-L

Re: HELP Restore MS SQL Database

2002-02-07 00:53:03
Subject: Re: HELP Restore MS SQL Database
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Wed, 6 Feb 2002 16:19:52 -0500
> Tried that now I get the following error:
> 02/06/2002 14:04:08 [Microsoft][ODBC SQL Server Driver][SQL Server]The
file
> 'd:\MSSQL7\backup\Intranet_Data.MDF' cannot be used by RESTORE. Consider
> using the WITH MOVE option to identify a valid location for the file.
> 02/06/2002 14:04:08 [Microsoft][ODBC SQL Server Driver][SQL Server]Backup
or
> restore operation terminating abnormally.

Bruce,

Obtain the fix for IC30018. That is, you should get
TDP for SQL 2.2.0.1.  You can get it here:

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/agents/ntsql/2.2.0/

It is called:   IC29849_01.EXE

The fixtest contains fixes for APAR IC29849 and IC30018.
After applying the fixtest, retry the operation with
the GUI.  If it still fails, retry with the command-line interface.
If it still fails:

Make sure logical names are absolutely correct

Make sure the directory "d:\MSSQL7\backup\"
  exists before the restore.

Thanks,

Del

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

"Celebrate we will. Life is short but sweet for certain..."  -- Dave
<Prev in Thread] Current Thread [Next in Thread>