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.
Bill Smoldt STORServer, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [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:\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 Kamp Network Analyst II Memorial Healthcare System P: (954) 987-2020 x6008 E: [EMAIL PROTECTED] ------------------------------------ -----Original Message----- 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 from the SQL Enterprise GUI, you will continue to get this error. Bill Smoldt STORServer, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [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= IC23902 : Existing DB is d:\mssql\data\intranet_data.mdf Created new database called restore & file D:\mssql\backup\intranet_data.mdf Set new database to DBO only & single user. In the GUI I selected recovery, database owner only, wait for tape mounts to restore & wait for tape mounts for info. Right clicked the object to restore & selected relocate & put in D:\mssql\backup\intranet_data.mdf for database path Clicked on restore & this is the message I keep getting: 02/06/2002 13:05:41 [Microsoft][ODBC SQL Server Driver][SQL Server]Database in use. The system administrator must have exclusive use of the database to run the restore operation. 02/06/2002 13:05:41 [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally. Any help will be GREATLY APPREACIATED!! ------------------------------------ Bruce Kamp Network Analyst II Memorial Healthcare System P: (954) 987-2020 x6008 E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ------------------------------------
