Keep replication settings with SQL Backup

ruancra · August 14, 2014 11:08AM

Hi

Is it possible to preserve replication setting when backing up a database using SQL backup?

Currenty when we make a full backup of a Subcriber database, the replication procedures are not restored.

Using SQL Backup version: 7.4.0.23

petey · August 17, 2014 10:48PM

Could you please create an empty subscriber database, back it up using SQL Server, restore it, and check if the replication settings exist in the restored database? Repeat the same tasks, but using SQL Backup to back up and restore the database. Do the replication settings exist in the restored database?

ruancra · August 18, 2014 3:08AM

Hi

Did exactly that. Created a empty subscriber database, created replication to that database, backed up with normal SQL, restored and the replication procedures was there. (When restored I checked the option "PRESERVE REPLICATION SETTINGS", I don't see this option when restoring with Redgate.)

Then backup up and restored the same database with Redgate SQL backup and the procedures were not there.

petey · August 18, 2014 3:33AM

Can you try restoring the database using the SQL Backup extended stored procedure, using the KEEP_REPLICATION option e.g.

EXEC master..sqlbackup '-sql "RESTORE DATABASE test FROM DISK = &#91;g:\backups\test.sqb&#93; WITH REPLACE, KEEP_REPLICATION" '

ruancra · August 18, 2014 4:59AM

I restored using the extended stored procedure with WITH REPLACE, KEEP_REPLICATION' and the procedures were present.

Where is the option in the UI to keep replication settings?

petey · August 18, 2014 7:58PM

That option isn't available in the GUI. You will need to restore the database using the extended stored procedure manually with the KEEP_REPLICATION option.

Keep replication settings with SQL Backup

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk