SQL Server 2005 replication using a redgate backup file

• tew

  Ten Centuries

  Points: 1249

  More actions

  March 30, 2009 at 12:58 pm

  #201670

  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 = ' .sqb'

  Has anyone had any luck with this ?

  Thanks for your help!

• jboucher-832170

  Newbie

  Points: 9

  More actions

  May 20, 2009 at 4:30 pm

  #997990

  Hi

  this whould solve your problem

  CONVERT command

  A. Convert a SQL Backup file to a Microsoft Tape Format file

  -SQL "CONVERT 'C:\Backups\pubs.sqb' TO 'C:\Backups\pubs.bak' "

  http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=SQL_Backup\help\5.4\SBU_Toolkit_syntax_egs.htm