Need a script to Backup multiple sql servers and sql instances or any other ways to do
Posted on 2008-11-07
I am using HP open view data protector as Backup software, unfortunately this application does not support backing up multiple sql instances or sql servers in a single backup job, I have have nearly 35 sql servers and 90 sql instances and its a kind of funny to create 90 sql jobs and scheduling each of them on a different time.
HP guys told me that i can prepare a script and run as a "Pre Exec and Post Exec" script on the backup job to backup multiple sql servers or sql instances on a single job with stopping and starting the sql services.
Please guide me to the right directon, Please throw me more queries and will provide you with all required information.