question

ruancra avatar image
ruancra asked

Redgate SQL backup, not backing up Replication procedures

Hi all We use Redgate SQL backup to backup all databases in our company. We are also backing up databases enabled for replication. I noticed that after backing up and restoring a subscriber database, the replication procedures are missing, only user procedures are restored, also tried running the script below but no luck. EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE DatabaseName FROM DISK = ''E:\Backup\DatabaseName.sqb'' WITH KEEP_REPLICATION' Using Redgate version 7.4.0.23 and SQL 2012 Standard Any idea why this is happening? Thanks
backupsql2012redgate
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
stanori avatar image
stanori answered
Hello, The restoring of the Replication functionality also involves the restoring of the system DB's, MSDB and Master databases when utilizing backups from Red Gate's SQL Backup Pro (Same as in the native SQL Server backup and restore). This is due to how SQL Server stores the subscriber settings for Replication in those system databases. Check out the following Technet article for strategies on restoring Replication and subscriber databases: http://technet.microsoft.com/en-us/library/ms152560(v=sql.110).aspx Another helpful link: http://msdn.microsoft.com/en-us/library/ms151152(v=sql.110).aspx Also, the KEEP_REPLICATION keyword in Red Gate's SQL Backup Pro is used exclusively for log shipping scenarios: https://documentation.red-gate.com/display/SBU7/The+RESTORE+command#TheRESTOREcommand-RESTOREKEEP_REPLICATION Hope this helps! Steve Red Gate Product Support
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi This answer is not accepted. I have setup a empty subscriber database and replicated a few tables to it. Then backup the database with normal sql, restored and the replication procedures were there. But, when the same database was backup and restored using Redgate SQL backup, the replication proceduires were not there. Please assist.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.