Steve Jones - SSC Editor (9/21/2012)
If you central server is down, where is the data on backups? If your package has a bug, or can't connect to an instance, what happens to the data?
I understand what you mean. My only worry is the business will not allow me to setup these tables on each server. It was a struggle just to get them to agree to allow me to change the backup sproc so the master DB is also included.
But what you say is true. If the central server is down or unable to communicate with the other servers for whatever reason then the DBA who gets the reports will think that no backups were run the night before!
This is trickier than I thought.......
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn