Soft-Replication Problems Seting Up MSTDC On W2K
Oct 23, 2006
Hello,
A bit of a double question. We are setting up a new environment but this time we don't want to use the build-in replication. As we have a very changing environment these replications block us in modifying tables. (Was on W2K/Sql2000).
To avoid this we would write a softreplication, now we are running on W2003AS/Sql2005Ent, but when trying to run a transaction to an older server this error pops up. "The transaction manager has disabled its support for remote/network transactions".
I've found some articles on how to solve this but they all mention a buttin 'security config' on the MSDTC tab page of MyComp in CompServ. But i can't see that Button on a W2k.
Any suggestions ..
Or, 2nd question, is it still so that when a replication has been setup in 2005 that bthe table is unmodifiable ??
View 3 Replies
ADVERTISEMENT
Jun 23, 2005
hi,,,here is the issueon the site there is a multiline text box.people type in muliple lines including soft line breaks(soft return (shift+enter)) and hard line breaks (hard return(enter)). the data gets stored in the SQL server 2000 database. In enterprise manager I can see the returns (the line breaks), but when the same data gets posted back to the page it loose those soft and hard returns,whats going onhelp
View 1 Replies
View Related
Aug 10, 2007
Hello,
I'm working on a SQL Server 2005 database (under Win 2003) which is used for a web application (24/24) and on the other hand for asynchronous works (20h -> 06h).
Sometime the asynchronous works consume all system resources and have for consequence to slow the web application even unavailable.
So I want to install a soft-NUMA configuration in order to limit the CPU access for the asynchronous works.
The test platform is based on two hardware NUMA nodes, each having 2 hyperthreading CPU (4 CPUs per node for Windows). The repartition of the CPU on the two hardware NUMA node is :
- Node 0 : CPU 0, 1, 4 et 5
- Node 1 : CPU 2, 3, 6 et 7
Actually, I'm testing the following configutration on the test platform that is discribed higher :
Configuration soft-NUMA (in the registry)
CPU 7 6 5 4 3 2 1 0
node 0 0 0 1 1 0 0 1 1
node 1 0 0 0 0 1 1 0 0
node 2 1 1 0 0 0 0 0 0
I respected the fact that this is not possible to create soft NUMA nodes with CPU which are on differents hardware NUMA nodes.
In parallel, any CPU affnity is defined because I am on a single database instance.
Then, on SQL Server, I defined an endpoint on the TCP port 2000 by taking care well to give connction right on this endpoint.
At the end, I added in the SQL Server Configuration Manager the TCP port 2000 with a soft-NUMA mapping in order to create grouping. I obtained the following configuration : 1433,2000[5].
With this configuration, normally, when I'm connected to the database by the TCP port 1433, I have all the CPU. In the other hand, when I'm connected by the TCP port 2000, I have just the CPUs of the NUMA nodes 0 and 2 (CPU 0,1,4,5,6 and 7)
However, and this is my problem, when I'm connected by the TCP port 2000 and that I execute a query which I know it consumes all CPU resources, all CPU are used !
In order to verify, I changed the mapping in the TPC port like this : 1433[2],2000[5].
Normaly, with a connection by the TCP port 1433, I have just the CPU of the NUMA node 1. However, all CPU are used by my query.
When I'm looking at the configuration which is in the error log, I don't see anything strange :
Multinode configuration: node 0: CPU mask: 0x0000000c Active CPU mask: 0x0000000c. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.Multinode configuration: node 1: CPU mask: 0x00000033 Active CPU mask: 0x00000033. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.Multinode configuration: node 2: CPU mask: 0x000000c0 Active CPU mask: 0x000000c0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.Server is listening on [ x.x.x.208 <ipv4> 2000].Server is listening on [ x.x.x.245 <ipv4> 2000].Server is listening on [ x.x.x.132 <ipv4> 2000].SQL Network Interfaces initialized listeners on node 2 of a multi-node (NUMA) server configuration with node affinity mask 0x00000005. This is an informational message only. No user action is required.Server is listening on [ x.x.x.208 <ipv4> 1433].Server is listening on [ x.x.x.245 <ipv4> 1433].Server is listening on [ x.x.x.132 <ipv4> 1433].SQL Network Interfaces initialized listeners on node 1 of a multi-node (NUMA) server configuration with node affinity mask 0x00000002. This is an informational message only. No user action is required.
Is someone know why, in spite of the NUMA configuration, all CPU are used ?
Is there a configuration error ?
Is it necessary to define an affinity CPU in parallel of NUMA configuration ? But how to make, because I work on only one database ?
Thanks in advance for your reply.
View 1 Replies
View Related
May 12, 2007
Hello
I have few question abaut report services:
1st
How to set on my reports date fromat dd,mm,yyyy
I use Date parametars and need to display it on my reports
what ever I try it is always mm,dd,yyyy.
2nd
Can I resize parametar box size on deployed report,
I use long stings for Label Field and when I open report in web browiser rables is shown but in small size and i need to use horizontal scrol bar to see all data for parametar.
3th
I use multi value parametar and I set the defalt values from Non-queired option, while I working in visual stoudio is OK when I preview report defolt values is OK, but when i deployed that on server which is on defrend machine default values do not working.
4th
Where I can check wich version of SQL2005 is working I think that
problem with multi default values is in difrent SP between my com and server whos hosts reports .
5th
How I can set some reports to it can bi acces anymausly
I want to set off password and username checking before opening report.
Thanks in advice
Best Regards !
View 1 Replies
View Related
Jul 2, 2007
hi,
I've been reading quite a few articles on setup and deployment project on msdn. Also , i've checked articles on msdn about the sqlservr setup and how it can take command line args.
BUT , after i extract the sqlsetup on the target machine , how do i run my batch file that will send the right command line switches to the setup.
Also , (slightly off-topic =S sry) i dont want to just extract my database on to the target machine. Can i extract the schema of my database and then use sqlcmd to execute the script that would create the database somewhere? I do have to do this during my setup!!
Thanks so much
View 5 Replies
View Related
Apr 2, 2004
every time we develop new dts and move it to production we have to MANUALY
modify data source.
I can submit data source as input parameter to dts and using global variable assign it connection data source.
Could it be done at run time ?
Example
if dts start on dev1 server all
connections points on dev server
if dts starts on prod server all
connection point on prod
Thank you
Alex
View 2 Replies
View Related
Aug 1, 2006
In my sproc this is wrong :
SELECT @DetailItems= Count(idDetail)
FROM Details
WHERE CheckNum=@CheckNumber
How should i do this?
Create PROC voidCks
@CheckNumbervarchar(30)
AS
DECLARE @DetailItemsint,
@DetailTotalMONEY,
@CheckAmountMONEY,
SELECT @DetailItems= Count(idDetail)
FROM Details
WHERE CheckNum=@CheckNumber
View 3 Replies
View Related
Oct 31, 2007
is it possible to assign the results of the qry to the 2 variables?
Declare @a Integer
Declare @b Integer
SELECT A, B from myTable
View 1 Replies
View Related
May 7, 2007
Hi
Im having some problems setting up sql server so that i can connect to it in my vb program over the internet.
Im using windows xp pro and have IIS installed and using sql server 2005 express SP2.
My setup is as follows:
from phonecable to router, from router to wireless access point and the wireless connects to my computer.
I have tried disabling the xp firewall, and in the sql server configurationi have set the port to 11001, which i have also opened in my router.
There should be a connection to the computer, cause i have succesfully set up an FTP server on a different port.
I have also enabled remote connections, both via TCP/IP and named pipes.
I have tried to use telnet on my IP adress with the port 11001, and it says that i cant create a connection..Are there other settings i should set to get this to work? This has been bugging me for a little while...
View 1 Replies
View Related
May 19, 2012
I am using Master Data Service for couple of months now. I can load, update, merge and soft delete data in MDS. Occasionally we even have to hard delete data from MDS. If we keep on soft deleting records in a MDS table eventually there will be huge number of soft deleted records. Is there an easy way to hard delete all the soft deleted records from all MDS tables in a specific Model.
View 18 Replies
View Related
Feb 1, 2007
Hi seniors
there are two tables involve in replication let say table1 and replicated table is also rep.table1.
we are not deleting records physically in table1 so only a bit in table1 has true when u want to delete a record but the strange thing is that replication agaent report that this is hard delete operation on table1 so download and report hard delete operation and delete the record in replicated table which is very crucial.
plz let me know where am i wrong and how i put it into right way.
there is no triggers on published tables and noother trigger is created on published table.
regards
Ahmad Drshen
View 6 Replies
View Related
Jun 15, 2007
I'm getting this, after upgrading from 2000 to 2005.Replication-Replication Distribution Subsystem: agent (null) failed.The subscription to publication '(null)' has expired or does notexist.The only suggestions I've seen are to dump all subscriptions. Sincewe have several dozen publications to several servers, is there adecent way to script it all out, if that's the only suggestion?Thanks in advance.
View 3 Replies
View Related
Sep 13, 2007
Hi,I have transactional replication set up on on of our MS SQL 2000 (SP4)Std Edition database serverBecause of an unfortunate scenario, I had to restore one of thepublication databases. I scripted the replication module and droppedthe publication first. Then did a full restore.When I try to set up the replication thru the script, it created thepublication with the following error messageServer: Msg 2714, Level 16, State 5, Procedure SYNC_FCR ToGPRPTS_GL00100, Line 1There is already an object named 'SYNC_FCR To GPRPTS_GL00100' in thedatabase.It seems the previous replication has set up these system viewsSYNC_FCR To GPRPTS_GL00100. And I have tried dropping the replicationmodule again to see if it drops the views but it didn't.The replication fails with some wired error & complains about thisviews when I try to run the synch..I even tried running the sp_removedbreplication to drop thereplication module, but the views do not seem to disappear.My question is how do I remove these system views or how do I make thereplication work without using these views or create new views.. Whyis this creating those system views in the first place?I would appreciate if anyone can help me fix this issue. Please feelfree to let me know if any additional information or scripts needed.Thanks in advance..Regards,Aravin Rajendra.
View 2 Replies
View Related
Jan 17, 2002
Hi,
In my production box is running on SQL7.0 with Merge replication and i want add one more table and i want add one more column existing replication table. Any body guide me how to add .This is very urgent
Regards
Don
View 1 Replies
View Related
Aug 22, 2007
Hello,
I have this problem on a Production database.
DBCC OPENTRAN shows "REPLICATION" on a server that is not configured for replication. The transaction log is almost as large as the database (40GB) with a Simple recovery model. I would like to find out how the log can be truncated in such a situation.
Thank you.
View 4 Replies
View Related
Mar 6, 2007
Hello,I'm getting the following error message when I try add a row using aStored Procedure."The identity range managed by replication is full and must be updatedby a replication agent".I read up on the subject and have tried the following solutionsaccording to MSDN without any luck.(http://support.Microsoft.com/kb/304706 )sp_adjustpublisheridentityrange (http://msdn2.microsoft.com/en-us/library/aa239401(SQL.80).aspx ) has no effectFor Testing:I've reloaded everything from scratch, created the pulications from byrunning the sql scripts generated,created replication snapshots andstarted the agents.I've checked the current Identity values in the Agent Table:DBCC CHECKIDENT ('Agent', NORESEED)Checking identity information: current identity value '18606', currentcolumn value '18606'.I check the Table to make sure there will be no conflicts with theprimary key:SELECT AgentID FROM Agent ORDER BY AgentID DESC18603 is the largest AgentID in the table.Using the Table Article Properties in the Publications PropertiesDialog, I can see values of:Range Size at Publisher: 100,000Range Size at Subscribers: 100New range @ percentage: 80In my mind this means that the Publisher will assign a new range whenthe Current Indentity value goes over 80,000?The Identity range for this table cannot be exhausted! I'm not surewhat to try next.Please! any insight will be of great help!Regards,Bm
View 1 Replies
View Related
May 26, 2015
What is the main difference between snapshot and transactional and merge replication?
View 5 Replies
View Related
Jul 28, 2006
Hi,
I have a VB.net app that access a SQL Express database. I have transactional repliaction set up on a SQL 2000 database (the publisher) and a pull subscription from the VB.net app. I use RMO in the VB app to connect to the publisher. My problem is I am getting some strange behaviour as follows
- if I run the app and invoke the pull subscription it works fine. If I then close my app and go back in, I can access my data without any problem
- If I run the app and try to access data in my SQL Express database it works fine. I can then close the app, reopen it and run the pull subscription it works fine
however.......
- if I run the app, invoke the pull subscription (which runs fine), and then try to access data in my local SQL Express database without firstly closing and reopening the app, I get a login error
- if I run the app, try to access data in my local SQL Express database (which works fine), and then try to run the pull subscription I get a "the process cannot acces the file as it is being used by another process" error. In this case I need to restart the SQL Express service to be able to run replication again.
I get exactly the same behaviour when I use the Windows Sync tool (with my app open at the same time) instead of my RMO code to replicate the data.
I am using standard ADO.Net 2 code to access my SQL Express data in the app and closing all connections etc
Any advice appreciated !
Thanks
Ronan
View 2 Replies
View Related
Jun 28, 2007
Hi all,
I have recently setup a transactional replication in MS SQL 2000. After setting up the replication the clients TempDB grew by almost 60GB. Now the client is Blaming me for the TempDB GROWTH and saying that its because of the replication being setup i tried to convince them but they are not satisfied yet. Can anybody please tell me does replication cause the tempdb to grow. If yes then how. can u suggest any good link for getting to know the internal working of SQL Server replication????
Thanks in advance
Jacx
View 3 Replies
View Related
Aug 30, 2007
Hi all,
I know that adding a column using ALTER TABLE to add a column automatically allows SQLSERVER 2005 to replicate the schema changes to the subscribers, however, I would like to add a new column to an existing article that is being used for merge replication, however, I don't want this column to be replicated. Re-initialising the subscriptions is not a option. Help would be appreciated.
I am using SQLSERVER 2005 (SP1).
View 3 Replies
View Related
Sep 2, 2015
I have been researching on the proper steps or sequence to follow to completely remove SQL Server 2012 Transactional Replication. I have read articles about using SSMS as well as using replication stored procedures and some procedures use SQLCMD or just regular TSQL executed in SSMS. I have also read articles where people said all you really need is connect to the Publisher instance, find the publication you want to remove and choose "Delete" and everything will be taken care of behind the scene. I have three SQL servers that participate in transactional replication. SQL-P (publisher),
SQL-D (distributor) and SQL-S (subscriber). Do I need to connect to the distributor instance and the subscriber instance when removing transactional replication or is it just really connecting to the publisher and click delete on the publication? I want everything gone including any metadata, systems tables, distributions db and any other replication objects created during the initial configuration.
View 6 Replies
View Related
Apr 17, 2007
Hello everyone,I am involved in a scenario where there is a huge (SQL Server 2005)production database containing tables that are updated multiple timesper second. End-user reports need to be generated against the data inthis database, and so the powers-that-be came to the conclusion that areporting database is necessary in order to offload report processingfrom production; of course, this means that data will have to bereplicated to the reporting database. However, we do not need all ofthe data in the production database, and perhaps a filtering criteriacan be established where only certain rows are replicated over to thereporting database as they're inserted (and possibly updated/deleted).The current though process is that the programmers designing thequeries/reports will know exactly what data they need from productionand be able to modify the replication criteria as needed. For example,programmer A might write a report where the data he needs can beexpressed in a simple replication criteria for table T where column X= "WOOD" and column Y = "MAHOGANY". Programmer B might come along amonth later and write a report whose relies on the same table T wherecolumn X = "METAL" and column Z in (12, 24, 36). Programmer B willhave to modify Programmer A's replication criteria in such a way as toaccomodate both reports, in this case something like "Copy rows fromtable T where (col X = "WOOD" and col Y = "MAHOGANY") or (col X ="METAL" and col Z in (12, 24, 36))". The example I gave is reallytrivial of course but is sufficient to give you an idea of what thecurrent thought-process is.I assume that this is a requirement that many of you may haveencountered in the past and I am wondering what solutions you wereable to come up with. Personally, I believe that the above method isprone to error (in this case the use of triggers to specifyreplication criteria) and I'd much rather use replication services tocopy tables in their entirety. However, this does not seem to be anoption in my case due to the sheer size of certain tables. Is thereanything out there that performs replication based on complexprogrammer defined criteria? Are triggers a viable alternative? Anyalternative out-of-the-box solutions?Any feedback would be appreciated.Regards!Anthony
View 11 Replies
View Related
Oct 9, 2007
I am working on bringing our disaster recovery site to be a live site. Currently we replicate to one of out servers (server B) with merge replication (from server A). Server A also does one way transactional replication form some table to several other servers including servers at the DR site.
This setup is not going to be fast enough for what we need so I am wondering if a table is receiving merge replication will the merge updates also replicate down the transaction path??
Example...
Server B update a row and merges to Server A. With this update them replicate (via transactional) to Server C??
thanks...
View 5 Replies
View Related
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
Jan 30, 2007
I have setup transactional replication everything on one box. later(two or three weeks later), Replication monitor is show red X Under my publishers (publications is disconnected). this is SQL2005.
Everyone known how to fix this problem?
Thanks,
Frank
View 1 Replies
View Related
Apr 24, 2007
Hi,
I have a particularly difficult problem.
I have a SQL Server in an internal network and need to "replicate" to an identical server and database in a DMZ. The DMZ can only receive files sent by a custom component and no port(s) can be opened in the firewall or standard FTP used.
I also need to minimise traffic (i.e. sending whole tables is not an issue as some contain millions of rows), replicate approx once hourly and allow record locking only (as opposed to DB locking/exclsuive access or table locking).
Any thoughts / experiences greatly appreciated otherwise I'm looking at putting triggers on all the tables to monitor changes and generate SQL statements for execution against the DMZ server.
View 4 Replies
View Related
Dec 1, 2006
Hello,
I'm interested in combining the Peer-to-Peer Transactional Replication and Standard Transactional Replication to provide a scale out solution of SQL Server 2005. The condition is as follows:
We may have 10 SQL Server 2005 (1 Publisher + 9 Subscriber) running transactional replication in the production environment and allow updates in subscribers. To offload the loading of the publisher, we plan to have 2 Publisher (PubNode1 and PubNode2) using Peer-to-Peer Transaction Replication and the rest 8 subscribers will be divided into 2 groups. The subscribers 1-4 (SubNode1, SubNode2, SubNode3, and SubNode4) will be set to be standard transactional replication subscribers of PubNode1, and the rest 4 subscribers (SubNode5, ..., SubNode8) will be set to be standard transactional replication subscribers of PubNode2.
Is it possible to setup above 2 Publisher + 8 Subscriber topology?
Also, could we set the 8 subscribers with updatable subscriptions to achieve each node is updatable?
We do not plan to set all the 10 nodes using Peer-to-Peer Transactional Replication as it is necessary to make sure n*(n-1)/2 (i.e. 45) peer-to-peer connections is reliable. It seems that the maintenance cost is high if the servers are not in a LAN and the topology is very high coupling. So we prefer to divide the 10 nodes into 2 groups and reduce the cost of each node to maintain the connections to all other sites.
That's the scenario.
Any feedback is welcome and appreciated.
Thanks,
Terence
View 4 Replies
View Related
Sep 12, 2006
I was working on a project that use local and remote SQL server. In order to keep the database up-to-date I wanted to implement replication on the SQL servers. But unfortunately the transaction replication which meet my requirement best is disabled on the replication configuration module (snapshoot and merge replications are active). Is there any way I can make the transaction replication enabled. I know it was supposed to be enabled by default. I’m using Windows 2003 server and SQL server 2000. Sincerely
View 3 Replies
View Related
Feb 4, 2008
NOT NET REPLICATION: indicates that the IDENTITY property should not be enforced when a replication login such as sqlrepl inserts data into the table.
What is purpose statement above?
View 1 Replies
View Related
Apr 11, 2004
I have a failry complicated problem, or at least I think its complicated.
I'm working with a database that is not very normalized, and I was asked to make a portion of the dataset it available to web users.
Rather than build a complicated mess on top of the existing database, I opted to create an entirey new database inspired by the original, only normalize the data. So, where I had 3 tables in the old system..I now have around 10 nice and neat normalized tables.
Now the trick is to get the data from the original database to the new one. I could write my own application to do this, but I wasn;t sure if SQL's built in replication would be of any help.
I think I'm a little bit confused because thetwo DB schemas are very different from one another, and I'm not sure if built in Replication can work with this sort of set up.
Luckicly, the replication pretty much on needs to go one way, from the original database to the new one. The original databse will still be in use, but for the most part only insert will be happening there, and a few updates. In the new database, there will be no inserts, but there will be updates, and they don't have to be replicated back to the original DB. So, that seems pretty easy to me.
If I were to use replication rather than write my own tool to sync up the data, how woudl I go about this, and is it even possible?
One thing I thought of was was creating a bunch of views in the original database, that looked just like the tables in the new system..and having replicaiton work with those...the only downside I see is the views will have no relationships, and in the new DB all the tables have valid relationships..so I may run into situations where child records are getting replication before parant records..and that will cause issues.
Any advice would be helpful. Thanks guys!
View 1 Replies
View Related
Oct 17, 2005
I've been trying to setup transactional replication with two servers
for 2 weeks now with little success. Can anyone point me to a good
article or something that will help me.
View 1 Replies
View Related
Nov 20, 2001
I am in the process of setting up replication from SQL2k to 6.5.
Both server have mixed authentication and are using the same login
that has domain rights and is a local admin on each box.
However, repliation fails with this error message;
Login failed- User: Reason: Not associated with a trusted SQL Server connection.
I have tried searching this site, BOL and other newgroups sites for
a step by step guide to setting up replication, but am unable to find anything.
Anyone have any suggestions ?
Please advise
Thanks
View 1 Replies
View Related
May 29, 2002
Hi!
I have two SQL Servers as a part of one domain. I'm going to set up transactional replication between them.
What start up account should be for SQL Server Agent on a both machine?
Thank you,
Elena.
View 1 Replies
View Related
