BCP may work well.

If you use SSIS, I think there are some parameters to set batch size that can help, instead of trying to export all at once.

I'm not clear what your question is.

"Kick off" what kind of job ??

As Jacob suggests, you can look at backup history for an approximation.

Something like this will give you an average database size per month, which may be "good enough" for history....

Thanks

Alan.B (1/11/2016)

---

A few things:

Can you post the query plan that's used for this query?

Also, does that column need to be NULLable? If not can you set it to NOT NULL,...

Jeff Moden (11/19/2011)

---

First, nicely done there Cold Coffee. I came up with an almost identical solution and saw yours when I was getting ready to post it. Your...

I have been using this which I found a few years ago, and modified a bit.

/****** Object: StoredProcedure [dbo].[usp_LongRunningJobs_XML] Script Date: 11/08/2015 13:20:06 ******/

SET ANSI_NULLS ON

GO

SET...

TSM ?

Is it run from a SQL Scheduled Job ?? I find the "Log to Table" option under the step's "Advanced" tab often has more useful information ... if...

Eirikur Eiriksson (9/20/2015)

---

That's quite an antique collection you got there, not certain if the backup is your real problem!

😎

Is the...

Did you contact support from the 3rd party company ??

Sometimes errors are specific to the product.

Any opinion on this method ?

ALTER DATABASE MyDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE

I noticed this in my log file:

"Msg 6107, Sev 14, State 1, Line 1 : Only user processes can be killed."

So there's some system process every once in a while...

I am using RedGate Backup/restore, and have included DISCONNECT_EXISTING, but it does not always work.

My primary concern is reliability of the restore process, with speed secondary.

"The simplest way to send out the email on the failure of the data flow, is to add an email task in the control flow. Connect it to the data...