There are tools such as Compliance Manager that will track changes going forward, or you could create your own server side trace, and have it restart when the service gets...

I interpreted the situation to be that there are already duplicate records, and the OP was wondering how that's possible since the index being rebuilt disallowed duplicates. So, duplicates should...

Is TCP\IP enabled on the named instance ?

Shrinking causes fragmentation. Leave the space available for future growth.

If you search, you can find quite a few answers.

It might be good to run a trace and see exactly what is being executed by BackupExec.

His job doesn't show up in one of our queries ?

Run something like this to see all the backups, and see if there are any running other than yours.

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D' then '** FULL...

What is using up the other 12 gig ? Maybe something else can be moved off the drive ?

As Steve mentioned you can use a maintenance plan. Then you can specify how many days to retain your individual backup files. It can be done through scripting also but...

This post is 2 1/2 years old, and the OP already found it in master.

(Fooled me into looking)

Are you backing up to a device ? With append, the size should grow by the size of the database. With overwrite, the size should stay about the same as...

Redgate, Idera & Quest make a variety of DB tools and utilities.

I don't think you need to run a t-log backup if there are no users in the system, and no other activity such as scheduled jobs or data imports. If...

So you want to remove SP3 and revert back to SP2 ? I would not call that a "migration" .. more like uninstall or rollback.

Some service packs cannot...

I wouldn't say that fragmentation causes blocking. But fragmentation may cause poor performance, which may make blocking more likely as processes take longer.