Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naki
Starting Member
1 Post |
 Posted - 2007-02-08 : 05:29:00
|
| Hello,I have a sql server 2005 ent editon in one my server. Then I rent another dedicated server in another hosting company and want to do a peer-to-peer repliaction so that both can serve website visitor for load balancing.http://msdn2.microsoft.com/en-us/library/ms152536.aspx#I read the tutorials and start doing the replication by backuping the database and restore it to the new server. Since I do not want any downtime for my website so that I select the second options says the database has modified after the backup is created. When I click OK to create the Peer-to-Peer replication I received:Building the Peer-To-Peer Topology...- Creating publication on 'EV1SERVE-XQSEQ6.NTest' (Warning)MessagesThe publication or its Log Reader Agent already exists and will not be modified. (Configure Peer-To-Peer Topology Wizard) - Creating publication on 'SERVER14.NTest' (Warning)MessagesThe publication or its Log Reader Agent already exists and will not be modified. (Configure Peer-To-Peer Topology Wizard) - Creating subscription for 'SERVER14.NTest' on 'EV1SERVE-XQSEQ6.NTest' (Warning)MessagesThe subscription or its Distribution Agent already exists and will not be modified. (Configure Peer-To-Peer Topology Wizard) - Creating subscription for 'AAA' on 'BBB' (Error)MessagesSQL Server could not create a subscription for Subscriber 'AAA'. (Configure Peer-To-Peer Topology Wizard)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Could not locate backup header information for database 'BBB' in the specified backup device.The subscription could not be found.Changed database context to 'NTest'. (Microsoft SQL Server, Error: 18782)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=18782&LinkId=20476 Any idea?Thanks,Naki |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2007-02-19 : 18:04:35
|
| Did you specify the backup file that you used to create the subscriber database? SQL Server will do a RESTORE HEADERONLY on the backup file to find the LSNs it needs to replicate over.JonHolding it down on the engineering tip, y'all!http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
V-Nest
Starting Member
10 Posts |
Posted - 2008-08-12 : 17:47:47
|
| I have the same error message. Did you be able to resolve the problem? Any suggestions? |
|
|
|
|
|
|
Peer to Peer replication