Thanks for the responses guys, I had to leave for the day (10 hour day ftl 🙁 ) so I didn't get a chance to run that restore T-SQL but...

Anyone? I'm kind of hosed here 🙁

I believe the backup was native.

Backup was taken on SQL2000 SP3...but being restored on 2000 SP4

Backup taken on same box as it will be restored to...

Alright, well we'll have to see where I can get 🙂

Thanks so much for your help!

They are "having issues" with their backup service.

That's all I've been able to get out of them other than their apparent urgency to get this up and running somehow without...

That error pops up during my attempt to Attach the second database.

When I restored the system dbs, obviously I lost all...

Thanks for your response!

There are only 2 databases on this customer's server. 1 has been restored correctly and error checking reported no errors.

As for the error, I found this...

Sorry for spamming my thread! Urgency making my thread somewhat frantic :)---

Customer is on SP3....looks like SP4 may resolve that error?

I found this info :

http://www.sqlservercentral.com/Forums/Topic113708-5-1.aspx#bm113715

But I can't run anything against the database because I don't have it attached...

OK, after backing up the current system databases, I restored from the CD using that utility and was able to start SQL (THANKS!).

I have 2 databases to attach; I attached...

Elisabeth Rédei (11/3/2008)

---

... and as soon as things are up and running again; run DBCC CHECKDB on ALL your databases.

Lets' hope not, but if you are unable to restore your...

I read that article...

I have the rebuild master utility up but I've yet hesitated to point it to the mdf, ldf files.

Should I point it to the corrupt master.mdf, mastlog.ldf...

Good deal.

So if I can get the MDF and...

John Esraelo (11/3/2008)

---

I see..

what's interesting about the error message is that it normally revolves about the (Error : 9003 severity 20, State 1) master database having issues with and not...

This is a customer's (almost entirely unmanaged) infrastructure....