The self-paced training kit is quite good.

I'd suggest running an integrity check on the SQL 2000 database (on SQL 2000)

Run CheckDB with No_infomsgs and all_errormsgs and also run CheckCatalog with no_infomsgs and all_errormsgs

madhu.arda (12/11/2008)

---

2008-12-09 17:54:14.72 spid204 Error: 5243, Severity: 22, State: 1.

2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please...

Locking mechanisms are very, very different between Oracle, DB2 and SQL. It's not unexpected that something that works on 1 will give problems on another. Things that work well on...

Don't make any changes in the master database.

3. Would it be a...

Are you reading the event log directly from the server, or are you reading it from your client machine?

It's an english colloquial term to indicate that whatever the term applies to is plain, basic, no fancy stuff.

So a vanilla install would be a straight install with no config...

Can't say much until the output of checkDB is posted. In the meantime, do you have a clean database backup?

In most cases (including this one) no. The...

Grant Fritchey (12/11/2008)

---

Got me beat....

I've had no serious accidents in 10 years of driving. One very minor bumper bashing and several close calls though.

Closest call was a couple years back on a highway. There's...

Bristolred (12/11/2008)

---

Basically your saying you have to be prepared for the complete worst i.e. disaster recovery if the whole server was to pack up/catch fire or the drive the log...

Glad to hear that.

Bear in mind that, with the exception of TempDB, running that does not move the files. It just changes the metadata. Once you've run that you need to take the...

I don't think there are any books specifically for that. The 447 exam covers all the material that 443 and 444 together do. It's just in 1 upgrade exam instead...