Ok I pieced through the stored procedure and found the culprit..it isn't the bulk insert it is the use of bcp

This set command

SET @PJCT = 'bcp DBSallc.dbo.HOPE_PJCT_LOAD out e:\Allocations\alloc_gl_load\PJCTLOAD.txt...

Well yes and no, it is on our SQL server that has several 'grunt' programs..I haven't yet taken the dive to put it on our ERP server yet but I...

My support ticket number is 16723622 and Ben Fiandaca is my tech support rep. I must now place this build within the administration and then push out to the...

Update---

Installed 839 build of Diskeeper 2009 on a SQL Server 2005 with SP2 and after 18 hours no stack dump. Continue to monitoring the situation. Not sure if...

****Got an answer!!! *******:w00t:

On the phone with Diskeeper they ARE able to duplicate the stack dump problem. Tech support indicates that 2009 version is holding on to various sql...

Will do...It is SQL Server 2005 SP2 I haven't done any applying of any new service packs

This didn't have a problem with 2008 diskeeper

Sent tech case with support will update...

We are g etting this problem as well AND just applied Diskeeper 2009 Admin Server tool to the server.

I am going to remove the diskeeper product, restart the SQL server...

thanks Nicholas and after reading the best practices for Backupexec SQL I would have to turn off a majority of my SQL scripts (which I obviously not going to do)

Now...

Thanks Charles!

Thanks to both but I would like to automate this..I guess I am dreaming about turkey dinner

I cannot see putting this in as a job then I would have to...

Never mind...I tried to apply all files at once via the GUI and found that you cannot do this....

More info found the problem

In my SQL job I did each database full recovery with NORECOVERY option

then I did a seperate step for the Differential restore.

SQL Job...

Lynn,

To recap. I backup (full and diff) from Prod then zip, transfer and restore to Warm. As per your suggestion I did the following:

On the Prod server I...

Lynn

thanks I will try this I need to shift gears I can update tomorrow. let's think ahead though. What if the RESTORE HEADERONLY for the diff backup...

Ok I see the list of backup and see my backup, so I guess what I am looking at is to ensure the full backup I am calling is the...