| Thread | Last Post | Replies |
|
| Snapshot Folder Access: Merge Pull Replication w/ SQL Authenticati | 29 May 2009 20:47 GMT | 6 |
I am using merge pull replication with 10 subscribers and 1 publisher all connected with a VPN. They are not in a trusted domain so I am using SQL Authentication. The 10 subscribers are not trusted to see each others data so the snapshot folders
|
| The initial snapshot for publication 'publication name here' is not yet available. | 29 May 2009 18:54 GMT | 6 |
I have a publication, with 2 subscriptions, that is currently working fine. I added a new subscription to the publication, run the snapshot agent & when the subscription/dist agent runs, I get the message """The initial snapshot for publication 'publication name here' is not
|
| alter table | 29 May 2009 13:03 GMT | 2 |
i know to add a column to a table i have to use the sp_repladdcolum. My issue is on the publisher a column is defined as INT and allows nulls. the two subscribers have the same column set as int and allow nulls is not checked with the default value set as zero.
|
| How to set-up transactional replication from back-up | 29 May 2009 11:22 GMT | 6 |
I am looking for a step-by-step guide on how I can set-up a replication between 1 single SQL Server 2008 publisher and SQL Server 2008 subscriber. I am regularly taking full back-up of the publishing database. Distributor is already present on the publishing server.
|
| Cleanup Distribution jobs | 27 May 2009 20:06 GMT | 2 |
We have lost the common distribution cleanup/history jobs in an instance of SQL2005 (Clustered Enterprise). Trying to go back to backups to find copies has not proven fruitful, and we don't have a script saved. Is it possible to script out these jobs from a nother ...
|
| DEADLOCKED IN SQL SERVER REPLICATION | 27 May 2009 17:48 GMT | 3 |
I have a problem and I need help. I get this error in my sql server replication: "Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction".
|
| delete update information | 27 May 2009 17:39 GMT | 1 |
i have used: delete from msmerge_tombstone where tablenick in (select nickname from sysmergearticles where tablenick=nickname and name='utaudit') and
|
| TRANSACTIONAL REPLICATION: DEADLOCKED DISTRIBUTION AND CLEANUP AGE | 27 May 2009 17:34 GMT | 2 |
I have a problem with my transactional replication. I get a deadlok between distribution agent and clenup agent. How can I solve this problem??. Thanks.
|
| Query regarding setting up of a replication | 27 May 2009 17:24 GMT | 1 |
My environment ServerA -- TableA ServerB -- TableB (same schema as ServerA.TableA) Now whenever a transaction happens in TableA I want it to be replicated
|
| Any benefit from a new instance for replication/reporting db? | 27 May 2009 17:21 GMT | 1 |
I want to create a new database for reporting and the data will be replicated from our OLTP database. Is there any benefit if i use the the same instance as where the OLTP database is or should i create a new instance for the reporting database? I only have one machine ...
|
| Merge replication - SQL2005 but DB in 2000 compatible mode | 25 May 2009 21:39 GMT | 2 |
My application uses *= and =* as outter join, so, I had to create my db in SQL 2000 Compatible Mode, in order to run this application. But a question: The merge replication should work fine on Sql2005 using Sql2000 Compatible mode ?
|
| MergeSynchronizationAgent error: "Class not registered" | 22 May 2009 18:38 GMT | 1 |
I am attempting to initialize a pull merge subscription using the following code: --- ServerConnection sc = new ServerConnection(connReplicate);
|
| The remote procedure call failed and did not execute - Urgent! | 21 May 2009 15:30 GMT | 1 |
I am in desparate need of help, or shot, one of the two. I am at the finishing line of a project and now am a week late because of a replication error that has me totally stumped. I have set up replication between MSDE SP4 on local PC and MSDE SP4 on web server, on my Vista ...
|
| Unable to create Distributor via Wizard | 21 May 2009 15:02 GMT | 2 |
I'm trying to create a publication on a Windows 2003 server running SQL server 2005. I'm getting the following message when I try to create a disctributor: SQL Server is unable to connect to server '123abc'
|
| SQL 2000 Replication Stop / Restart Correct Steps | 21 May 2009 09:10 GMT | 1 |
I have a SQL Server 2000 database that I have set up with SQL Server 2000 merge replication to several locations. What are the correct steps to stop the SQL Server merge replication. What are the correct steps to restart the SQL Server merge replication.
|