Change Publisher Server

May 11, 2004

I have transactional replication on SQL2000 with 60 subscribers.
For disaster recovery procedure i need to establish new replication within 15 minutes on another server with same subscribers.
Can i just confogure another DB as publisher and connect exist subscribers to new publisher ??

ThanX.

View 2 Replies


ADVERTISEMENT

Disabling Merge Distribution Change My Table Definitions At Publisher

Mar 12, 2007

I have merge replication between sql 2005 SP1, and when I disable distribution from my publisher, my tables with identity columns change the property "Not for replication" to "NO", does somebody knows if this is a known problem ?

Other information : the compatibilty level for database is 2000.

View 1 Replies View Related

Change A Merge Subscriber To Become A Merge Publisher

Aug 16, 2004

Hi,

I'm using merge replication to maintain a backup copy of my main (publisher)MSDE database. A push subscription periodically (1 per minute) updates the backup DB.
It's intended that if the main db goes down then the backup (subscription) db can be configured as a publisher. This must all be performed via scripting.
The initial configuration of the main publisher and subscription is controlled via scripting, which works fine.
The problems occur when I try to configure the subsciber to become a publisher. A script is executed on the subscriber but fails at the point when it's configuring the publisher detail. The error is something like "unable to configure a publication for a database setup as an anonymous subscription".
I'm guessing that there are subscritpion artifacts added to the database which need to be removed before it can be configured as a new publisher.

Please help,
Jez W

View 1 Replies View Related

Publisher Is Empty Under Replication Monitor - Publisher.! But Replication Is Still Running Fine..

Nov 9, 2006

I have a wired situation..!I set up transactional replication on one of my development server (SQL2000 Dev Edition with sp4).It is running fine without any issues and all of a sudden, i noticed inmy repication monitor tab under Publisher where I usually see thepublication is empty now.I do see the snapshot agent, log reader and distribution agent under myagents inside the replication Monitor. But its usefull to see all 3agents in one window under publisher before. What happend? Is there anyway to get that inside that monitor? Has someone encountered thissitation before? Please advise....After that I tried to create a new set of replication on differentdatabase on the same server and i dont see those either underReplication Monitor - Publishers....All it says is (No Items)....I would appreciate any help to correct this issue... Thanks in advance..

View 2 Replies View Related

Unable To Create Subscriber On A 2000 Server From A 2005 Server Publisher

Dec 1, 2006

Hi,

I'm trying to set up a transactional replication from SQl Server 2005 to SQl server 2000. The Distributor and the publisher are on our server and the subscription is supposed to be on a SQL 2000 server on a different location. Before upgrading to 2005 I didn't have problems - the replication from 2000 to 2000 was working perfectly.

After I succesfully created the distributor and the publication the first problem that I encountered was that when I tried to create the subscription it was giving me an error that I cannot use an IP to acces the server. I realized to fix that issue by creating an Alias in the SQL Server Configuration Manager for the server where I wanted to create the subscription (a push subscription).

Now when I try to add the subscriber it gives me another message "Execute permission denied on object 'sp_MS_replication_installed', database 'master', owner 'dbo'" - so I cannot create the subscriber.

The user that I use to create the subscriber on the 2000 server is dbo for the subscriber database but it doesn't have rights on the master database. Also I realized that on the 2000 server I still have the old subscription but I cannot delete it - for the same reason - no access on the master database. Before upgrading to 2005 I had the exact same rights on the 2000 server.

Any help would be appreciated.

Thanks.

View 4 Replies View Related

Can SQL Server 2000 Publisher Work Normally With SQL Server 2005 Subscriber ?

Nov 8, 2005

or is there any resource about it?

View 3 Replies View Related

Changing Publisher-subscriber Roles On SQL Server 6.5

Sep 14, 1999

Hi Nerds
There are 2 production servers (SQL Server 6.5). One is publisher and the other one is subscriber. Data is replicated from publisher to subscriber which is a transaction based replication. Each day at 8:00PM data comes into publisher and the updations,replication,backup,reporting are carried out till 11:00AM next day. The subscriber server is used as a reporting server and the publishing server is used as the data warehouse server.
I want to cleanup a table on the publisher. Since it is replicated on the subscriber, can I do delete operation on the subscriber, make the subscriber server a publisher and the publisher server a subscriber, do replication from publisher(new) to subscriber(new) and again change publisher to subscriber and subscriber to publisher without affecting the production line of the databases. I have to do this between 11:00AM to 8:00PM.
Pranav.

View 1 Replies View Related

Oracle 10g R2 To Sql Server 2005 - Publisher Set Up Error

Jun 7, 2007

I am receiving the following error message when trying to create a new Oracle Publisher.



Msg 21684, Level 16, State 1, Procedure sp_ORACheckAdminPrivileges, Line 136

The permissions associated with the administrator login for Oracle publisher 'NT02' are not sufficient.



We have added the following permissions manually (not through a role) in Oracle:

CREATE PUBLIC SYNONYM and DROP PUBLIC SYNONYM
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE ANY TRIGGER.
CREATE TABLE
CREATE VIEW



And we have also tried the Program FilesMicrosoft SQL Server<InstanceName>MSSQLInstalloracleadmin.sql script.



In both cases we are receiving the error message above. The only way we seem to be able to get around the error is to grant the DBA role to the replication schema user, which doesn't seem right.



Has anybody run into this problem before? How did you get around the problem?



Also is there a way to view sp_ORACheckAdminPrivileges because it's doesn't seem to be viewable anywhere in the database? This would at least let us know what it's looking for from an Oracle standpoint.



Help would be appreciated.



Thanks

View 5 Replies View Related

SQL 2012 :: Setup Of Transaction Replication Between One Publisher And Subscriber In Same Server

Jul 30, 2014

I have a setup of transaction replication between one publisher and subscriber in the Same server.Now, I need to add a new subscriber to the existing publisher. So publisher database name is DB_A and Subscriber 1 name is DB_B. So the new subscriber will be DB_C. Is this kind of setup possible on one server?

If yes then at the time of reinitialization is it going to apply the snapshot on DB_B as well as DB_C?Also let say if due to disk error DB_B gets corrupted then will data be still replicated between DB_A and DB_C? (Assuming publisher, subscriber 1 and 2 are sitting on individual disks).

View 1 Replies View Related

SQL Server 2008 :: Merge Replication - Publisher And Subscriber On Same Computer?

Nov 6, 2015

For study effect, can I configure merge replication using just one SQL Server Instance?

View 3 Replies View Related

Does The Transaction Log On A Publisher SQL Server Get Truncated When The Database Is Backed Up, But The Distributor Is Down?

Jul 23, 2005

Hello All,The setting is SQL server 7, on Windows NT.If the distributor can not access the log on the publisher database ( butsubscribers are not deleted yet), will the full backup of the publisherdatabase truncate the transaction log? My guess is, it will not truncate thelog.Can any one confirm please?Thanks,Mokles

View 2 Replies View Related

Publisher Goes Down - Replication

Aug 25, 2004

What happens when Publisher goes down in Transactional
Replication, no corruption (power , hardware failure)??

Thanks,
John

View 1 Replies View Related

Add New Article To The Publisher

Jun 19, 2008

Dear All,
i'm in the transactional replication environment. we need to add one new table to the publisher. it is sql server 2005 environment. please explain me the steps

and in another table, i need to change the data type of a table.

please guide me

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 15 Replies View Related

Publisher For Transactional Rep. With SQL-DMO

Sep 14, 2006

Can Express edition be a publisher for transactional replication with SQL-DMO? Does scripting out and editing it work? Does stored procedure work for this purpose?

Thanks

abdul

View 3 Replies View Related

