tstapenhorst (2/18/2010)
Good question Elliott. We wanted to have one management server manage all the SQL backups from one central server. That management server only has SQL Sever Client Tools installed; we are a school district with budget constraints on SQL licensing costs along with other costs. I didn't want to put a stored procedure on one of our SQL servers, and have to keep calling it to do the backups of all of our other SQL servers. Am I approaching this from the wrong direction?Thanks, Ted.
Ted,
I think another poster posted some good ideas. I *personally* would probably setup backup jobs on each server and use the management server to check and make sure that the backups occured. And I would probably use SSIS to do that check. But that is me.. Mileage may vary.
CEWII