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]> ------------------------------------
