Hi Randy

Re your average run time per server job = backup time. I would, as you intimated, rather directly query the backupset table in msdb and do a DATEDIFF...

Hi Randy

Yes there is a way to convert an MSX job to a local job. But remember, with great power comes great responsibility. ;-).

In the msdb db on the target...

Re the 2012 / 2008 question. Yes, you can use a SQL 2012 MSX server and enlist 2008 R1 and R2 and SQL 2005 servers if you have those...

Hi

To stagger the jobs on the different target servers you would have to, in the 1st job step for example, have a 'randomizer' based on the host name.

Eg:

DECLARE...

What are some of the bigger MSX/TSX deployments out there? Are there upper limits? Has anyone done or seen large scale enterprise deployments?

I have published my solution on my blog:

No cursors and no undocumented system sp's. 🙂

This works really well for a list of 150 servers!

From the same web site:

http://www.sqlservercentral.com/columnists/dasanka/temptablesinsqlserver_printversion.asp

Basically a structure in Memory.  BOL has some good info and tips on a TABLE variable, one of those is that its cleaned up automatically...

Hi

When SQL Server reads data from disk from a data file, it does so in 64kb blocks, or the size of an extent. So setting the allocation or block size...