It is not possible.

A SQL 2008 database cannot be attached or restored to SQL 2005 or lower. Only upgrades of database versions are possible (2005->2008), never downgrades.

The only way to...

RAID arrays or single drives?

Unless the delete/update in question was running within a transaction, no. Restore from backup.

Providing no one minds losing the data since the last log backup, that is.

http://www.brentozar.com/sql/how-to-get-a-junior-dba-job/

Most important - don't exaggerate your skills or experience.

Is auto_close enabled?

No.

Are you seeing deadlocks? Are you having queries failing with the error "Transaction X was deadlocked and was chosen as the deadlock victim"? Deadlocks and blocking are two different (though...

No, no, no, no!

Why are you offering advice without telling people the consequences? Nolock means 'get the data quickly, I don't...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic934389-145-1.aspx

There's not enough information here to say anything useful. You're going to have to give a lot more info if you want useful help. The queries and table structures would...

Run CheckDB with the repair option (DB must be in single user mode). Then restore that 3 week old backup as a new DB and use something like Redgate's SQLDataCompare...

Looks like a portion of the data file has been zeroed out, overwritten with 0s. Typically an IO subsystem problem.

Your choices are to run CheckDB with the REPAIR_ALLOW_DATA_LOSS option and...

Um, how about the first two links?

The reason they don't say anything about changes (assuming you've read them), is because R2 is a whole set of add-ons. There are virtually...

Yes. Why don't you test it out and...

Nope. All join types are possible.