Configure MS SQL server replication

h4. Configuring Disk Safe Tips

* Make sure all file systems for databases are available for replication. If any file systems for databases are not protected by Disk Safe settings and Devices found, then the system displays an alert message.
* Ensure that the SQL Server VSS Writer is included in the snapshot.



h4. Creating and Running a Policy

1. To create a policy, click *Settings* in the Main Menu and then click *Policies*. On the Policies screen, click the New Policy button.

The _Create New Policy_ window displays.

2. In the _Policy Settings_ tab, select the machine where your MS SQL Server is installed in the *Protected Machine* field. Choose an unassigned Disk Safe in the *Disk Safe* field. !Create New Policy window.png|border=1!

Access the _SQL Server_ tab.
2. In the _SQL Server_ tab, click the *Discover Instances* button to look for SQL instances on the protected machine. !Create New Policy - SQL Server.png|border=1!
{info:title=Note}
If no databases are found, a window displays the message "No Databases Discovered."
{info}


3. The system connects to the MS SQL Server and obtains a list of databases and corresponding .{{mdf}}/.{{ldf}} files. The activity can be seen from the "Processing" message. 

!Create New Policy_SQL Server tab_Discover Instances_Processing message_(not resized)_English.png!

4. When the Processing is done you can add individual instances for replication by selecting them from the *Database Instance* drop-down menu and then clicking the *Add* button.

5. Once the Instances have been added, they display in the _SQL Server_ tab.

{info:title=Note}
The "Delete" icon can be used to delete the Instance.
{info}


6. Alternatively, select the *Backup All Databases* check box. All databases will be discovered and backed up automatically.

{info:title=Reference}SQL Server databases use two types of files:
* MDF - Known as the primary database file, contains the schema and data.
* LDF - Contains the logs.{info}

Then go to the _Advanced Policy Settings_ tab of the _Edit Policy_ window and select the *Multi-Volume Snapshot* check box. If the SQL Server has files across more than one device, and the _Multi-Volume Snapshot_ option is not selected, the system displays an alert message.

7. Once the database instances have been added to the Policy, click the *Create* button. You can also click the *Create and Run* button to create the policy and run it immediately.

The Policy will be displayed in the Policies list.

See also [Restore an MS SQL Server to the original location].


{excerpt:hidden=true}Instructions on how to backup MS SQL Server database(s) in your Server Backup Enterprise and Advanced.{excerpt}