Mirroring Scripts

When I setup mirroring between servers on SQL Server 2005 I use following scripts:

These scripts rely are designed and rely on following settings:

  • All servers exist in the same domain.
  • The service account that is used will be domain account that has access to all three nodes.
  • Scripts are designed for High Availability Mode.
  • They require a central backup location to backup the database and log file to for restore.

If you need to know how to setup security using Certificates please look at Microsoft MSDN page, link.

If you need to know how to setup Mirroring accross domains, please look at MSSQL Tips article, link.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.