Is there a way to start replication (ie some system proc) w/out actually doing in an insert/update/delete on a the pub? For instance, I want to sync up a particular record to the pub given it's primary key and start the replication for the rest of the subscribers to the pub for that key.
Thanks,
Phil
1. I want to create a (transactional) NEW Publication and a NEW Subscription, but the Suscriber contains data inside the tables (articles) at the beginning (data from another year). Is this possible? How?.
2. I have a transactional Publication a Subscription running correctly. For X, the data in the Suscriber is deleted. I want to send ALL the data from de Publication. Must I delete the publication an create again for do this? Is the only way that we found but we think that is possible reinitialize or something like this.
Hi,For some magical reason, my database replication has suddenly stoppedworking. I modified the publication but the Distribution agent willnot run; the snapshot does not get applied to the subscriber, andchanges made at the publisher do not get replicated.My configuration is: Transactional Replication with a 'Pull'Subscription. The Subscriber is Updateable with Immediate UpdatesOnly. All created via the SQL Server Enterprise Manager. Both thePublisher and Subscriber are on the same server. I'm running SQLServer 2000 (8.00.760 SP3), on Windows 2000 Server (5.0 (2195)).I manually run the snapshop agent. It runs fine with the status'Succeeded' and the Last Action is 'A Snapshot of X article(s) wasgenerated'.When I look at the distribution agent, things start to get a bitconfusing in ( <SERVERNAME>/Replication Monitor/ Publishers/<SERVERNAME?>/ Publication/ Subscription), the status staysconstantly at 'Never Started'. All other columns are either blank or0. When I right click over the subscription, both Start Synchronisingand Stop Synchronising are NOT greyed out. If I click on either StartSynchronising or Stop Synchronising (absolutely) nothing happens(except the mouse turns 'busy' for a fraction of a second). There areno error messages.I added -output c:sqlout.txt -outputverboselevel 3 to thedistribution agent command. C:sqlout.txt did not get created.It worked fine up to a couple of days ago. I'm not sure exactly whatcaused the problem, as I made a few changes at the same time. Thechanges included: adding a new transactional publication, adding morearticles to an existing transaction publication, and adding a mergepublication. I've tried to go back to the set up before I made thechanges, even disabling replication and starting again from scratch.Still the problem persists.The owner of the distribution agent has dbo permissions in both thepublishing and subscribing database. Under 'Publisher and DistributorProperties' I've set the 'Replication Agent Connection to Publisher'and 'Agent Connection to the Subscriber' both to Use SQL ServerAuthentication, both with the same account that has dbo permissions inboth publishing and subscribing database.Has anybody come across this problem before? Can anybody make anysuggestions? Thanks in advance for your help.RegardsDamian HelmeIS ManagerINTEC Engineering (UK) Ltd.
View 1 Replies View RelatedWhat is impact, if i stop and start Synchronization, for one subscription.
When i start, will it resync all tables by dropping and recreating at subscription.
On Publisher, Â
from Location Publiction,Â
  right click on subscription,Â
      select View Synchronization Status,  From here, stop and start
Recently we rebuilt one of the cluster node (due to some issues with SP), where distribution agent resource or instance was running after rebuilding that node, we failed over distribution resource to that (newly built) node and after that log reader agent jobs were in suspended status. After checking the job history, we got the below error "Unable to start execution of step 2 (reason: The LogReader subsystem failed to load [see the  file for details]; The job has been suspended).  The step failed."After getting lot of search did not get exact solution which matches to the environment
View 3 Replies View Related
1) RS Start in Window Severvices
2) RS Start in Configration
1) and 2) Is Same?
I think that It looks like same Operation.
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 RelatedHi,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 RelatedHi,
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
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.
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 RelatedWhat is the main difference between snapshot and transactional and merge replication?
View 5 Replies View RelatedHi,
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
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
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).
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.
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 RelatedI 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...
I am experiencing a big problem with my SQL Server- it won't start. Every time I attempt to start it I get an error "Error 1069 (The service did not start due to logon failure) occurred while performing this service operation on the MSSQLService service. " sa will not work either. I have not made any system changes recently. I tried to use regrbld but nothing happened. Is there anything else I can do short of reinstalling SQL7?
View 3 Replies View RelatedIs it possible to start a DTS package from a SQL Stored Procedure? If so, do you have sample code for this invocation?
thx-
BT
...So glad there are still folks out there running 6.5! We've been running 6.5 and 7.0 for the last year or so (one of our apps required 6.5). SQL 6.5 is running on an Alpha box, and SQL 7.0 is running on an Intel box. I want to install 6.5 on yet another Intel box, then install 7.0 on that SAME box so that I can perform the DTS. (Doing DTS across different CPU types failed to transfer application objects.) After that is successful, I will uninstall the 6.5 on the Intel box and no longer use the Alpha box for SQL. Both the Alpha and Intel boxes are on the same Windows NT domain.
Here is the issue. After performing the CD install of 6.5 on the Intel box, I get a message that the install could not be performed successfully because the MSSQL service could not be started. When I attempt to start it manually from Control Panel, I get an NT Error 3 - that the path cannot be found. (And the errorlog says that the server is unnamed.) So the MSSQL folder exists, the MSSQL Server and SQL Exec services are visible in Control Panel (unstarted), the registry contains SQL Server info, but the only way I've been able to start SQL Server at all is by using the Net Start MSSQLserv command.
I have repeated this step a few times - by deleting the MSSQL folder and re-running SETUP. At no point does NT remove the MSSQL services or the registry entries. In the end, NT or MSSQL still cannot find the "path" needed to start up SQL Server.
What do I need to do to "reset the clock" so that NT knows where to find these services?
Hi,
I was trying to restore a master database. This is what I did:
1. rebuild the master database and it was successful
2. restart server in single mode with
sqlservr.exe -c -m
and I got the following window:
************************************************** ********
2006-01-27 10:30:01.49 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X
86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-01-27 10:30:01.52 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-01-27 10:30:01.52 server All rights reserved.
2006-01-27 10:30:01.52 server Server Process ID is 600.
2006-01-27 10:30:01.52 server Logging SQL Server messages in file 'e:Microso
ft SQL ServerMSSQLlogERRORLOG'.
2006-01-27 10:30:01.54 server SQL Server is starting at priority class 'norma
l'(4 CPUs detected).
2006-01-27 10:30:01.71 server SQL Server configured for thread mode processin
g.
2006-01-27 10:30:01.74 server Using dynamic lock allocation. [2500] Lock Bloc
ks, [5000] Lock Owner Blocks.
2006-01-27 10:30:01.99 server Attempting to initialize Distributed Transactio
n Coordinator.
2006-01-27 10:30:04.04 spid3 Warning ******************
2006-01-27 10:30:04.04 spid3 SQL Server started in single user mode. Updates
allowed to system catalogs.
2006-01-27 10:30:04.04 spid3 Starting up database 'master'.
2006-01-27 10:30:04.29 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2006-01-27 10:30:04.29 spid5 Starting up database 'model'.
2006-01-27 10:30:04.29 spid3 Server name is 'SQLTEST1'.
2006-01-27 10:30:04.31 spid7 Starting up database 'msdb'.
2006-01-27 10:30:04.31 spid8 Starting up database 'pubs'.
2006-01-27 10:30:04.31 spid9 Starting up database 'Northwind'.
2006-01-27 10:30:04.31 server SQL server listening on 10.10.4.17: 1433.
2006-01-27 10:30:04.33 server SQL server listening on 127.0.0.1: 1433.
2006-01-27 10:30:04.34 server SQL server listening on TCP, Shared Memory, Nam
ed Pipes.
2006-01-27 10:30:04.36 server SQL Server is ready for client connections
2006-01-27 10:30:04.67 spid5 Clearing tempdb database.
2006-01-27 10:30:05.54 spid5 Starting up database 'tempdb'.
2006-01-27 10:30:05.70 spid3 Recovery complete.
2006-01-27 10:30:05.70 spid3 SQL global counter collection task is created.
************************************************** **
Now an hour passed and the window is still there. The SSQL service manager on the toolbars still has a red icon but not green. My questions are how do I know the process is done? What is the next step after SQL global counter collection task? Where can I find more information?
Thanks a lot.
Mark
I have recently invested in a new server that is running SBS premium, this come with SQL server and as a result of which I feel its time for me to start getting to grips with it.
I have reasonable knowledge of database design and SQL, extensive experience with access and some with Oracle. I have however never dealt with SQL server.
I generally don't have too much trouble picking up new technologies, and was wondering if anyone can point me in the right direction for learning SQL server from scratch? Is it realistic to be able to achieve this without doing a formal course? I intend to start using it to develop data-driven websites and applications.
Any help, advice and/or pointers are greatly appreciated.
Cheers
Dan
Hi,
I am not able to start any SQL Server job. Trying to start a job from Enterprise Manger, I get no error but the job doesnt execute.
Looks like in the Application Log there was an error 'Unable to read local eventlog'. Is this related to the problem or what should I do to fix this.
Thanks for the help.
Hi,
Getdate() will get me the date, but how I can calculate two other datetime values corresponding to the very first second and the very last second of the current day?
Eg.
Today is 2008-04-09 <whatever time>
Startdate should be 2008-04-09 00:00:01
Enddate should be 2008-04-09 23:59:59
Cheers,
Matt
Here's what I want to do:
I have a lot of instructions on how to do certain things for our department. I want to put these into a searchable database.
Right now, the way it's setup, there's a list of catagories, and under each catagory, a list of articles. Easy enough.
But, now I want to have an option to search for keywords that bring up different articles.
I realize that I will probably have to recode certain things which is fine.
How do I get started?? I have IIS 6.0 on Server 2003 with SQL Server 2005 Express installed.
I have no experience with databases, SQL, Access, etc.
Ram writes "Hi mate,
I am New in this forum.
I am working as developer in C++ and .net ( 4 Years).
I plan to do the SQL SERVER 2005 and do some Microsoft certification.
I really don't know where I can start and which source is suitable for me.
I already download the express edition and I play arround that.
could you all please help me for this.
I am awaiting your good response.
Cheer
Ram"
hi how to get the start day end day one row for each employee
like this
ID fname start day end day val_holiday
-------------------------------------------------------------------------------------
111 aaaa 15/03/2008 21/03/2008 1
222 bbb 02/05/2008 09/05/2008 3
333 ccc 03/04/2008 04/04/2008 3
-------------------------------------------------------------------------------------------------------- this is my table
ID fname new_date val_holiday
----------------------------------------------------
111 aaaa 15/03/2008 1
111 aaaa 16/03/2008 1
111 aaaa 18/03/2008 1
111 aaaa 19/03/2008 1
111 aaaa 20/03/2008 1
111 aaaa 21/03/2008 1
222 bbb 02/05/2008 3
222 bbb 03/05/2008 3
222 bbb 04/05/2008 3
222 bbb 05/05/2008 3
222 bbb 06/05/2008 3
222 bbb 07/05/2008 3
222 bbb 08/05/2008 3
222 bbb 09/05/2008 3
333 ccc 03/04/2008 4
333 ccc 04/04/2008 4
TNX
Hello
I have created a jon in the SQL Server Agent. This job will start 2 Integration Packages
One package for the etl, and one package for processing the cube
70 % of the time the job wil end success. But 30 % of the time the job wil fail.
I don't see anything in the log. This is the only message I see :
Executed as user: RLS01BIP01SYSTEM. The package execution failed. The step failed
anyone an idea??
Thx
Where would be a good place to start learning SQL? I know all the links in the e-mail that I got sent when I registered....but there not very help full.
View 1 Replies View RelatedHello,
I'm new in the field of Microsoft products and particularly with the Microsoft SQL Server.
So in the beginning I would like to ask some questions and to understand the base lines.
First thing is, I heard that there are several editions of Microsoft SQL Server 2005 : standard, workgroup, express, developer.
I would like to know what is the difference between each of them. I suppose that developer means that it should be good for a developers to use this edition, but compared to the Standard edition or to the Express edition what are the main differences.
In my case I'll use the server for a little, not complicated, database and may be there will be a migration to do from some old Access database to the new one (under SQL Server). Is the edition of the SQL Server important for doing that ?
And my last question is about the compatibility between the SQL Server 2000 and 2005. In fact the server that is in use currently is version 2000 but in the future months the administrator plans to upgrade the software to the 2005 version.
So I'm asking myself, if I start to develop for directly for 2005 version, is the product will be entirely compatible with the current version (2000)?
That's all I think for now.
Best regards,
Tonio
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 RelatedWhat is the parameters for starting & stoping sqlserver 2005 from start/run or from the command prompti tried 'sqlservr' & it didn't work
View 1 Replies View Related