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
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
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.
15 People are following this question.
