SQL Server Performance

Some operational mirroring questions....

Discussion in 'SQL Server 2005 Database Mirroring' started by sql_jr, Oct 25, 2007.

  1. sql_jr New Member

    Few things need to know. TIA Using HP asynchronous (manual failover) mirroring to our dr site.
    1. How does mirroring handle FT catalogs?
    2. If I'm mirroring from a cluster, and it fails over to another node does/would that failover cause the mirror to think its the principal? How can I mitigate this?
    3. SSIS packages - do I just copy the DTSx files to a same path on the mirror? How/do I need then to synch/mirror the msdb (can you mirror this db?)
    4. For SQLjobs, will it reflect on the DR server if I ran them?
    5. For testing, how would I bring the mirror online, and how to failback?
    6. where should I put the witness?
    Await expert replies [;)]
  2. satya Moderator

    1. http://msdn2.microsoft.com/en-us/library/ms191182.aspx and http://msdn2.microsoft.com/en-us/library/ms345600.aspx
    2. http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx, http://msdn2.microsoft.com/en-us/library/ms191309.aspx
    3.You have to copy the packages as the system databases will not mirrored or migrated, best to recreate them with a script.
    4. Same with Jobs as per step 3 recreate them but disable them.
    5 & 6 - see my presntation http://sqlserver-qa.net/tags/database mirroring/default.aspx?PageIndex=3

Share This Page