Managing backups using multiserver maintenance plans?
-
I am administering a group of SQL servers and I have been contemplating the option of using maintenance plans pushing jobs out to target servers in a multi-server environment to manage backup.
When creating the maintenance plan i set it to do a full backup at 6 am sunday morning on the "local server connection" placing the backup files on a common fileserver: \\fileserver\SQL_Backup\servername\ and it should generate folders for each database.
Saving this then generated the subplan as a job which can i assign to target servers.
(if my logic is not flawed)
The problem would then be that the "servername" is hardcoded from when i created the maintenance plan on the master server - does anyone know if it is possible to use a variable in the "backup" path when creating a maintenance plan subplan? Or... Should i just create different subplans for different servers and push each corresponding "subplan job" out to the server it is made for, or?
Does anyone have any experience trying to make something like this work? Good or bad
Hope someone has a few comments on this topic as I have not been able to find much information specifically on this.
-
Maybe you could make a SSIS package with a for each loop.
-
Use Package configuration that will allow you pass in variables and connection information to the package at run time
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply