> Sounds like you're trying to restore a database to the same machine. You
> can't do that with SQL 7. You have to restore the database to a
different
> machine or restore it over the existing database.
You should be able to do this for full backups using the
/RELOCATE and /TO options. Take a
er [mailto:[EMAIL PROTECTED]]On Behalf Of
Bruce Kamp
Sent: Wednesday, February 06, 2002 12:13 PM
To: [EMAIL PROTECTED]
Subject: Re: HELP Restore MS SQL Database
Tried that now I get the following error:
02/06/2002 14:04:08 [Microsoft][ODBC SQL Server Driver][SQL Server]The file
'd
> 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 [Micros
From: Bill Smoldt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 1:42 PM
To: [EMAIL PROTECTED]
Subject: Re: HELP Restore MS SQL Database
Make certain that you get all the way out of SQL Enterprise Administrator.
If you have any reference to the database from having edited it fr
[mailto:[EMAIL PROTECTED]]On Behalf Of
Bruce Kamp
Sent: Wednesday, February 06, 2002 11:23 AM
To: [EMAIL PROTECTED]
Subject: HELP Restore MS SQL Database
Using TDP for MS SQL v2.2.0.0
Running SQL server v7 on NT4
Need to restore a database intranet into another database restore.
Found the APAR
Using TDP for MS SQL v2.2.0.0
Running SQL server v7 on NT4
Need to restore a database intranet into another database restore.
Found the APAR= IC23902 :
Existing DB is d:\mssql\data\intranet_data.mdf
Created new database called restore & file D:\mssql\backup\intranet_data.mdf
Set new databas