Given that users 'use' tables by running DDL or DML statements, you could use sp_who2 to identify users actively running queries, use fn_get_sql or DBCC INPUTBUFFER to get the query...

The statistics are updated...

You would still need to update the column statistics for the tables, if any. Only statistics for the indexes get updated during the index rebuild.

I think you'll need to restore each backup set, and then back up the restored database to a unique file. Tedious, but on the bright side, you'll be testing...

Some interesting points about recovering individual tables from backups using 3rd party tools here: http://www.sqlbackuprestore.com/recoveringindividualtables.htm

Assuming that there really is 'nobody else' accessing the database, perhaps the default database for the user performing the restore is that very database you are trying to restore over.

Well, it certainly looks like BEX (BackupExec?) made a transaction log backup on 2008-08-04 20:11:53.000. You'll need to restore the backup made by it, before you can restore the...

Under the bulk-logged recovery model, the modified pages arising from the index rebuild are backed up when you back up the transaction log. So, even though your transaction log...

I trust you did change the database name value in this line

WHERE a.database_name = 'your database name here'

and given the time now, you'll probably need to change this line too:

AND...

The error message you posted suggests that you are using SQL Server 2000, not 2005. SQL Server 2005 is 'smarter' in that it will prevent you from making a...

You could run a query similar to the following to find out all the trx log backups that were made in the last 24 hrs, which may help in identifying...

Perhaps the articles were referring to the autoshrink database option, since you refer to it as a 'mode'.

I don't understand how you can just 'grab a copy of the transaction log'. You'll still need to restore the trx log backups made from the last full/diff backup...

Since you are already backing up the transaction log every 15 minutes in your log shipping setup, is there really a need to have another job that backs it up...

There were some errors of fact in my previous post. A more accurate explanation can be found here (http://www.sqlbackuprestore.com/recoveringindividualtables.htm).