SQL Server Replication

SQl Server Replication Internals

Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.

Replication sync_method set to concurrent in SQL Server 2000

Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

SQL Server 2005 - Unable to Eun a Pull Subscription due to "unable to connect to distributor" error

I have 2 Windows server (Windows Server 2003) running SQL Server 2005. Server 1 is the distirbutor and publisher. For a snap-shot replication, I have no problems running a push subscription from server 1 to server 2. However when I try to set up and run a pull subscription on server 2. It fails...

Looking for detailed synchronization logging in SQL Server 2008

We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

SQL Server replication fails after renaming Subscriber database

Running SQL Server 2005 on Windows Server 2003. Can the subscriber database to my publication be renamed? Experimented with renaming a test database but replication failed. Thanks. Moderator Note: This is a user submitted question

Can you replicate SQL 2003/8 to SQL 2000

I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

Fill factor on subscriber

Hello, We have an OLTP application for which a majority of the database's tables are replicated between two environments. The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application. The subscriber therefore is mainly read...

Syncronizing between Distributor and Subscriber in Merge Replication

HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to act...

Migrating SQL Server replication from one server to another

We are migrating our SQL Server from one server to another; is there a way that replication can also be moved from source to destination?

Using the snapshot feature in SQL Server 2005 to replicate an operational database

We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply...

Is it possible to copy system DBs to another server?

Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

Copy old database as new

Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

SQL 2005 to .XML

How do I automate 2 sql servers to replicate .xml files

Problems replicating SQL Server 2000 table

I'm having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

Complications in snapshot replication from a SQL Server database

I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?

Looking for best way to have SQL Server data security, replication as well as security maintenance

I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...

Replication Logreader error. SQL Server 2000

Hi I am using SQL Server 2000 replication , I have separate publisher,distributor and subscriber servers running on SANs. I get below error and synchronization gets struck, becuase log reader could not read data from the publisher db. Could you give me a quick fix for this error. ...

What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

full-text replication SQL Server 2000

I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

Do you have to break the replication after you install a service pack in SQL Server 2005?

In SQL Server 2005 when you install a service pack - do you have to break the replication as you did in SQL Server 2000 - and then reestablish the replication?