March 15, 2007 at 4:36 am
I have just restored a database using the following syntax
RESTORE DATABASE CarrierLabels
From DISK = 'D:\Live BackupServer data\MSSQL\BACKUP\CarrierLabels'
WITH NORECOVERY,
MOVE 'CarrierLabels_Data' TO 'D:\Live BackupServer data\MSSQL\Data\CarrierLabels_Data.mdf',
MOVE 'CarrierLabels_Log' TO 'D:\Live BackupServer data\MSSQL\Data\CarrierLabels_Log.ldf'
and I got a message saying the restore was successful...so I went back to Enterprise Manager expecting to see the database there...and it is, but I cannot see anything in it as it's greyed out and saying (LOADING).
I've tried to drop the database, but it won't let me. I've tried to stop and start the services and it's still in the same state. I've tried to detach the database and, strangely enough, that reports "Database Being Replicated YES"...
I've tried to stop replication but it won't let me.
So basically, I'm stuck with a database that was successfully restored but I cannot get to and cannot get rid of.
Any pointers would be greatly appreciated.
March 15, 2007 at 5:26 am
It's ok.
I worked it out.
For anyone else having the problem, I simply highlighted the database saying (loading) and selected Restore Database and selected the same backup file used previously and restored it and it came back online.
I've since dropped the database, ran the query again but changing WITH NORECOVERY to WITH RECOVERY and it restored corerctly this time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply