Step 1
Click the Windows "Start" button and select "Programs." Click "SQL Server" and then click "SQL Server Management Studio." This is the application that allows you to mirror tables in your database.
Step 2
Right-click "Replication" in the left side of the window pane. Select "Configure Distribution" from the list of options. This opens the replication wizard.
Step 3
Select the database that distributes the tables. This is the "main" database that contains the records and distributes copies of your tables to a secondary server. Click the "Next" button.
Step 4
Enter a directory for the snapshot file. This file takes a snapshot of database transactions for distribution. This means that when a user adds a record to a table, a snapshot occurs in the log file to send to the secondary mirrored database. Click the "Next" button.
Step 5
Review the settings at the final screen and click "Finish." The replication server sends copies of the database tables to the secondary server on your network. You can then configure software on the network to use this secondary database or simply leave the server as a backup in case the main server crashes.