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
> >
> >
>
>

Restore MB/Sec

What sort of MB/Sec do you have for a restore operation?
I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
log, and the backup is coming from a 6 Disk RAID10 array.. ..the database I
just restored reported "RESTORE DATABASE successfully processed 14937911
pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
database I am restoring now is experiencing average sec/write of 0.08 -
0.10, and has a throughput of around 40/50MB.. ..I thought it would be a bit
better than this and just wanted to benchmark this against other
observations...
(Currently nothing else is occuring on the box apart from the restore)"Ben UK" <BenUK@.discussions.microsoft.com> wrote in message
news:91DF00F5-6938-41BD-928E-5942F3CB88E6@.microsoft.com...
> What sort of MB/Sec do you have for a restore operation?
> I have a 15 Disk RAID10 Array for the data, a 2 Disk RAID1 Mirror for the
> log, and the backup is coming from a 6 Disk RAID10 array.. ..the database
> I
> just restored reported "RESTORE DATABASE successfully processed 14937911
> pages in 5809.377 seconds (21.064 MB/sec).", from perfmon I can see the
> database I am restoring now is experiencing average sec/write of 0.08 -
> 0.10, and has a throughput of around 40/50MB.. ..I thought it would be a
> bit
> better than this and just wanted to benchmark this against other
> observations...
Hard to say.
I know when I did some testing on our servers, the limiting factor was the
source drives.
(btw, 15 disk RAID 10, I have to assume one is a hot spare, since otherwise
that doesn't work).
Also, you could be hitting network limitations.
> (Currently nothing else is occuring on the box apart from the restore)
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com