Actually, I just took a look at the counts for today and we're up over 1100 reports all rendered and distributed in about 20mins. So I'm pretty happy with the...

"With as much free memory as the machine still has, these DBs should be completely held in memory. "

Not necessarily, only if all the data in the database is being accessed...

Create a share on the other server and then give the SQL service account read/write access to that share.

If you want to drop and create the Excel spreadsheet then you will need to have both statements in the same ExecuteSQL task.

There are a couple of other options though,

1) Have...

Isn't there a dependency on an SQL Agent job, or am I thinking of something else?

5. Report execution times are found in a table called ExecutionLog.  The time it takes to actually see the report on the desktop is about 5 seconds longer than the...

Both Log Shipping and Replication will have an impact in some form or another.

Replication will have less effect on the server performance and more effect on the database and...

How are you connecting to the server? What application are you using? Can you ping the server? Can you connect via the normal SQL Client tools?

Please do not cross-post, it just confuses things.

You've already posted this message

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=227521

and

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=2275331

Which one would you like replies to??

Please do not cross-post, it just confuses things.

You've already posted this message

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=227531

and

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=227532

Which one would you like replies to??

Please do not cross-post, it just confuses things.

You've already posted this message

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=227521

and

here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=227532

Which one would you like replies to??

Ahh .. yes .. well spotted. I'd prefer to have a single update myself, but wouldn't it work out if the weekend was checked first and then the update (...

I'd use some form of Replication as well Log Shipping.

Replication to a local server to cover server failure. Log Ship the replicated server offsite to cover site failure.

Also, the minimum interval...

See if these links help,

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

I'm thinking you would use the ExecuteSQL task, but if you explained what you are trying to achieve there might be a better solution.