That's a good point, Ian, but that depends on how the values are pulled out. The application might constrain the domain of items that are used.

If there need to be...

It will release memory to the OS if there is pressure, albeit slowly.

If you want SQL to use less, set a max limit that's lower. Otherwise, ignore it. SQL is...

One thing I'd be concerned about is an app pointed at the wrong server. Are the db names the same as production?

I''m sure your trace will show something.

The thing I think is that does "locked" matter if it's a product or customer?

In my example, I'd still have the status table. I typically have had ID, name, and...

It's got to be network or I/O limiting your ability to catch up. You mentioned a backup, is this part of nightly maintenance? Any chance that indexing was going on?...

I'd use SteveB's suggestion. Add a T-SQL task, calculate a date, branch based on the result.

Maintenance cleanup task for the files

History Cleanup for the log files (text)

Add it to your maintenance plan and point it to the folder.

The diff changes the LSN, so I'd expect this to work. The Diff would pick up all changes done in simple mode and then you could resume log backups.

I think...

It's not just a question of ego, it's more a question of matching things up properly. I've seen many people say they need access to get their job done. Developers...

You can change it back to something else. "Sam" is likely taken, but you could pick something else.

We announced it here: http://www.sqlservercentral.com/articles/SQLServerCentral/68122/

Brad,

Let us know how it is, or write a review and send it in.

Thanks for the update. My other suggestion for checking (for others reading this) is to look for triggers. Sometimes they prevent something from committing.

Has to be activity. Maintenance plans? Checked the default trace?

A trace would be the best way to do this. C2 can add lots of overhead, but you'd have to determine if that is the scope of data you needed....

My argument would be "no", since on x32, it's required to get more than 4GB addressed.