May 19, 2010 at 3:21 am
Hi,
I'm in the process of consolidating my old physical SQL servers to virtual SQL servers, which will result in several smaller servers, and with that several smaller instances.
My issue is now management of those instances, I would rather avoid having to create maintenance jobs for full, diff and tr log backup, checkdb etc. etc. But I can't seem to figure out how to manage this centrally, or how to create management templates which i then can roll out to my instances.
I would love to hear how you guys/girls are handling your SQL env, you have any ideas? 🙂
Cheers,
Rasmus
May 19, 2010 at 3:49 am
SSIS could be the answer for you.
Setup a "Global" job, with connections to each instance, with a Backup step.
You can host this job on a central server.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 19, 2010 at 4:23 am
Good idea, I'll look further into that. 🙂
Do you know; if I create a SSIS package to handle backup of a remote server, will the backup data flow: 1) from the remote server to the backup destination or 2) from the remote server, through the central backup server, to the backup destination?
Cheere,
Rasmus
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply