What is the default database set to for NT Authority\SYSTEM - if master, can you change it to the desired database and give it a try?

Thank you so much for the information.

Awesome. Yes, we use 7.1.1 also - in the activity monitor I just verified for a 743 GB database the "New Bytes" column shows 7.4% - so on the storage...

Thanks, Mark.

Yes, when I check through the Avamar console (we have read access, YAY) - it indeed shows the similar size for all the previous backups. So basically you are...

This is an old thread but I just thought I would post my comment:

I just had a discussion with our SAN Admin and I told him that my team leader...

Just a thought - can you see if any application related .exe is running? I have seen a handful of issues in my environment and sometimes you can't believe what...

1) So you are currently using 'SORT_IN_TEMPDB = ON'? - if yes, additional storage for TEMPDB will work.

2) TEMPDB move will require an outage.

Run a trace and find the process id, login to your server and find the process that is using that process id.

Depending on what storage you have, there may be an option of cloning LUN - or gracefully detach the database, then mount that LUN from old server to new server...

So, you are saying that you can see free space in the data file but when you try to shrink, its not shrinking?

Maybe you could run freeproccache command and see...

That's the default trace which gets invoked by sql itself when it reaches the 20MB file size limit

Open SQL configuration manager and find the sql service account that is used...

Well, my experiences involved more with memory issues than anything - everything runs smooth and you deploy a new application and we will see memory errors and then it will...

Maybe http://www.sqlservercentral.com/scripts/Print/63240/ ?

Please check sql server logs - it should actually have events 'SQL trace ID 2 started by login ""' - if that is sql generated automatic trace, then the login...

Just a thought - SQL browser service is running?