Publisher Issues

Oct 5, 2006

Right i have two sql 2005 standard edition boxes within a Windows 2003 R2 active directory environment. All updates sp1 etc.

I have an mssql service account setup in AD which all the mssql services on both servers startup with.

I went to setup replication between the two servers for one db.

Firstly i setup distribution no problems no errors.

Then i went to setup the publication, all went well no errors in management studio gui but in the application event logs i got the following:


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date:  05/10/2006
Time:  12:37:43
User:  DNETWORKmssqlservice
Computer: SGC
Description:
Replication-Replication Transaction-Log Reader Subsystem: agent SGC-MerakDB-2 failed. Executed as user: dnetworksqlrep. A required privilege is not held by the client.  The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00   G7......
0008: 04 00 00 00 53 00 47 00   ....S.G.
0010: 43 00 00 00 0d 00 00 00   C.......
0018: 64 00 69 00 73 00 74 00   d.i.s.t.
0020: 72 00 69 00 62 00 75 00   r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00   t.i.o.n.
0030: 00 00        

 

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 14151
Date:  05/10/2006
Time:  12:37:51
User:  DNETWORKmssqlservice
Computer: SGC
Description:
Replication-Replication Snapshot Subsystem: agent SGC-MerakDB-Merak Mail DB-2 failed. Executed as user: dnetworksqlrep. A required privilege is not held by the client.  The step failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 47 37 00 00 12 00 00 00   G7......
0008: 04 00 00 00 53 00 47 00   ....S.G.
0010: 43 00 00 00 0d 00 00 00   C.......
0018: 64 00 69 00 73 00 74 00   d.i.s.t.
0020: 72 00 69 00 62 00 75 00   r.i.b.u.
0028: 74 00 69 00 6f 00 6e 00   t.i.o.n.
0030: 00 00     


I've tried all sorts to get this to work, the sqlrep user is db_owner for the distro db, ive tried the sqlrep user as domain admin to see if it was a system priv issue, no luck :(

Anyone have any ideas?

View 3 Replies View Related

Using A Subscriber As A Publisher

Oct 2, 2007



I am having a problem creating a publisher.

I have a database, MobileApp, on a server called Server03, which is a subscriber to a database Stock on Server01. I create the database as a subscriber on Server01, and it gets replicated to Server03 correctly.

I now want to use MobileApp on Server03 as a publisher to mobile devices. I click to add a new publication, and add all the tables. I get all the way to the end, but when I click on finish, I get an error for each table - 'an article with a different subscriber_upload_options value already exists for object.

Any ideas please?

Thanks

Pete

View 6 Replies View Related

Using Access As Publisher?

May 3, 2007

Hi all,



This may seem like an odd question, but is it possible to setup replication between SQL Server and Microsoft Access having SQL as the subscriber and Access as the publisher?



I know this seems backwards, but we are just throwing some ideas around for a new project and if this is possible, it could potentially save us and our client alot of time and money.



Regards,



Stephen.

View 4 Replies View Related

Publisher SP1 Subscriber SP2 ?

Aug 26, 2007

I have a clustering between Server A and Server B. There is a clustered SQL Server installed.

Server A is a primary node(oltp production server) and Server B is a secondary node.

i've set up transactional replication betw serer A and B. Server A is Publisher and Server B is subscriber. B also has a distribution database. I use serve B for all the reporting purposes.


Currently both servers have sp1.

Now i want to apply sp2 to the server B first since i use it for reporting purposes (just to make sure there are no issues and then after some days i want to apply sp2 on server A which is my prodction oltp server)

So when i apply sp2 on server B , my publisher will have SP1 and subscriber (& distributor) will have sp2. Will this cause any issues with replication?

Any help would be appriciated.

Thanks

View 4 Replies View Related

64 Bit Distributor And 32 Bit Publisher

Apr 3, 2007

Does anyone know if there are any known issues with using a 64 bit distributor and 32 bit publisher together?



This is SQL 2005 and Push Merge replication.



Thanks in advance

Martin

View 1 Replies View Related

Distribution Agent At The Publisher

Apr 27, 2008

hi,

the distribution agent says that the process is running and waiting for response from the server .

i have replication set up for different locations.

only one location bothers me.

it runs for hours and it will not get complete for quite a few days.

once it is done i am missing the data for few days.

can you please tell to me how to make the distribution agent run faster with out much delays.

thank you,

View 1 Replies View Related

How To Filter Data From Publisher

Jun 13, 2008

I have a master database at headquarters which will be the publisher. I have 5 databases at client sites that have the same database schemas as the master, which will be the subscribers. Each table in the database contains a Customer_No column, which is set as a default to 1 at client 1, 2 at client 2, 3 at client 3, etc. The master database contains data for all customers.

How do I get Merge Replication to only replicate the data from the publisher based on the customer_no column in each table?

View 1 Replies View Related

Who Is Distributor, Publisher And Subscriber ?

Mar 28, 2007

hi,

I'm reading the MS online docs about replication. there's something not so clear until so far.

I have one central server and 7 client servers.
Sometimes new data is entered at one client server. This should be replicated (when client comes online) to the Central Server (merge replication).

Also, the other way, once the central server gets new data (that was replicated from a client), it should be again replicated to all 6 other clients (from the central server).

now, who should i configure as the distributor, publisher and subscriber?

View 3 Replies View Related

HELP! Non-Replicated DB Thinks Its A Publisher

Jul 23, 2005

I hosed myself, please help me somebody.We have a development server (SQL7) where the database is a restored copy ofproduction (where we use replication, but not in the developmentenvironment).While we rebuild the server recently (so we could move off of NT onto 2000),everything looked to be working fine.But I recently, messed up and did a massive update filling the transactionlog of the development server. Now I can't update data in development.I tried to do my usual:BACKUP LOG LAMS WITH Truncate_onlyonly to get a message:The log was not truncated because records at the beginning of the log arepending replication. Ensure the Log Reader Agent is running or usesp_repldone to mark transactions as distributed.Did a little research into BOL and tried to call the following two procs:exec sp_repldone@xactid = null ,@xact_seqno = null ,@reset = 1exec sp_repltransBoth of which gave me an error of :The database is not published.Which it isn't as we don't run replication in the development environment.I stopped and restarted the SQL Service (as that has cleared issues in thepast), but didn't reboot the server.How can I make the database not think It's replicated (or that its caughtup?).I was thinking, would I be even be able to do another restore of a morerecent copy of Production?Sincerely ...Depressed in Delaware

View 1 Replies View Related

Publisher Become Subcriber To Other Publication.

Mar 23, 2006

Hi,

I just want to know, is it possible to do this ?

If yes, how to do it ?

Thanks.

View 5 Replies View Related

Distinguish Between The Publisher And The Subscribers

Nov 10, 2006

I have a database on SQL Sever 2005 SP1 against which a Publication has been defined and to which many servers (both Workgroup and Express editions - SP1) Subscribe to.

I would like to be able to distinguish between the Publisher and the Subscribers programmatically via T-SQL.

From reading BoL and various forums it appears that the IsPublished, IsMergePublished and IsSubscribed options of the DatabasePropertyEx function should give me this information.

However within all our tested environments, whilst the IsMergePublished option returns expected values. IsPublished and IsSubscribed both return 0 on all servers (the Publisher and Subscribers).

Is this a know issue and how can I rectify the problem or alternatively does anyone know of another method to distinguishing between the Publishers and Subscribers.

Thanks

View 3 Replies View Related

Replication :: One Publisher 2 Subscribers

Nov 9, 2015

