MS-SQL’s built-in replication capabilities

MS-SQL’s built-in replication feature is designed to publish periodically updated, read-only copies of selected data. It is not designed to provide data protection or application availability to the entire database.
The built-in disaster recovery capability provided by MS-SQL is called ‘log shipping’. This technique assumes that a recent copy of the database exists, possibly on tape, [...]

Read Full Post »