May 13

Configure SQL 2008 R2 Mirror – Part 1 – modify database + backup

Primul post in engleza:)

Pre-requirements:

–          2 machines installed with the same version of SQL enterprise

–          The same administrative accounts on both servers

–          Create a folder in root on both SQL servers ( C:\db_backup)

–          The principal database must be in FULL recovery mode

Log on the master SQL server with the administrative account
Go to “start menu”
Select “SQL server management Studio”

image006

 

Check that services are running with the right users/services accounts for SQL Server Configuration Manager.

 

image007

 

Go to “start menu”.
Select “SQL server management Studio”.
Check the server name, and then press “connect”.

 

image003

 

The main administration window will be available – connected to the sql server

image008

 

Right click on the database that we would like to mirror – in this example “Provisioning Services” database and modify the recovery model to “Full”

image009

 

Select the database, click right on it, go to “tasks” and select “backup”

image014

 

Select “full” from backup type
Click “add”

image011

 

Select the path c:\db_backup – should be previously created
Enter the name of the database backup as needed
Press “ok” twiceimage012

Repeat the operation for backup but in this new iteration select “transaction log” as backup type, and select the same destination  for the backup file.
The backup file name: “provisioningservices_translog.bak”.

image013

 

 

 

 

1 comment

    • Andreea on July 31, 2013 at 4:52 pm
    • Reply

    This is interesting! way to go guys!

Leave a Reply

Your email address will not be published.