Database Mirroring Setup Procedure generator

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

weavol.gm Valued Member Points: 59 More actions · Answer 1

What is the purpose of this procedure -- to create a SQL Mirror?

Jefferson Elias Ten Centuries Points: 1379 More actions · Answer 2

Yes, it gives you a guideline for implementing database mirroring :

1. you backup your database you need to mirror

2. you restore your database on the off-site server

both FULL and LOG

3. Create end point and configure the database for mirroring on the off-site server

4. Create end point and configure primary server

It's what you can see in the GetProc cursor.

Hope this helps.

Jeff'.

Cookies on SQLServerCentral