Is it possible to replicate data from one publishers to a multiple subscribers in transaction replication? In other words I have Server A, Server B, Server C with databases A,B,C respectively. I need to replicate 10 articles from A to B but only 1 from A to C. In other words I want to use the same publisher but select one article from that publisher instead of all 10 to Server C/database C.

If it is possible what will be the drawbacks of such implementation? Will performance be a hit?

View 5 Replies View Related

MSrepl_identity_range In Publisher And Distribution DBs

Apr 24, 2007



Can anyone shed any light on why this table exists in both the publication DB AND the distribution DB. The reference material just says:

The MSrepl_identity_range table provides identity range management support. This table is stored in the publication, distribution and subscription databases

However,doesn't shed any light on WHY it is in each database.



For merge replication which one should I be looking at to determine the next seed value?



Assuming I am looking at the appropriate records in the distribution db (where publication_db = my publication db) should the values be identical to the values in the MSrepl_identity_range table in the publication db?



View 4 Replies View Related

Updating DB Schema At The Publisher

Sep 22, 2005

Here's a quick question for you:

View 1 Replies View Related

Cannot Create A New Oracle Publisher

Apr 30, 2007


I got this error when create a Oracle Publisher:

Oracle server cannot be enabled as a Publisher because of the following error:
Additional inlonnation:
Unable to connect to Oracle database server 'abc€™ using the Microsoft OLEDB provider MsDAORA.
For addition ilorrnation, see SQL Server Eiror 21627 in Troubleshooting Oracle Publishers in sQL Server Books 0nline. (Microsoft sQL Server, Error: 21627)

The login works fine in SQL Plus.

My test server:


SQL Server 2005 Developer w/ SP2

Oracle Client installed on SQL Server DB

MSDAORA installed
Please help.

Regards,

d-cpt

View 3 Replies View Related

Replication Between 2 Publisher With Same Database

Mar 22, 2006

Hi,

Before this, I've 2 difference site that run SQL server 2000 as database server. One at north and the other at west.

At north, I've a group of terminal that run SQL server 2000. I've 1 main server that run as publisher and distributor to all the terminal. And also the main database is at the main server. The terminal will replicate together using merge replication. So that the data would be same at all terminal. At west it also have the same scenario.

Last week my boss ask me to replicate both main server ( north and west ). So that he want the data would be same at all place.

So, can anybody help me.....

View 3 Replies View Related

Mssql 6.5 Database As Publisher And Subscriber?

Feb 9, 2000

Hello:

I am running an application on mssql 6.5, sp4.

We are working on using a database as a publisher and a remote database as a subscriber for one replication in Canada.

WE havw just been told that another application on a different server(publisher/ distribution) wants to replication to our database as a subscriber.

We also will need(as a publisher/distribution) to replication to a second subscriber database after we completely test the first replication to Canada.

Therefore my questions are:

1) Can a database on a local database -- our database -- on one server be a publisher and subscriber to ther different databases?

2)has any one been involved with replication on a database used both as a publisher and subscriber to different replications requirements?

What are the pitfalls aside from the scheduling conflicts?

3) In terms of database space requirements, how much disk space extra do we need? What guidelines should we use? For each table as an article, assuming we are doing the full table, do we add 100% more space or what?

4) Any other pitfalls we should be aware of?

Thanks.

David Spaisman

View 1 Replies View Related

Drop Push Subscription Without Publisher

Apr 11, 2002

There is a push subscription to an immediate-updating transactional publication with a queued failover. The publisher was also the distributor.

The publisher melted down and has been removed from service. The subscriber continues to queue up transactions for the now nonexistent publisher.

How do you remove the push subscription directly from the subscribing machine?

Thanks for your help,
Jim Schweitzer
Anobi Technology

View 1 Replies View Related

Replication Rows Getting Deleted At Publisher

Mar 1, 2005

I am using merge replication between two servers.

When i insert data into a perticular table ..the data gets deleted after some time.

Anyone faced this problem?

View 2 Replies View Related







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