SQL Server 2005 replication using a redgate backup file

twhitetwhite Posts: 3
edited April 1, 2009 9:52AM in SQL Backup Previous Versions
Greetings everyone,

I'd like to establish transactional replication in SQL Server 2005 by restoring a backup of the publisher on to the subscriber using SQL Backup (v5) file. The difficulty I'm encountering is that SQL Server cannot read the red gate backup file format (sqb).

Parameters for consideration when calling sp_addsubscription:

@sync_type = N'initialize with backup'
@backupdevicetype = disk
@backupdevicename = '<path>\<file_name>.sqb'

Has anyone had any luck with this ?

Thanks for your help!

Comments

  • Hi,

    A very easy work around for you can be using log shipping from SQL Backup. It is very easy to set up using the Log Shipping Wizard in SQL Backup UI. Not sure whether it satisfies your requirement or not but it does very similar thing like transactional replication. At initialization, it takes a full backup and restore at the destination. After that it takes log backup as per schedule (on source) and restores it as per schedule (to destination).

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
  • Thanks for your reply,

    The disadvantage with logshipping is that the db cannot be accessed whilst applying logs. This db will serve as a reporting db, instead of using our production db.
Sign In or Register to comment.