> 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 IBM Corporation [EMAIL PROTECTED] "Celebrate we will. Life is short but sweet for certain..." -- Dave
