trouble restoring a DB, trouble deleting half-restored DB 
Author Message
 trouble restoring a DB, trouble deleting half-restored DB


I need to do the following:
 - using a complete DB backup (created nightly using a maintenance
plan -- mostly using defaults)
    - from a clustered SQL7 SP1 server running under NT4, SP6
    - that is the publisher for 2 replications, one merge, one simple
    - that runs on a "shared" drive f:, a RAID system
 - I need to restore the backup on a non-clustered system (NT4 SP6,
SQL7, SP2) onto drive c:, remove the replications, and then begin some
other work.

I seem to be having trouble restoring. I manually changed the drive f:
(that the backup rememembers) to c: for the DB and the Logs. The
restore seemed to work OK, but I'm left with a DB that shows no
contents and shows "still loading" in Enterprise Manager.

When I try to delete it (I now have 2 of these, both with the same
name) I get an error:

  21776 ... <DB name> not found in the database collection. if the name
is a qualified name, try [] ...

Any ideas what I need to do to get out of this bind?

(I can type the entire error message if that would help.)


Tim Hanson

Sent via http://www.***.com/
Before you buy.

Mon, 02 Dec 2002 03:00:00 GMT
 trouble restoring a DB, trouble deleting half-restored DB

OK. Nothing like talking to oneself! :)

Evidently I can ignore the errors about the "replication being in an
indeterminate state", exit enterprise manager, re-enter and I have a
function database. The non-existent DBs were ghosts in Enterprise
Manager that weren't there when I exited and came back. There are still
a bunch of "conflict" tables from replication, but I don't see any show-
stoppers at this point.


Sent via
Before you buy.

Mon, 02 Dec 2002 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. Restore trouble, how to restore DB-users????

2. HELP! Trouble Restoring DB

3. trouble with db-restore

4. trouble with db-restore

5. SQL 6.5 DB Restoring vs SQL 7.0 DB Restoring

6. attempt to restore, said db was dumped under diff sort order, how to restore it

7. i restored one replicated database in another replicated db, and now cant delete publishers in EM

8. Restore a deleted SP from the Master db in table sysobjects

9. Deleted DB, and Bacup/Restore History...

10. restoring the db from the db files

11. restoring a backup from published db into test db

12. Restore Master DB to db other than Master?

Powered by phpBB® Forum Software