ADSM-L

HELP Restore MS SQL Database

2002-02-06 13:18:33
Subject: HELP Restore MS SQL Database
From: Bruce Kamp <bkamp AT MHS DOT NET>
Date: Wed, 6 Feb 2002 13:22:30 -0500
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>

------------------------------------
=========================================================================
<Prev in Thread] Current Thread [Next in Thread>