Restore successfull BUT......

Hi Group,
I performed a restore operation on a database. The restore said it was
successful, however the database is in an unusable state. It is greyed out
and just says (Loading) after it. It stays in this status forever. I
restarted SQL Services, and even rebooted the server, which made a few
people cry but they'll get over it.
I also detached the database, since I have a copy of it stored on another
drive, but when I went to re-attach it to the copy, I get a Error 5173
Cannot associate files with different databases. That is all it says.
What am I missing here?
Thanks
CurtSounds like you did not recover the database when you restored it.
Try running the following from Query Analyzer (assuming your database is
called MyDB for example and you still have it in the "loading" state on your
server):
restore database MyDB with recovery
This should bring it online again.
Tony.
"C Fish" <cfish@.qwpi.com> wrote in message
news:D7XQa.1291$cX.480@.newssvr23.news.prodigy.com...
> Hi Group,
> I performed a restore operation on a database. The restore said it was
> successful, however the database is in an unusable state. It is greyed out
> and just says (Loading) after it. It stays in this status forever. I
> restarted SQL Services, and even rebooted the server, which made a few
> people cry but they'll get over it.
> I also detached the database, since I have a copy of it stored on another
> drive, but when I went to re-attach it to the copy, I get a Error 5173
> Cannot associate files with different databases. That is all it says.
> What am I missing here?
> Thanks
> Curt
>|||Hi Tony,
Well that got me this far
Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 65535. Database may not be activated yet or may
be in transition.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Does this mean anything to you' The database is on the list in enterprise
manager, however it is gray whereas the other databases are yellow and it
has (Loading) after the name in parenthesis. It does not however show up in
ISQL list nor the list in SQL Query Analyzer. FYI this is SQL Server 2000
with SP3 and the Backup set is from Veritas Back Up Exec ver 8.5 with SQL
Server plug in. I have restored before without any issues. I followed the
same procedures as I have in the past, but this time I am feeling like I'm
in some trouble.
Curt
"Tony Lewis" <tony.lewis@.unspam_dowcorning.com> wrote in message
news:OMHhz1vSDHA.2084@.TK2MSFTNGP11.phx.gbl...
> Sounds like you did not recover the database when you restored it.
> Try running the following from Query Analyzer (assuming your database is
> called MyDB for example and you still have it in the "loading" state on
your
> server):
> restore database MyDB with recovery
> This should bring it online again.
> Tony.
> "C Fish" <cfish@.qwpi.com> wrote in message
> news:D7XQa.1291$cX.480@.newssvr23.news.prodigy.com...
> > Hi Group,
> >
> > I performed a restore operation on a database. The restore said it was
> > successful, however the database is in an unusable state. It is greyed
out
> > and just says (Loading) after it. It stays in this status forever. I
> > restarted SQL Services, and even rebooted the server, which made a few
> > people cry but they'll get over it.
> >
> > I also detached the database, since I have a copy of it stored on
another
> > drive, but when I went to re-attach it to the copy, I get a Error 5173
> > Cannot associate files with different databases. That is all it says.
> >
> > What am I missing here?
> >
> > Thanks
> >
> > Curt
> >
> >
>
>