March 27, 2008 at 10:08 pm
HI all I am trying to implement mirroring. But we can't mirror the system databases how do we maintain the consistency between parent and mirror when we failover lets say we have login information and dts packages in msdb databases how would they be available on the mirror server.
what about all the ssis packages and jobs will they run as good as they run on the parent.
Will be thankful for you resposnes.
🙂
March 27, 2008 at 10:31 pm
Make sure that the mirror server instance has the identical jobs, logins, SQL Server Integration Service (SSIS) packages, disk partitions, file locations, and server configuration as the principal server instance. Configuring the mirror server exactly as the principal server will enable the mirror server to function the same way as the principal server does
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 28, 2008 at 4:40 am
You have to set up the synchronization of logins, jobs, operators, alerts etc. yourself. The easiest way is creating SSIS packages and schedule them.
With jobs it might als o be necessary to disable them on the mirror until a failover occurs.
About the SSIS packages themself I would store them on a file share instead of the mdsb. If the share is accesible from both the principal and the mirror, you might not need to change a thing.
[font="Verdana"]Markus Bohse[/font]
March 28, 2008 at 9:55 am
I agree with Markus. You can make use of Transfer Job Task in SSIS to transfer all the jobs from principal server to mirror server. Refer this link regarding the same, http://msdn2.microsoft.com/en-us/library/ms137568.aspx
Regarding logins you need to create all the logins same as in principal server in the mirror server using Create login with SID option as shown in the below link, http://www.mssqltips.com/tip.asp?tip=1166
so that in the event of failover you don't need to map the same using sp_change_users_login
[font="Verdana"]- Deepak[/font]
February 16, 2010 at 3:28 pm
if you cant make it similar to principal then the name should not be mirroring....isnt it :w00t::w00t::w00t:
----------
Ashish
February 19, 2010 at 3:36 am
ashish.kuriyal (2/16/2010)
if you cant make it similar to principal then the name should not be mirroring....isnt it :w00t::w00t::w00t:
Can't make any sense out of that. What is your point, please?
Seems an odd thing to post to a thread where it has been almost two years since the last reply.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply