April 27, 2011 at 12:55 am
Curious, are you also using SSIS? If so, where do you store the packages, SQL Server or File System?
May 3, 2011 at 8:47 pm
no Lynn we are not using any packages ..... so wat shud be action plan...
May 3, 2011 at 8:51 pm
You can always move to simple recovery, then delete in small batches so the log doesn't grow on you within the transaction.
But AFAIK you haven't tested all of Perry's options.
May 3, 2011 at 11:53 pm
samsql (5/3/2011)
. so wat shud be action plan...
See my last response above!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply