Setting Up Database Mirroring

• Chris Kitchen

  Hall of Fame

  Points: 3090

  More actions

  September 5, 2007 at 1:36 pm

  #120378

  Hi,

  I am running SQL Server 2005 Enterprise Edition on Windows 2003 Advanced Server.  I will be setting up "High Performance" (due to physical distance between the data centres) SQL Mirroring for 30 databases on the live SQL Server instance to a seperate DR instance.

  I have a couple of questions:

  1. Do I only need to confirgure the endpoints once on the principle instance, and then the mirror instance?

  2. I recently viewed a TechNet webcast by Kimberly L. Tripp on SQL Mirroring and she ran a script that setup mirroring.  I am looking for a script to setup "High Performance" mirroring to give me a starting point for creating my own script.  I was unable to find Kimberly's script, can anyone recommend any good ones?

   

  Thanks in advance.

  www.sqlAssociates.co.uk

• SQLHAWK

  Right there with Babe

  Points: 716

  More actions

  September 6, 2007 at 9:56 am

  #731906

  The answer to your first question would be yes. And within SSMS you can do both within the same task. See below.

  For the second question: I would recommend using SSMS, click on the properties of a database to be mirrored, click on mirroring, fill in the fields and then click on the script button at the top which should generate the script necessary to create the mirroring.

• Chris Kitchen

  Hall of Fame

  Points: 3090

  More actions

  September 6, 2007 at 11:34 am

  #731940

  Thanks for your comments, much appreciated.

  www.sqlAssociates.co.uk