Re: HELP Restore MS SQL Database
2002-02-07 00:53:03
> 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
|
|
|