Yes - the restorehistory table has what you want. Look in the restore_type column for type 'R' - which corresponds to reverts. Beware also that reverting from a database snapshot...

Here's some more in-depth info for you:

Why data file shrink is bad: http://www.sqlskills.com/blogs/paul/2007/11/13/AutoshrinkTurnItOFF.aspx

Running out of log space: http://www.sqlskills.com/blogs/paul/2007/09/24/SearchEngineQA1RunningOutOfTransactionLogSpace.aspx

Clearing the log: http://www.sqlskills.com/blogs/paul/2007/10/12/BACKUPLOGWITHNOLOGUseAbuseAndUndocumentedTraceFlagsToStopIt.aspx

There are no changes in this area in SS2008.

Just to avoid the extra workload. Every index you rebuild unnecessarily means:

- potential for data file growth

- depending on how you rebuild, reduced concurrency on the table (for offline rebuild)...

Removing indexes will have no effect. As I said in the MSDN forum thread, the PFS page tracks free space (among other things) for heaps and text data - nothing...

The reason you're getting that error is that you're trying to run online checkdb (the default) on a database that can't support it. I rewrote checkdb in 2005 to use...

Specifically, rebuild will update statistics with a full scan (so don't manually update stats too otherwise you could end up with worse stats if your default is to do a...

What compatibility level are the databases you're trying to execute in? They need to be 9.0 for DMVs to work.

Also, use DB_ID ('DatabaseYouAreIn') instead of DB_ID ().

That should sort you...

I took care of this on the MSDN HA/DR forum where it was cross-posted. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2736150&SiteID=1.

To comment on the two replies:

1) The Storage Engine team doesn't want to remove the...

Yes, of course it does - I missed the key in there (I blame jet-lag - I'm in China this week 🙂

My bet is still a bug. There were several...

The base table here is a heap (otherwise the data rows would be identified by cluster key values instead of physical RIDs). The strange thing here is that both non-clustered...

I think there's some unintuitive behavior in the server here around worktables. Let me check with some people in the dev team and get back to you.

Thanks

Not flying till Saturday - don't write me off yet! 🙂

Tim - this looks fine to me - the database state is ONLINE and MULTI_USER.

Can you describe in more detail...

Can you post:

- the exact SQL you used

- the exact error message you received when trying to detach the database

- the output from "select * from master.sys.databases where name='yourdbname';"

Thanks

You need way more help than you're going to get in a reasonable time over a forum like this - I recommend calling in a SQL consultant (not trying to...