Start Replication With Old Data
Jan 31, 2007
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.
View 4 Replies
ADVERTISEMENT
Jul 18, 2007
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
View 1 Replies
View Related
Jul 20, 2005
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 Related
Jun 8, 2015
What 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
View 3 Replies
View Related
May 7, 2015
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
Apr 9, 2007
Hello All,I have a SQLDataSource "sdsX" which has four records. There is a DataList "dlX" which is binded to this SQLDataSource "sdsX". Now I want that my datalist "dlX" take third record of "sdsX" as its first element. Is there any property which can be used.Thanks
View 2 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
May 24, 2007
Hello all,
I have an ETL process like that:
- Step 1: extract data from database DB2/AS400 to stage database SQL Server (with provider "ADO.NET ODBC")
- Step 2: extract data to stage database SQL Server to SQL Server
(With provider "Native OLE DBSQL Native Client")
During the step 2, if I have a table with a lot of lines (1 million or more), the data-flow takes a lot of time (some minutes) before to start extracting the data. That's quite frustrating and it affects the global time to integrate the data...
I don't know if SSIS scan the table before to integrate it. Moreover I'm almost sure that it was not like that some time ago (and I'm wondering what could have changed...)...
I just specify that the 2 SQL Server databases are on the same server.
Any idea is welcome.
Thanks,
Guillaume
View 1 Replies
View Related
Mar 30, 2007
1) RS Start in Window Severvices
2) RS Start in Configration
1) and 2) Is Same?
I think that It looks like same Operation.
View 1 Replies
View Related
Jul 5, 2007
We are going insane trying to start Report Manager on a SQL Reporting Services 2000 installation. The programmer/admin who originally set this up for us is gone.
We recently upgraded a database/application server to a new server, causing the data source being used by reports in reporting services to no longer be valid. Unfortunately, we do not have access to the original report project to 're-deploy' with the corrected data source.
We desperately need to get the reports that are installed to retrieve their data from the new database location/machine. We understand this can be done by specifying a new data source in Report Manager. (To clarify, we have NOT moved the report servier installation or database, these remain in place - it's just the deployed reports that no longer point to the correct data source.)
For some reason, our Report Manager will no longer run - when we try to launch it, we get a windows login dialog - nothing will work here. We've tried both local and domain admins and constantly get ACCESS IS DENIED 401.3 error messages that we do not have permission/problems with ACL's.
We've gone so far as to allow EVERYONE read/write access to the ReportManager and ReportServer folders and the RS virtual directories, but nothing seems to help.
Can anyone help with this? Ideas on how to change our data source, or how to get back into Report Manager?
Since we are somewhat technical, but not experts, and don't have much more time to waste, we are willing to pay $500 for this project to someone willing to access the server and fix the problem so that the reports point to the correct database and restore access to Report Manager.
Thanks in advance for any help.
View 1 Replies
View Related
Nov 17, 2006
Hi,
I am trying to setup Trans Replication with updating subscriber on sql2000. One column on few tables got data with single quote (').
How do I handle in this case? Did any one come across such case?
Can I Change default QUOTED IDENTIFIER from ' (single quote) to something else (@@@) on SQL2000?
If yes, how to do?
Thanks
mka
View 1 Replies
View Related
Oct 26, 2007
Guys,
I have 14 databases, the last database - 14th one will have lookup tables only. The other 13 databases will have these lookup tables and data tables. At the end of each day I will make updates for lookup tables on 14th database, I want to be able to push the updates to any or some of the 13 databases. Look up tables will have only upto 100 rows, so I am not concerned about the bandwidth. What is the best way to accomplish this.
Any suggestions and inputs would help
Thanks
View 1 Replies
View Related
Oct 24, 2007
Hi all,
In a foreachloop, I am inserting records into a flat file which is working fine. But the thing is that as the file grows, it takes longer for it to locate the EOF(End of File) of the flat file so as to insert the records.
I have around 70-100 lines written to the file at each loop and there are more than 20k records to be looped. wihich means that at the end I should be having 1400k - 20000k line in the text file.
One solution would be to insert the records at the start of the file itself so that it does not has to lookup the EOF each time before writting.
Another would be to generate separate files and then merge it.
Any idea how can this can be done?
Beside this I have to zip the file and then SFTP to a given address.
Any suggestion or help would be welcome.
Rdgs
David
View 5 Replies
View Related
Jan 24, 2007
I have 3 databases which i will reference as Database1, Database2 and Database3.
Database1 and Database2 are running SQL SERVER 2000
Database3 is running SQL SERVER 2005
Database1 and Database2 each have a Member Info table containing login information for seperate websites.
Database3 has a Member Info table also, but the login information is populated from the Member Info tables in Database1 and Database2.
Curently this is achieved by running a job once a day that clears out the Member Info table on Database3, and then running two insert statements that take the data from Database1's Member Info table and Database2's Member Info table and insert it into Database3's Member Info table.
This all works fine, but I don't think it is the best way to do this. Also, doing it this way leaves the chance that the job might hang up and then the Database3's Member Info table will be empty.
I am trying to find if there is a more efficient way to do this. And any ideas are appreciated!!!
In idea i thought about trying is to populate the Database3's Member Info table, and then place triggers on Database1 and Database2's Member Info tables. If a row is created/updated/deleted in Database1 or Database2's Member info table, it could take that information and update the corresponding information in Database3's Member Info table. But I have never really messed with triggers, so this may not be possible.....
Another idea I though of is to run a job once a day, but then have a cursor that goes through each row in Database1 and Database2's Member Info table, and if the information is not found in Database3's Member Info table, it could then either create/update/ delete that info.
Just wanted some opinions/ideas before I tackle this.
Hope this wasn't too confusing...
And Thank you in advance!!!
View 2 Replies
View Related
Jan 29, 2007
Hi all,
Where is the replication log will be stored.My replication is failed due to server down.I have setup as a transaction replication. I just want to know where that log will be availbale.
thanks
krishnakumar
View 2 Replies
View Related
Aug 31, 2007
Hi,
What is the best way to do a two way data transfer between Sql server 2005 and sql server 2000. These data transfer should take place on triggers happening on either of these databases. Please help. Is there any tutorial online which addresses this.
Thank You
View 2 Replies
View Related
Feb 28, 2005
Hi,
I have two sets of data i.e two instances of SQL server in two different cities. Data entry happens at both the places.I need to balance the data in two servers i.e. I need to Synchronize the data.
Currently I am Exchanging the data between two sides and using a Buffer database to update the incremental infromation.(Running a SQL script).
I have GUID columns in my database. I am too new to replication.I wanted to know whether I can implement repliaction and what changes i need to make?(e.g. Replacing GUID columns with Identity columns).
Permanent connectivity between two databases is required or Replication can be performed whenever connected?
Best Regards
Rohit
View 1 Replies
View Related
Mar 9, 2007
What tools are available to update SQL Server application tables from a DB2 database?
The DB2 database is on iSeries (AS/400).
Thanks in advance.
View 3 Replies
View Related
Feb 10, 2007
Hy im PCV
I want to know how to calculate the amount of data(in MB) that is transfered from 1 server trought another
Puplisher--->Subscriber, using a merge replication. I know that the amount of data depends on the number of the rows and the scale of the colums. I only want to know how to calculate that amount of data. I am using Sql server 2000, and a OS windows XP profesional, thank you
PCV
View 2 Replies
View Related
Jul 20, 2005
I'm seearching for information regarding database replicationperformance. We need to compare the performance of replication for SQLServer and Oracle and it is urgent! Anyone who can describe theperformance bottlenecks for each database when performing replication,or can point me to a white paper or webpage.
View 1 Replies
View Related
Feb 7, 2007
We are looking at setting up peer-to-peer transactional replication between two databases. We have a customer requirement to encrypt the SSN in this database. I have configured replication successfully. I have also successfully encrypted the SSN using a symmetric key (with encryption by certificate). What I haven't done yet is set up encryption to work across a replication topology.
What steps would I have to follow in order to be able to encrypt the SSN on one server, replicate it to the subscriber, and then decrypt the SSN on the subscriber? For this scenario, is there a better way to handle encryption other than a symmetric key encrypted by a certificate?
View 6 Replies
View Related
Aug 8, 2007
I am looking for an opinion on the best way to delete all data from a table after it has been replicated.
The simple use case would be:
Data is replicated from production server to archive server.
Data is deleted from production serverThanks in advance...
View 6 Replies
View Related
Dec 6, 2006
hi,
Im using merge replication.I have created one publisher with dynamic filtering and i have creted two subscribers from it(pull subscription).It was working fine.but after sysnchronizing 2-3 times data from some tables went missing
can any one help me....
thanks and regards
Dhanya
View 3 Replies
View Related
Dec 23, 2004
I have 3 SQL databases: A, B and C. A and B are branch databases while C is the central (HQ) database. A & B will be constantly updated while C will updated occasionally and usually will be used for reporting/data browsing. Even though A & B are from different branch, they do have share some data records.
Every day, I will have to sync A & B's new/updated data to C and C to A/B. I know I can use Replication but I can't. You see, A & B are located in our own branch server while C was hosted on a third-party server. The webserver provider for C would not allow me to do any Replication on C.
What other alternatives that I can use to synchronise all 3?
DTS? XML transfer? It looks as if I have no choice but to write my own sync scripts? :((
Anyone has encountered similar situations? Any recommended SQL Tool programs?
Please help. I'm at a loss of what Im going to do.
View 1 Replies
View Related
May 3, 2002
Hello everyone,
I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:
Server: Msg 7139, Level 16, State 1, Line 1
Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536.
The statement has been terminated.
Can anybody tell me how if I can change this max. value and how ?
Thanks a lot
Mike B.
View 2 Replies
View Related
Apr 21, 1999
I need to transfert data between two servers without replication, and using a stored procedure . Any Ideas. Thanks.
View 1 Replies
View Related
Sep 1, 2004
Hi All,
I am new to MSSQL Server 2000. I am sorry if you think that this is silly question.
What is the difference between identity – yes and yes(not for replication)
What are two different situations where I should use identity – yes or identity - yes(not for replication)
Thanks in advance
rainbow11
View 3 Replies
View Related
Jan 4, 2005
We have a database on the live server which powers a website. Then our client has a copy of the database at their office. Their is Merge replication set up between the two running every half a hour.
Now they want to be able to look at the merge replication history.
With my little knowledge, I believe that the place to get this data from is the distribution database on the publishing machine which is the live server. Now for obvious reasons we cannot replicate the
distrubution database to their side so we need to come up with some way of giving them the data. They also want a history of replication.
So the way I was thinking of fixing it was to have a job that copies some of the last days data from the distrubution database onto the main database and add that table to the replication so they got it every day. Also writing a ASP page so they can look at the last days
data straight from the distrubution database.
Here are my questions:
Question 1:
How long does the replication store history for?
Question 2:
Is thier any simpler way of allowing them to see the replication history?
Question 3:
Are their any other things I should be worried about?
Thanks for any feedback, Nixies
View 1 Replies
View Related
Apr 12, 2007
I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.
I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.
Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.
Note: Migration is from SQL Server 2000 to SQL Server 2005.
Thanks in advance.
Ritesh
View 1 Replies
View Related
Jan 8, 2004
Hi,
Ive got a server which replicates an awful lot of constantly changing data - the db itself could be around 2gb in size, however with the replication data in it it has ballooned to 6gb. On top of this, there is all the data in the D:MSSQLREPLDATAunc directories which seem to represent another log of some description.
Can I delete this data? I cant see what it would be used for and it totals some 25Gb! Obviously I cannot have this lying around on my server.
Does anyone know what it is used for?
thanks
Pete Storey
View 5 Replies
View Related
Sep 22, 2015
I have a transactional publication done between two databases on different Virtual machines connected with a network. I noticed that for some reason Every time replication is happening (which is every 2,5 seconds) my data is deleted on the target DB (subscriber) then re inserted.
this should not happen, old data should remain then only the new data should be inserted.
View 3 Replies
View Related
Apr 12, 2007
I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.
I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.
Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.
Note: Migration is from SQL Server 2000 to SQL Server 2005.
Thanks in advance.
Ritesh
View 1 Replies
View Related
Mar 19, 2008
Hi All...
This is my first time solving replication problem for me.Do help me out.
We have two servers A [Publisher] and B [Subscriber]. Today users complained there is data mismatch.I just did a Select Top 10 records from both A & B, and there is differences in the records.I have to fix this problem by today.What are the steps I should take to find the
Validate the mismatch records?
Sync both tables ?
Ensure Mismatch does not happend in future?
There is no error mssg that indicate's failure of replication
View 7 Replies
View Related
