Good point.

For moving the system databases, see books online as the method is different for the different system databases.

I like the friday pic better.

If there's no backup, you're probably not getting it back. All database should have backups, critical or not. The only time I can see a DB not needing a backup...

Have you read through all the material in Books Online?

Two options.

1) Detach the database, move the files, reattach the database.

2) Use the ALTER DATABASE ... ALTER FILE to change the metadata. Take the database offline, move the files, bring...

Before you do anything else to this database.

1) Please run this and post the full output

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

2) Take a look at this...

It can be done any...

I know that MySpace (which runs on SQL Server) is not one database. Last time I heard they had 100 or so database servers with the data distributed between them.

Please note that index_usage_stats only contains info since the last time the SQL Service was started. If an index is, for example, only used at month end and the server...

Restore from backup.

You do have a backup, don't you?

No idea how accurate any of these are...

http://www.usatoday.com/money/industries/technology/maney/2006-05-16-nsa-privacy_x.htm

I'd love to play with even the baby of the listed ones. 312 TB is one hell of a challenge.

What happened to the log files? You need those for a reattach as well.

There's no way that anyone can say what's happened or why without the information that we've asked...

Sounds like the DB is suspect or recovery-pending.

Did SQL restart just before this happened?

Any errors relating to this DB in the SQL error log?

What happens if in a query...

If you're talking about SQL deadlocks, then no. Backups don't take locks. They can increase IO load and slow...

Likewise.

It mentions that Shrink truncates the log which might be true...