MS SQL Server Prerequisites

Peer DRS Help > Replication Modules > MS SQL Server > Creating an MS SQL Server Replication Job > MS SQL Server Prerequisites

1.	Identify the replication / log shipping pairs (i.e., the primary database & target database combinations that you want to replicate) and what type of replication you plan on employing for each target:

a)	Backup Only (no targets).

b)	Backup and remote file copy.

c)	Backup and restore to warm standby server.

d)	Backup, no file copy, and restore to a warm standby server (Backup Folder and Target Copy Destination Folder are the same).

2.	Make sure you have proper network access between the machine Peer DRS is running on and all Primary and Target Databases.

3.	Install MS SQL Server on all applicable target machines.

The user account that the Peer DRS application is running under must have read-write permission to any drives or network shares being utilized, and the user account that all participating database instances are running under must have write access to the configured local directory or network share. See the Security Model & Permissions section for a more detailed explanation.

Create a primary share for the Backup Folder in which the primary database's backup and transaction logs will be stored. This directory needs to be accessible on the machine where the Primary Database Server instance is installed. This Backup Folder can be a local folder if you are going to install the Peer DRS application on the same server as the MS SQL Server instance, if not, it will need to be a network share.

Create a share or appropriate directory based on the Target File Copy method you plan to use (e.g. network share, ftp, sftp, ssh) for all target server(s) to which you plan to copy and restore the backup and transaction-log files to. If using a network share then you must grant permissions on these folder shares to the user account that the Peer DRS application will be running under, or else grant permission to the account that you configured under the file copy settings.

5.	Decide how to create and initially replicate the target database(s). Peer DRS can automatically create all target databases if they are not already setup, otherwise you will need to create the target databases on the target server.

Note: You should also take a look at any other MS SQL Server specific requirements in the MS SQL Server Requirements section.