Replication Doesn't Replicate

Jul 8, 2004

Ok, I'm knee-deep in replication-hell.

I'm trying to set up snapshot replication between two SQL Server 2000 databases over the internet. Both servers run Windows 2000 server edition and SQL server 2000. The idea is to send certain local information, stored in database tables to a database from which the information is published on a website.

I've set up the distribution database (with the original name: distribution) and connected a publisher to it (let's call that one "source_database") using the sp_adddistpublisher stored procedure. No problems there...
Next step, I added a publication, the tables in source_database, and a subscriber, the website database. I've opened up port 1433 on both servers, but still it won't send anything from the source_database to the website database....

It gives no errors, but just doesn't do anything...
Now, I've looked for possible problems and I think these problems might be able to cause problems:
- The initial snapshot is not reaching the subscriber
- I've made a push subscription which may has to become a pull subscription
- The RPC's aren't available, because both servers are highly secured
- The wrong serverpack is installed (this one is a wild guess)

Does anybody have any idea on how I can get my distribution working or solve any of the problems above, cause I'm running out of idea's....
(P.S. I'm a bit of a noobie to replication, I've set it up in a test environment before and it just worked perfectly, but the real thing isn't)

View 4 Replies


ADVERTISEMENT

SQL Server Replication Error - Not Able To Replicate On Subsriber.

Jan 19, 1999

I am having two NT/SQL Server 6.5 and i tried to replicate the database on SQL Server from One Server to another Server.
When i try to replicate from Server A[Publisher] to Server B[Subscriber] it is giving error on Distribution History Log on Manage Scheduled Task Dialog.
The Error is like this :
08001 [ODBC SQL Server Driver] [dbnmpntw] ConnectionOpen (Createfile()).

and it is trying again and again by using retry option.

Kindly guide me by mentioning the reason for this error.

Email to : rsraja@sfl.soft.net

Regards
R. Suseendran Raja.

View 1 Replies View Related

SS2005 Replication: Can You Replicate Constraints Without Reinitializing?

Jan 11, 2007

We have a two SQL Server 2005 databases set up using Transactional Replication. My manager has asked me to set it up to replicate constraints (default, fk, et) on the tables in the main publication. I said sure, I can do it, but I will have to re-initialize the subscription. He said there was a way to do it without re-initializing the subscription. I cannot find anything in my research to indicate that there is a method to do so (via call sp_ functions, etc). Is it indeed possible to replicate constraints on replicated tables without re-initializing the who subscription? The reason he does not want me to perform a re-initialization is that we are a few weeks before moving into production, and a full re-initialization takes 1.5 days, which would impact system availability.

Thanks in advance for any advice.

View 1 Replies View Related

Replication :: Unable To Replicate A View Or Function

Nov 13, 2015

I have some issue when replicating a view (transactional replication).I have following objects on publisher:

Table: [Metadataschema].[Entity]
View: [dbo].[EntityLogicalView]
the view definition is:

create view [dbo].[EntityLogicalView] as (SELECT * FROM [Entity] WHERE OverwriteTime = 0)

this is what I get when I run "Script View as Create". The same query is used by the replication.Unfortunately this query fails on the subscriber "Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber". I cannot even runt his query manually on the subscriber, it only works when I change it like this:create view [dbo].[EntityLogicalView] as (SELECT * FROM [Metadataschema].[Entity] WHERE OverwriteTime = 0) Is there any way to get this working? Can I change the creation scripts used by the replication or force publisher to include schema names in all objects?

View 5 Replies View Related

Transactional Replication Setup To Replicate Views

Mar 20, 2007

Hello,

I setup the transactional replication to replicate remote database that has 50 tables.

Two of the tables with huge columns.

I splitted the columns by creating several views before running the initial snapshot.

Questions:

1. Can the database replication copy the views.?

2. Where the view will be stored at the subscriber database?

Thank you.

Edwin

View 3 Replies View Related

Replication :: Replicate Value Of A Computed Column Not The Formula

Jun 16, 2015

I'm trying to replicate client data from multiple databases into a single table. So database A, B and C replicate client data to a table in database Z. There is a settings table on A, B and C that holds the businessID and I use a function in a computed column to add this to the client table. At the moment I have just database A and Z as a test and what happens is the computed column gets replicated as a computed column with the formula. 

Can I change this so that I can replicate the computed value (at db A,B,C) of this column?

I don't really want to add a businessID to the table if possible as I'm going to need to add a number of other tables to this replication which will each need to have the businessID, a computed column would be much easier and save updating a load of scripts.

If the above is not possible is there some other solution available so I can identify which database the records came from in the table on database Z?

View 4 Replies View Related

Merge Replication Replicate Master And Related Tables

Jan 19, 2007



hi all,

Could we configure a merge replication such as replicate the master table and its all related tables (relation deep could be 1.)

We dont want to manually find master table relations and configure replication for the related tables.

please help for that configuration

kinds

View 5 Replies View Related

Replication :: Replicate DDL Setting Is Not Working If Multiple Subscribers Are Used

Oct 22, 2015

Replicate ddl setting is not working if multiple subscribers are used...

View 2 Replies View Related

Replicate Ntext Text Image In Transaction Replication

May 16, 2007

Hi!

i have a problem with my replication.

I have two SQL 2005 SP2 Server and want to use the transaction replication with updateable subscriber. Now the problem is that i can do any changes on the master server. But if i want to change a record on the subscriber which contains a ntext, text, oder image column - then i geht the error that the field will be NULL on the master.



Is there any solution to fix this problem? I dont wan`t to change the datatype vom ntext to varchar(max) !!



greetings

Holger

View 3 Replies View Related

Replication :: Replicate All Data From Remote Locations To Central Location

Aug 29, 2015

there are several remote locations where sql is running, my company has asked me to find a way to collect all the data from the remote locations to a central location automatically,for example day to day data should be synced at night time from 2am to 7 am and it should be compressed automatically before data transfers to the central location. NOTE there is no domain only standalone workstations

View 3 Replies View Related

Replication :: Replicate Multiple Databases (publications) To One Central Subscriber?

Sep 2, 2015

We need to replicate multiple databases (publications) to one central subscriber. The schema of those articles are identical in all publications and also the primary keys in publications do not have any overlap.

Is this possible?If yes is there any specific thing that I should consider for it's implementation? Should each publication has it's own dedicated distributor or all of them can share one distributor?

View 2 Replies View Related

Replication :: Replicate Data From 3 Publishers To A Single / Central Subscriber Transactionally?

Oct 15, 2015

Is it possible to replicate data from 3 publishers to a single/central subscriber transactionally? In other words I have Server A, Server B, Server C with databases A,B,C respectively. I need to replicate 2 articles from A,2 from B and 2 from C to a central Server D that hosts database D. D will have only 6 articles. The replication is Transactional Replication.

If it is possible what will be the drawbacks of such implementation? (if one server goes down will the whole replication break?) If not possible then what is the best way of implementing this?

View 3 Replies View Related

Replicate Schema/Replicate Data Only

Sep 7, 1999

Using SQL 7.0 I'd like to replicate just schema from DB on server A to DB on server B, then be able to replicate data only form DB on server B to DB on server A. I need help!!

Thanks for ANY information you can give me...
~Jepadria

View 2 Replies View Related

How To Detect Replication Doesn't Work And Get Noticed?

Jul 15, 2004

I want to get notice by netsend, email or any other methods
when replication doesn't work or malfunction.

Does anyone know how to do this or any other solution you use for this kind of issue?

Thank you..

View 9 Replies View Related

Merge Replication Between MSDE Doesn't Work!

Sep 4, 2006

Hello!

I have a problem with creating Merge replication between two instances of MSDE 2000. In the article http://support.microsoft.com/kb/324992/, published by Microsoft, described, that it is possible.

I am creating Merge Publication at MSDE 2000, with Distributor and Publisher configured at same machine, with options "Allow Pull Subscriptions" and "Allow Anonymous Subscriptions". There is no problem with creating of Publication. Even snapshot generation finishes successfully. Also I create a login with SQL Server Authentication and "System Administrators" database role at the publisher in order to connect to it from Subscriber.

The problem occurs, when creating anonymous pull subscription to this publication at another instance of MSDE. During initial synchronization an error occurs:

The process could not connect to Distributor '<publisher_server_name>'. Login failed for user '<login_created_at_publisher>'. Reason: Not associated with a trusted SQL Server connection.  The step failed.

Although I didn't use Windows Authentication at all, so Subscriber doesn't need to connect to Distributor using trusted SQL Server connection.

What is a problem and how can I workaround?

Note: The same works correctly, if MS SQL Server used as a Publisher instead of MSDE.

Please, help!

I can provide publication and subscription creation scripts, if required.

View 1 Replies View Related

Replicate To Other Server If Replication With Main Server Failed ...

Aug 16, 2007



Let say I've 4 server with MS SQL 2000 installed and I want all of them having the same data. So I'm using merge replication by assign one of them as publisher/distributor.
The problem is when ( let say ) server that have been assign as publisher/distributor down then all the other server cannot make replication.
My idea was to make it replicate to other available server ( among them ) if replication to main server failed.
Is it possible ?
If possible how to do it ?

Thanks.

View 1 Replies View Related

SQL 2012 :: Replication - Distribution Database Doesn't Appear Under System Databases

Oct 30, 2014

I just finished installing SQL Server 2012 with the SQL Server Replication feature component checked. On configuring transaction replication, i notice the distribution database wasn't there. I ran the below query

EXEC sp_get_distributor And the value for distribution_db_installed is 0 as shown below

installed distribution server distribution db installed is distribution publisher has remote distribution publisher
0NULL000

View 1 Replies View Related

Stored Procedure Doesn't Recompile After Replication Updates Underlying Tables

Mar 21, 2007

We have on demand snapshot replication set up between 2 servers. When the subscriber applies the snapshot, our stored procedures start executing very slowly. Updating statistics and rebuilding indexes does not resolve the problem, however; executing sp_recompile on the affected stored procedures does fix the problem. Is this a known issue with replication? Is there a better workaround than manually recompiling stored procedures after every snapshot?

View 3 Replies View Related

SQL 7 Replicate Then FTP ?

Aug 18, 2000

I am new (very new) to SQL. I 'm trying to set up SQL 7 to replicate a particular table on a daily schedule and then FTP the file out to a remote directory. Sounds easy! I'm sure it is, I just need someone to walk me through the steps.

If anyone can help me out I would really appreciate it.

View 2 Replies View Related

Why Can't Replicate?

Jul 9, 2004

Hi my friends,

I'm replicating with SQL Server 2000(updated Service Pack 3) get error:

SQL Server Enterprise Manager could not configure 'BREEZE1' as the Distributor for 'BREEZE1'.

Error 14113: Could not execute "'"C:program filesmicrosoft sql server80 ools\binnosql" -E -l60 -t60 -d"distribution" -b -i"c:MSDESQLBinnMSSQL\installinstdist.sql" -o"c:msdesqlinnmssql\installinstdist.out"'". Check 'instdist.out' in the install directory.
'distribution' is not configured as a distribution database.
Deleting database file 'c:msdesqldatamssqldatadistribution.ldf'.
Deleting database file 'c:msdesqldatamssqldatadistribution.mdf'.

I have a feeling this is failing because I have not C:msdesqlinnmssqlinstall directory at all.

Is there something I'm doing wrong...If the SP3 can affect???

View 1 Replies View Related

REPLICATE

Oct 4, 2007

This code :

declare @filenumber as char
set @filenumber = '65'

declare @filenu2 as char(6)

set @filenu2 = CONVERT(CHAR(6),(replicate('0',(6-len(@filenumber)))+ @filenumber ))

select @filenu2 as x



This should return 000065
but it returns 000006
i have stepped through it the replicate should replicate the 0 4 times
(6 - len of @filenumber) instaed its doing it 5 ??

View 8 Replies View Related

Can Not Replicate DDL Changes

Jun 6, 2007

Merge replication. We switched a publication over from push to pull and are now initiating everything within an application. We have just encountered a situation where it is now completely impossible to replicate DDL.



When this was a push subscription, we could execute the following and it would fly straight through the engine and hit every subscriber without having to do anything at all:

ALTER TABLE <tablename>

ADD <columnname> <datatype> NULL



Now that it is a pull subscription when I issue an ALTER TABLE and add a nullable column to the end of the table, it does NOT replicate at ALL. We get the following error message:




The schema definition of the destination table 'dbo'.'Player' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot after ensuring that the schema definition of the destination table is the same as the source table. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199478)
Get help: http://help/MSSQL_REPL-2147199478

The process was successfully stopped. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199481)
Get help: http://help/MSSQL_REPL-2147199481

It apears that we are now required to either reinitialize every subscriber every time we add a column or we are required to first distribute the DDL change to each subscriber, make sure they all have it, then add it to the publisher before anyone replicates, and then reinit every single one of them without a snapshot. This makes absolutely no sense at all.



The interesting thing is that we can add articles at will and those get applied with absolutely no problems at all to the subscribers without having to do anything other than add the article and generate a new snapshot.



Version 9.00.3042.00

View 8 Replies View Related

What Is The Best Way To Replicate Data?

Oct 18, 2006

Hi everyone, I've recently been thrown into a DBA role (I've never done any DBA work except writing a few SQL queries), so please go easy on me if these are stupid questions. My first task is to find the best way to replicate data between two SQL Server production databases. The data is to come from Production DB #1 to Production DB #2 (for access by a different system). The data has to be super-close -- not necessarily real-time, but within a few minutes. So when data is updated in #1, #2 shouldn't be be lagged by more than 45 minutes (5-10 is ideal). There are hundreds of thousands of records.What would be the best way to do this? Are there options in SQL Server 2005 to do "differential" updates from DB1 to DB2? Or is that how "transactional replication" works?  If we were to implement a "full recovery model", will this impact any sort of replication? Thanks.  

View 2 Replies View Related

Replicate To Laptops??

Mar 30, 2001

WE have a production database that we need to sync with about 100
salesman's laptops. These laptops will not always be online and
would need to sync on the fly.

We are thinking of having a separate distribution database to handle
the load and creating either a pull subscription or even just a DTS
package. We would like to have the salesmen just signon and go to an
ASP page and hit an Icon and either the pull subscription or the dts
package would start the sync..

Anyone tried this before and have any other ideas??

Thanks for any help??
SB

View 2 Replies View Related

Trans Rep Will Not Replicate

Jun 18, 2001

I have set up a simple trans rep from a server in the office to the web. both servers are NT4sp6aSQL 7.0. Tables only.

The publication and distribution db are on the server at the office, and there is a full time connection through the firewall.

The initialization and first replication works perfectly, but after that, there is a message from the snapshot agent that "no subscriptions needed initialization", the logreader says thare are no replicated transactions and the Distribution agent says there are no replicated transactions. What am I missing?

Thanks in advance

View 1 Replies View Related

What Is The Best Way To Replicate The Data?

Nov 15, 1999

Hi, there
I have a situation here....
I have Production DB and Development DB in the same SQL7.0 box....
I want to update the data and SP from Pro. to Dev at least once a day...
So this is my plan.

1. Back up(Pro.) and restore(Dev.) so I can have the same DB in the same box.
2. Using a Replication (Pulication and Subscription) ro update the data and SP.
3. Because DTS can not update the SP, I use the replication instead of DTS.
I need to update the SP, too..(Front end is ACCESS and backend is SQL7.0 DB)

Is there any other methods or way to make ti happen... Any suggestion can help...

Thanks in advance

Jay

View 2 Replies View Related

LogShip/Replicate

Jul 9, 2004

Can you have a database setup for both replication to server A and log shipping to server B?

Thanks,
Ken Nicholson

View 1 Replies View Related

Couldn't Replicate ???

Jan 4, 2006

Hi,

I'm new to replication.
I configured Server named TESTER as publisher & distributer. Create new publication for database named TEST ( type : Transactional ), then Create a new push subcriptions for database TESTREPLICATION ( on the same Server : TESTER). Then I open a table in database TEST to input some data but I couldn't see any tables or data in database TESTREPLICATION ( I chose Continuously, not scheduled).

Yet, after the lunch, I could see the tables, no data. I tried to choose Start Synchronizing but not helped.

Please tell me if I configured incorrectly ?

Thanks,

View 7 Replies View Related

Replicate MS SQL 6.5 DB In Oracle 10.2.0

May 27, 2007

Could someone please point me in the direction on where to look for info on how to:
Replicate an MS SQL 6.5 tables on an Oracle 10.2.0 server every 5-10min?

View 4 Replies View Related

How To Replicate Login Changes?

Aug 10, 2001

Hi:
In the publishing server, admin users could change and non-admin user password and also add login and drop login.

How could it happen to not only replicate the application database to subscriber server but also replicate the changes made in master database?
So that the remote subscriber server will have the most current login updates?

thanks
D

View 1 Replies View Related

Replicate Tables

Oct 18, 2007

Hi,

When I'm using MS SQL transactional replication and select all the tables to be replicated, some of the tables are marked with the red cross signs and aren't being replicated. How do I include these tables into the MS SQL replication? I tried to build indexes and re-created publications, but it didn't work.

Please help!

Thanks in advance,
-Alla

View 1 Replies View Related

How To Replicate A Database

Dec 3, 2012

Is any tool is available for replicating the Microsoft sql database..

View 1 Replies View Related

Replicate With New Table

Jan 30, 2007

Hi all, I have done the replication its working good.Now i have created the new table in publisher. but i have created the same table in sub scription too. how can i replcate this new table..?


Thanks
Krishna

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved