Introduction Corporate needs for storage and access of critical data demand that data be available at all times with little or no downtime.Many of the corporate environments today make use of Microsoft SQL Server to maintain storage of such critical data. Thisdocument outlines the replication of SQL databases using VERITAS Storage Replicator ™ 2.1. Storage Replicator can be used to maintain real-time copies of databases stored in a safe location on the network. When the need arises, a standby SQLServer can be brought online, or Storage Replicator can be used to replicate the data to a working SQL server with minimaldowntime. Storage Replicator can be used to migrate data from one SQL Server to another. It is also possible to use aproduct such as VERITAS NetBackup to back up copies of the database files from the standby server. This capability is knownas off-host backup. This document describes several different approaches to replicating data maintained by SQL Server version 7.0 and SQLServer 2000. It describes the steps needed to replicate one or more databases, as well as the procedures to bring a databaseonline on a standby server. It also outlines the steps needed to migrate the data from one or more databases back to aprimary server when it comes back online.

» Free PDF eBooks Download
» Tutorial Database MsSQL