I don't think you have any space savings.

On the multiple sizes, there are places that store 1 or maybe 2 and then resize on the fly. Web servers are...

What was the reason the database was suspect?

You could try attaching the mdf with no ldf and see if can rebuild it.

Logins will be in master, and you need to know how to restore this. Jobs in msdb, make sure you know how to recover this.

you might have IP/windows server name...

There are lots of scripts in the scripts section of this site to do this. Put this in a stored procedure and call that from the job.

Call microsoft PSS. There aren't good tools for the DBA to fix this and you don't want to mess with your data.

You can try rebuilding the clustered index, but if...

Yes and no

Model is used for all databases, including tempdb.

you can expand tempdb and it will start there on the next instance restart.

Very interesting and I wish I had an answer. This almost seems like the RESEED is scanning the huge table which has been marked for truncated, but not truncated.

Sounds like...

Get a SQL Server 2005 book and read through it. It's ordered, logical, and gives you a framework.

If you're managing servers, get backups/restores down. These are important. I'd agree Security...

http://sql-server-performance.com/Community/forums/p/346/3038.aspx

I suppose you could export the data from the msdb tables (sysdbmaintplans), but the problem is these plans have so much stuff connected to your server. They're not as generic...

Is he mapped to DBO or does he have dbadmin rights?

The tables are still likely created under his name if the former. You can use sp_changeobjectowner to fix this.

How are you showing the differences? Are these text files or richer (RTF/Word)?

That might impact how to store the data.

Sorry, my fault. David sent it and I must have forgotten to attach it.

It's there now.

Why put it in either one? It will cause you issues during recovery (DR) if you need it. I've often seen people forget that these procedures are there, they recover...

There's no good way to find data other than selecting from every column and table. There are no functions to "search" a database.

If you have some idea of the field,...