HELP Restore MS SQL Database
2015-10-04 17:12:12
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
Bruce Kamp
Network Analyst II
Memorial Healthcare System
P: (954) 987-2020 x6008
E: bkamp AT mhs DOT net <mailto:bkamp AT mhs DOT net>
------------------------------------
=========================================================================
|
|
|