SQL Server Replication Questions and Answers

Recent IT Questions

1 - 20 of 21
<<PREVIOUS 1|2 NEXT>>

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.

View Answer   |  Nov 9 2009  5:19 AM GMT
SQL Server administration, SQL Server replication
asked by Shahi

  5 pts.

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...

asked by Db23

  230 pts.

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...

View Answer   |  Aug 6 2009  9:37 AM GMT
SQL Server replication, SQL Server 2005
asked by DNG

  55 pts.

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...

asked by SBatSI

  370 pts.

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

asked by BrentSheets

  6535 pts.

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?

View Answer   |  Feb 12 2009  1:40 PM GMT
SQL Server replication, SQL Server 2000, SQL Server 2003
asked by AtlantaRookie

  5 pts.

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...

asked by SuperCoolMoss

  140 pts.

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...

asked by Jah

  5 pts.

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?

View Answer   |  Nov 11 2008  7:10 PM GMT
SQL Server replication, SQL Server migration
asked by SQL Server Ask the Experts

  2445 pts.

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...

asked by SQL Server Ask the Experts

  2445 pts.

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...

asked by Db23

  230 pts.

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

asked by Krrish

  25 pts.

SQL 2005 to .XML

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

View Answer   |  Aug 21 2008  9:13 AM GMT
XML, SQL Server replication, SQL Server 2005
asked by Camofa

  5 pts.

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...

asked by Systems Channel ATE

  15 pts.

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?

asked by SQL Server Ask the Experts

  2445 pts.

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...

asked by SQL Server Ask the Experts

  2445 pts.

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. ...

View Answer   |  May 16 2008  2:29 PM GMT
SQL Server 2000, SQL Server replication
asked by Krajdba

  10 pts.

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?

asked by SQL Server Ask the Experts

  2445 pts.

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...

asked by MarkT

  35 pts.

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?

asked by SQL Server Ask the Experts

  2445 pts.

1 - 20 of 21
<<PREVIOUS 1|2 NEXT>>