January 6, 2011 at 6:19 pm
Hello All,
Yesterday my new boss gave me this assignment on SSIS , I am hoping some one of you might have gone through it or has an idea, since I am a junior DBA and new to SSIS any help with me on this will be greatly appreciated.
I have a test scenario of DR in the dev boxes in SQL2005 with DB mirroring. Set up a principal and mirror server both with same service account without any witness server with manual fail over when the need arises. Let’s say in our case principal is server A and mirror is server B.
(Was feeling pretty good about myself when did that ), but suddenly now my boss wants me to design a SSIS package in the case of DR will look for the databases in server A and failover them over to server B automatically.(without going to actually go to Task->mirror-> click the failover option manually). The job will run as needed and the package also needs to read the name of the databases (one or multiple) from a excel file.
Guys I hope someone please able to help me in this... … If you already have done something like that or know what to do please help me ASAP…
January 7, 2011 at 2:24 am
qur7 (1/6/2011)
Hello All,Yesterday my new boss gave me this assignment on SSIS , I am hoping some one of you might have gone through it or has an idea, since I am a junior DBA and new to SSIS any help with me on this will be greatly appreciated.
I have a test scenario of DR in the dev boxes in SQL2005 with DB mirroring. Set up a principal and mirror server both with same service account without any witness server with manual fail over when the need arises. Let’s say in our case principal is server A and mirror is server B.
(Was feeling pretty good about myself when did that ), but suddenly now my boss wants me to design a SSIS package in the case of DR will look for the databases in server A and failover them over to server B automatically.(without going to actually go to Task->mirror-> click the failover option manually). The job will run as needed and the package also needs to read the name of the databases (one or multiple) from a excel file.
Guys I hope someone please able to help me in this... … If you already have done something like that or know what to do please help me ASAP…
Please don't crosspost.
Original thread and replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1044104-148-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 10, 2015 at 4:46 am
Event i am looking for the same kind off solution to be implement. Please let me know,if anyone worked on this kind of solutions.
We can refer : http://blogs.msdn.com/b/mattm/archive/2012/06/19/ssis-with-alwayson.aspx
I have a thoughts like.
1. Setup Database mirrorng for SSISDB
2. Keep monitoring the state of the databases .
3 Wite a logic in SQL Agent jobs which can run the pakages whereever primary it is .
THanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply