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

    SBatSI415 pointsBadges:
  • SQL Server 2008 R2 replication

    Good Day. I configure Transactional Replication using SQL Authentication. The subscription account was added to the PAL and it belongs to the Sysadmin group and database_owner role. When I clicked on the VIEW SUBSCRIPTION STATUS and the result shows that the synchronization is working. I also...

    ABSA5 pointsBadges:
  • Unidirectional replication in SQL Server 2008

    Can transactional replication be bidirectional?

    Dougm10 pointsBadges:
  • International SQL Server Replication

    I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for...

    MattPoirier15 pointsBadges:
  • What is the best way to replicate SQL 2008 DBs to a failover site?

    We are looking to replicate our SQL 2008 databases to a hot failover site.  We can't use DB mirroring due to the number of databases we have.  Has anyone replicated databases to a hot site using a replication solution and what was your experience.

    DaveMPA55 pointsBadges:
  • Replicating a partitioned table to a secondary server

    I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Merge synchronization using only Sql Server Express 2005

    I'm developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won't have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge...

    RiverGuy5 pointsBadges:
  • 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.

    Shahi5 pointsBadges:
  • 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...

    Db23290 pointsBadges:
  • 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 due...

    DNG55 pointsBadges:
  • 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

    BrentSheets6,875 pointsBadges:
  • 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?

    AtlantaRookie5 pointsBadges:
  • 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 by...

    SuperCoolMoss140 pointsBadges:
  • 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 as...

    Jah5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 that...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Db23290 pointsBadges:
  • 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

    Krrish25 pointsBadges:
  • 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....

    Krajdba10 pointsBadges:
  • SQL 2005 to .XML

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

    Camofa5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following