Problem creating peer-to-peer

• trans54

  Ten Centuries

  Points: 1357

  More actions

  October 6, 2009 at 7:58 am

  #226862

  Hi all,

  i am trying to create P2P between 2 nodesL fisrt node is sql 2005( node1) and second node is sql 2008(node2).

  This is what i did so far:

  1) on node1 i created transactional replication and configured for peer-to-peer.

  Also created distributor database.

  2) on node1 created backup of the database and restored on node2.

  3) connected to sql 2005 instance using ssms 2008 and trying to configure peers using

  "configure peer-to-peer topology" but when i select second option where you specify the backup use and click on browse and choose the backup file i got the error below from step2 when the job is running to create subscription.

  I am not sure why i am getting this error.

  Can someone please point to the right direction? i am stuck at this point

  i did also run this command in ssms to verify the backup and don't see any problems:

  RESTORE HEADERONLY

  FROM DISK = 'S:\BACKUPS\P2P_TEST.bak'

  Thanks

  SQL Server could not create a subscription for Subscriber 'SQL02\SQL02'. (Configure Peer-To-Peer Topology Wizard)

  ===================================

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)

  at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)

  at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()

  at Microsoft.SqlServer.Replication.Subscription.Create()

  at Microsoft.SqlServer.Management.UI.CreatePeerToPeerWizard.CreatePushSubscription(P2PProgressItem actionItem, Boolean& subscriptionAlreadyExists)

  at Microsoft.SqlServer.Management.UI.CreatePeerToPeerWizard.CreateP2PSubscription(P2PProgressItem actionItem, Int32 currentProgressRow)

  ===================================

  Could not locate backup header information for database '[SQLPREP01].[P2P_TEST]' in the specified backup device. Specify a backup device that contains a backup of the Publisher database.

  The subscription could not be found.

  Changed database context to 'P2P_TEST'. (.Net SqlClient Data Provider)