1 / 10

Replication Magic: Initializing From Backup

Dive into the details of SQL Server's Replication Magic and learn about initializing from backup. Introduced in SQL Server 2005, this feature enables flexible replication strategies, especially for Very Large Databases (VLDBs). We'll address common misconceptions, highlight usage scenarios like log shipping conversion to transactional replication, and clarify initialization methods using log and filegroup backups. Gain insights on maximizing efficiency in database replication, including myths about compression and backup requirements. Slide deck and code samples will be available on my blog.

sarai
Télécharger la présentation

Replication Magic: Initializing From Backup

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Replication Magic:Initializing From Backup Robert L Davis

  2. Who am I? @SQLSoldier 11+ www.sqlsoldier.com

  3. Replication Magic: Initializing from Backup • Background • Use Cases & Misconceptions • Initializing from Log Backups • Initializing from Filegroup Backups

  4. Replication Magic: Initializing from Backup • Background • Introduced in SQL Server 2005 • Limited adoption for VLDBs due to lack of native compression • Should be widely used for VLDBs • Highly flexible

  5. Replication Magic: Initializing from Backup • Use Cases & Misconceptions • VLDBs • Myth: Cannot use compression in SQL Server 2005 • Myth: Must initialize with a full backup • Partial Database Replication • Myth: Must restore the whole database and then delete unwanted tables

  6. Replication Magic: Initializing from Backup • Initializing from Log Backups • Use case: set up log shipping then convert to transactional replication • Books Online correctly states: “… any recent backup can be used if it was taken after the publication was enabled for initialization with a backup.”

  7. Replication Magic: Initializing from Backup • Initializing from Filegroup Backups • Replicating select tables • Books Online incorrectly states: “A backup contains an entire database; therefore each subscription database will contain a complete copy of the publication database when it is initialized” • Can restore simply select filegroups • Partial database availability is an Enterprise-only feature

  8. Replication Magic: Initializing from Backup DEMO

  9. Replication Magic:Initializing from Backup Q&A

  10. Replication Magic:Initializing from Backup Thank You! Slide deck and code samples will be posted to my blog later tonight: www.sqlsoldier.com

More Related