Remember that the values returned from sys.dm_db_index_usage_stats are only accurate since the last SQL restart because they get reset to 0:

From BOL

"... The counters are initialized to empty whenever...

You really need to "roll forward" from a full backup.

You need the most recent FULL backup from before the 17th. The you need the most recent differential before the "problem",...

Maybe a script like this would help you find the most recent backup and it's path:

select top 1 bset.database_name, bset.Type, media.physical_device_name, backup_start_date

from msdb.dbo.backupset bset

join msdb.dbo.backupmediafamily as...

Jeffrey Williams-493691 (10/16/2009)

homebrew01 (10/16/2009)

Indexes should be below 10%. Once they reach 10%, they are...

Indexes should be below 10%. Once they reach 10%, they are now using 2...

Will ApexSQL Log Reader work with RedGate backups ? I installed it, and got to the point of entering backup file names but got an error "sys.sysrowsets table could...

Would this work :

I set on a trace on the database, then do a restore and go past the delete step. Would the trace show the deletes ?? Would...

perhaps the data plus tempdb is greater than the free space. It can help to set the batch size of imports in DTS.

Anything useful in SQL or Windows error logs ? Any chance the disk was full at the time, but has free space now ?

Is the physical hard drive full ?

You fix it by freeing up space. Either non-SQL files on the drive, or shrinking Log or Data files on that drive. Shrinking is...

He told me it needed to be in the trusted root .... but get another opinion in case I'm wrong.

I think we had a similar problem recently. I asked someone here and he said a few problems were caused by

not using the fully qualified domain name; having it in...

I've done it by putting the regular restore script into a job, with additional steps to fix the logins. In my case, the backup file had the same name each...

Small snippet from BOL:

"...Specifies that SQL Server should create the specified database and its related files even if another database already exists with the same name. In such a case,...

I scheduled a nightly restore to a test system a while back:

1) Backup to a drive (scheduled)

2) Batch file to copy .BAK to destination server (Step 2 of backup)

3) Destination...