|
2 databases merge at night
|
| |
Is it possible with any version of SQL server to have 1 database in headquarters and 1 db in a remote site and have them do a scheduled merge everynight over the vpn connection. Both sites will access (read/write) thier local db during the day? Thanks for any help
|
|
|
Making single table snapshot using sql server 2005 enterprise
|
| |
I have created a publisher and snapshot some of the tables, which are published to a subscriber. Now I would like to snapshot a single table for this publisher. I checked the table and start the snapshot agent, but it starts to snapshot all the tables taht were snapshot before. Is ther some way to do this without doing a... more »
|
|
|
Field size too large error
|
| |
While applying the snapshot to the subscriber, I get an error saying The process could not bulk copy into table '"dbo"."MSmerge_contents"' and then "Field size too large" Can some one give an explanation about this error? The publisher is SQL Server 2005 Std (SP2), the publication is partitioned... more »
|
|
|
Error in replication
|
| |
Hi, We have a merge replication system in place. Remote users synchronize their database. Suddenly one of the user is getting the following error: Synchronizing your database to the Master database -- 8/26/2008 3:50:35 PM Setting up to Sync non-PWO tables from Master to Laptop. Copying selected data from Master database to Your database using... more »
|
|
|
Timing problem running sp_addsubscription programatically
|
| |
We use a DBUpgrade program to maintain our database schemas. Part of this process is to configure replication. On our test servers we often configure the publisher, subscriber and distributor on the same physical server. When doing so we are bumping into a timing issue with sp_addsubscription.... more »
|
|
|
Manage Subscription Files
|
| |
Greetings, I am new to replication and have not been able to find a topic on managing the size of a publication. I have a snapshot setup of SQL 2005 and a subscription which are working fine. The files in REPLDATA though will continue to accumulate over time, filling available space. Other than... more »
|
|
|
Help to Remove Replication
|
| |
Distribution database files were lost because of the disk failure. We decided to remove completely replication from the server. I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication I also run delete msdb..msdistributiondbs After all, I do not have any records in select * from master..sysservers WHERE srvname = 'repl_distributor'... more »
|
|
|
Can't change server name for publication & subscription
|
| |
I have two SQL servers, one that publishes parts of a database to another SQL server to help offload some of the work. Tonight i am renaming my SQL server with the subscription, but when i look at the properties for the Publication on the other server, the old server name is in there, and it's grayed out so... more »
|
|
|
troubleshooting Transactional Replication Latency
|
| |
Hi everybody. SERVER_A: Windows 2003 Server with SQL Server 2005 SP2. This is the corporative server for all our data. About 30 tables divided in 4 publications. Each publication contains the tables belongs at the same database. This is the suscriber of one publication I describe below. SERVER_B: Windows 2003 Server with SQL Server 2005 SP2. This is the... more »
|
|
|
