I modified the code to backup the database based on size using groups.

I will use a basketball analogy in explaining what I tried to accomplish.

Let’s say there are 32 basketball...

I modified the script to schedule the jobs for two seconds apart. Scheduling and starting all the backup at the same time was causing a deadlock. Also added the option...

I agree with all the comments, mostly the high I/O that it is going to generate. One thing I am trying to do is reduce the amount of time the...

Hi SQLBuddy,

Your suggestion gave me an idea and I did the following:

1. First I created a simple SQL job and scripted it out, the changed it into a stored procedure.

2....

Thanks all for the advice on the use of TRUNCATE_ONLY. I was basically use it to free up space. I have removed it from my code and will be very...

I ran into a similar bulk delete problem recently while trying to delete about 10 million records from a table with about 300 million records. I saw the following using...