Choices are to use a third party tool; Quest's LiteSpeed, RedGate's SQL Backup, Ideara's SQL Safe, HyperBac's HyperBac. Each have their pro and cons. Personally, we use HyperBac...

ifila (1/13/2010)

---

Apologies i missed you question - yes they can

Selection Criteria can be:...

Again, I have to ask, can the user specify the data range used in the query?

AWESOME! :w00t:

What is the isolation level you are using?

Can you show me the code you used for batch deletes?

Megistal (1/13/2010)

---

Thank you for your post Lynn

However, my issue is not with the log file (this is handle separately), it is the tempDB mdf file size.

If I'm deleting half the...

You can save the plans graphiclly as a .sqlplan files and upload those. It would be easier to read.

Play it safe, use VS2005.

Could you post the two actual execution plans?

You may want to read this article, http://www.sqlservercentral.com/articles/T-SQL/67898/. It is meant to manage the growth of a databases log file, but it may also help you with the growth...

No.

Yes, I am recommending the the Primary Key be changed to a nonclustered index and that currentdateout be made the clustered index.

If you look at your actual execution plan, you...

Thank you for the feedback. I'm glad I could help.

I'm not PC (political correct), I'm PC (politically comfortable).

Run the following substituting your database name where indicated.

select

database_name,

is_copy_only,

type as BackupType

from

msdb.dbo.backupset

where

...