Keep replication settings with SQL Backup

• 
  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?

  petey August 17, 2014 22:48

  - 0 +
• 
  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.

  ruancra August 18, 2014 03:08

  - 0 +
• 
  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 = [g:\backups\test.sqb] WITH REPLACE, KEEP_REPLICATION" '
  

  petey August 18, 2014 03:33

  - 0 +
• 
  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?

  ruancra August 18, 2014 04:59

  - 0 +
• 
  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.

  petey August 18, 2014 19:58

  - 0 +

Add comment

Please sign in to leave a comment.