SQL Server Replication Forum

Replicating between table with different structures.

Mon, 23 Nov 2009 13:56:38 Z

I have a single table with the same number of columns with all the same column names that I need to replicated. I have a column that is a INT data type that needs to be changed to a BIGINT data type. The column is a identity column that is reaching upper limits and part of the PK. The table has 1.5 billion records and very little downtime.

I want to create a destination table with that has a BIGINT identity column with everything else the same. I plan to use replication to get the data to the new table and then drop replication during my 2 hour maintenance window and start using the new table with the BIGINT datatype.

false merge conflict

Fri, 13 Nov 2009 13:32:58 Z

Good day.
We use SQL Server 2005, push merge replication.

I use Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver


 in article, but

sometimes there are conflicts:



The same row was updated at


 both 'xx.h1'


 and


 'xxx.h2'


. The resolver chose the update


 from


 'xx.h1'


 as


 the winner.




Field with the date, specified for conflict resolver, differs for winner and loser. Why does not work conflict resolver and there are conflicts?

transactional replication

Mon, 30 Nov 2009 06:51:17 Z

Hi,

I had an issue in transactional replication in sqlserver 2005 like this "Can i take a backup of distribution database in transactional replication .If so how can i take and wat is the use of taking backup of it.Can i take it while configuring replication? ".

Thanks in Advance,
Glnp.

Indexed View & Replication - SQL 2005

Tue, 28 Oct 2008 08:22:41 Z

Hi Everyone,

I need your help in configuring Indexed views as article in replication. We have 7 indexed views which need to be replicated to another server and in the subscriber we have a table to get the data's. I've configured through GUI and everything went fine and when the data started initializing from Distributor to Subscriber we have got the below error and the publication failed.

Cannot use DROP VIEW with because is a table. Use DROP TABLE. (Source: MSSQLServer, Error number: 3705)

Once I got this error, I've setup article using the procedure sp_addarticle and set type as "indexed view logbased" and now the distributor is able to move data successfully to subscriber. The default type value is "indexed view schema only" . Why it started failing when the type is set to indexed view schema only. In GUI article properties also I couldn't see an option to change this type. Is there any hotfix is available for this because I didn't faced any problem like this while configuring in SQL 2000.

I've used default aritlce property while configuring through GUI, you can check the image attached.

SQL Server Details
Microsoft SQL Server 2005 - 9.00.3161.00 (X64) Enterprise Edition

Both Publisher and subscriber has the above version. Please let us know if any other details required.

Thanks,
Vidhya Sagar

SQL 2000 Replication - Need to increase VarChar() column width.

Wed, 11 Nov 2009 01:02:27 Z

In SQL 2000 I think I have two choices.

1. After first generating Create Replication scripts, use sp_removedbreplication to remove replication, make the changes then script replication back onto the database. I have done this before and the process never seems to go completely smoothly. I usually end up having manually run the initial snapshots (perhaps I am just too impatient) and generally find that it is a slightly disconncerting experience.

2. I can add and remove columns with replication active using sp_repldropcolumn and sp_repladdcolumn. I am thinking that I should be able to do the following:-

          a. Copy the entire table to a temporary table, it's not a large table
          b. Drop the column
          c. Create the column with the new (bigger) width
          d. Copy the data back from the tempory table
          e. Drop the temporary table

It all sounds quite straight forward.

One question I have is whether I need to allow any time between steps b and c and steps c and d to allow the changes to propagate to the replica databases.

The second question relates to the fact that there is merge replication between the replica database. It sounds a bit wierd I know but there are reason for it and it seems to work quite well. The merge articles are not the same as the transactional replication articles by the way and are not subject to schema changes. Everyting is controlled by a single distributor so assume that sp_repldropcolumn and sp_repladdcolumn will "take care of everything". The two tiered nature of the replication again makes me wonder whether I need to allow for a delay between steps.

MSMerge del/sel missing at the replication clients

Fri, 27 Nov 2009 06:18:32 Z

Hello,

when I insert new SP and Views at the pulication from a merge replication, I get an Error at the Clients.
Could not found any stored procedure like dbo.msmerge_sel_sp_xxxxxx

What is the problem? Now I work since 3 weeks on this.

Please help

Replicate a database using media - no network connection

Thu, 26 Nov 2009 22:23:36 Z

As a beginner, I would like to know how to copy a database onto a USB stick and replicate it on my laptop. I can't connect my laptop to the network, so I can't use CDW.

Thanks

My MSmerge_History tables is not getting cleaned up.

Wed, 15 Oct 2008 19:41:41 Z

I have a distribution retention of 48 hours. The distribution "Agent hisotry clean up job" runs every 10 minutes.

Why does this table have data older than 48 hours old? I am currently seeing data as old as 11 days ago. What is the best way to clean up this table or do I need the data for some reason. I currently have over 3 million record in it and it is still growing.

I am on SQL Server 2005 Ent SP2 cum 3

Merge Replication message

Wed, 25 Nov 2009 16:40:30 Z

I am getting the message the "Connecting to Subscriber" and then i found there is no change in duration even though one day has been passed
Please let me know what this means

SQL 2005 to SQL 2000 transactional replication with queue updating

Thu, 18 Sep 2008 15:57:45 Z

Hi everybody, I'm new in these forums.

I have a problem trying to setup the following replication scenario:

Publisher: SQL Server 2005 (Version 9.00.3073.00)
Subscriber: SQL Server 2000
Transactional replication with queue updating
Not allowing pull subscriptions

The problem happens when the distibutor is sending the snapshot to the subscriber:

Command attempted:
if (@@microsoftversion < 0x09000000) begin exec sp_addqueued_artinfo 1, N'department', N'FENIX\SQL2005', N'TestReplicacion', N'Test_2005_2000', N'department', N'dbo', N'conflict_Test_2005_2000_department', 0x0000000000000000000000000000000000000000000007ffffffffffffffffff end
(Transaction sequence number: 0x0000004600002DE9002F00000000, Command ID: 53)

Error messages:
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (Source: MSSQLServer, Error number: 3902)

This error doesn't happen if I use immediate updating or not updating at all from the subscriptions, but I need to use queue updating.

Thanks.

SQL CE Merge Replication Problem: Same Device, but new user (login credentials) -> old user's da

Wed, 25 Nov 2009 09:24:06 Z

Hi

I have a problem with SQL CE 3.5 Merge Replication against a SQL Server 2008

I am using horizontal filtering based on - UPPER(SUSER_SNAME(SUSER_SID())) - to ensure that the data replicated is related to the user credentials from the device.

The tabels on the device is read-only. (only sending data to device)

Anyway if I on the device (in the same app) does

1) Replication with user A
-> Data related to user A is received ok
2) Change user to user B (new credentials)
3) Replication with user B
-> No data is changes - data for A is still on the device

If i manually delete the database in a step 2.5 then I do get correct data for user B and there is no problems.... (but I cannot do this in the app due to other reasons - it is just for testing)

This puzzels me a lot. Seems like either the SQL server has an error - or this "change of user" is unsupported?

I am aware of the subscriber id is generated of.

PocketPC Name,
a unique ID,

on-device path to the SQL CE/SQLMobile DB

and i can follow the replication in the replication monitor in the SQL Server. And yes - there is not created another id, when changing user...

Can anyone help?

Best regards
Søren

Snapshot replication query

Tue, 17 Nov 2009 08:53:29 Z

Hi All,
          I have created snapshot replication between two country, database size is about 150 mb. I have also choosen option to compress the snapshot on publisher.
          I wanted to know that how this compress snapshot will apply on subscriber, I mean

              ==> Would this compress folder move to subscriber and then subscriber will extract the files for processing? Or
              ==> Would subscriber connect to itselft to publisher and file extract process will perform on publisher.

         Exactly i wanted to know that how compress option helps to speed up network for snapshot replication.

         Thanks in advance.
Raj

**Vote it if it is helpful. **Mark as answer if it solves your problem. Raj_79

Snapshot replication monitoring on subscriber

Tue, 24 Nov 2009 06:48:11 Z

Hi Experts,
                 I have snapshot replication between two country, i wanted monitor this replication on subscriber but i don't have any rights on publisher.
                 Is there any way that i can monitor this replication on subscriber by any script/replication monitor ?

                 Pls help

Raj

**Vote it if it is helpful. **Mark as answer if it solves your problem. Raj_79

Best method to handle SQL Server 2005 Replication to Access 2003 Tablet PCs used in the field.

Mon, 23 Nov 2009 23:22:18 Z

Hi,

I am converting an Access 2003 database that was divided into a front end and back end. The back end has replicated tables that were used by the Access front end to synchronize to a similar Access application used by field persons on tablet PCs.

I successfully un-replicated the backend and moved it to SQL Server 2005, so the Access front end on the desktop works smoothly with the SQL Server backend. The desktop pcs using Access are connecting to the SQL Server using OLE DB linking that is checked and maintained by ADOX code.

The next step as I see it is to find out how best to replicate from the SQL Server 2005 backend to the tablet pcs using Access. These pcs aren't connected the whole time so they need to use replication and can't use linked tables.

What is my best option?

I haven't been able to find any direct advice on this so far.

It seems to me I can try:

1. Replicating the tablet pc's Access tables and somehow getting them to work with the SQL Server 2005 Backend.

2. I can maybe put SQL Server Express 2005 on the tablet PC's and handle replication between the SQL Server Backend and the tablets.

But I'm just guessing and any viable suggestions for best methods would be very much appreciated.

Btw, I am a long time Access developer and coder but relatively new to SQL Server.

Thanks for your help

Alex

Could not find stored procedure sp_MSins_dbot_tableName

Fri, 20 Nov 2009 22:46:26 Z

Hello Room,

I just completed the transaction replication and the initial snapshot was completed 100 percent.

The distribution agent failed with the following error:

----------------------------------------------------------------------------------------------------
Could not find stored procedure 'sp_MSins_dbot_tableName'

Command attempted:

if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0000CA3000003B59000100000000, Command ID: 3)

Error messages:

Could not find stored procedure 'sp_MSins_dbot_tableName'. (Source: MSSQLServer, Error number: 2812)
Get help: http://help/2812

Please help me out...need to know the solutions.

THanks,
TJ

Could not find stored procedure 'sp_MSins_dbot_tableName'. (Source: MSSQLServer, Error number: 2812)
Get help: http://help/2812

None

Could not find stored procedure 'sp_MSins_dbo_Table A

Tue, 24 Nov 2009 16:14:27 Z

Hello room,

I just completed the transactional when changes made in the publisher data.

The Distribution agent failed with the following errors:

Could not find stored procedure 'sp_MSins_dbo_Table_Name'

Command attempted:

if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0000CC7100003911000100000000, Command ID: 3)

Error messages:

Could not find stored procedure 'sp_MSins_dbot_Table_Name'. (Source: MSSQLServer, Error number: 2812)
Get help: http://help/2812

Could not find stored procedure 'sp_MSins_dbot_Table_Name'. (Source: MSSQLServer, Error number: 2812)

The Distribution agent still run into the same errors.

Can someone help and advise?

Thanks,

I found an article that suggested a fix on the following steps:

1. I manually generated the scripts with the following procedure:
      -- EXEC sp_scriptinsproc @articleid;
      -- EXEC sp_scriptdelproc @articleid;
      -- EXEC sp_scriptmappedupdproc @articleid;

2. Then applied those scripts on the subcribers.

None

Merge replication throws Conflict error

Tue, 24 Nov 2009 17:15:47 Z

In merge replication i am geting this error:

The change for the row with article nickname 161096000 (testConfig), rowguidcol {68A76B18-B9E6-DD11-84FC-00001A1909E4} could not be applied at the destination. Further information about the failure reason can be found in the conflict logging tables.

Kindly suggest

Merge Replication is failing by giving error message The schema script could not be propagated to the subscriber. Column already has a DEFAULT bound to it.

Tue, 24 Nov 2009 16:27:51 Z

The schema script 'if object_id(N'[dbo].[testFailure]') is not null exec('ALTER TABLE [dbo].[testFailure] ADD CONSTRAINT riskAssessmentId_default DEFAULT 0 FOR RiskAssessmentId

')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001

Column already has a DEFAULT bound to it. (Source: MSSQLServer, Error number: 1781)
Get help: http://help/1781

Could not create constraint. See previous errors. (Source: MSSQLServer, Error number: 1750)
Get help: http://help/1750

Please suggest

I need to replicate between tables with different structure SQL 2008

Sat, 21 Nov 2009 03:53:02 Z

I have a single table with the same number of columns with all the same column names that I need to replicated. I have a column that is a INT data type that needs to be changed to a BIGINT data type. The column is a identity column that is reaching upper limits and part of the PK. The table has 250 million records and very little downtime. I was thinking of replicating the table to reduce the needed downtime to change the data type.

Help.

Merge replication:How to get missing data to subscriber from Publisher

Mon, 23 Nov 2009 15:50:03 Z

Hi,

I have a SQL 2005 publisher and SQL 2000 subscriber. Merge replication has been running fine. Recently, subscriber did not get all the data from publisher due to query time out. We did not notice on the day, it failed. Next day, replication ran fine. Due to successful run on the next day, snapshot of publisher was overwritten. So, I can't apply changes from publisher to subscriber. Now, how do I send missing data to subscriber from Publisher?

Thanks a lot!

Replicating from sql server 2008 to Oracle. Insert fails when the column names are different in teh subscriber.

Mon, 23 Nov 2009 21:13:28 Z

I am trying to establish replication from sql server 2008 entreprise server to Oracle.
I have the Oracke client installed and i was able to establish the replication.
I had soms eissue with the datetime Vs date column, which i got around it by using the column type smalldate instaed of the regular datetime.
I was able to update and delete without any issues.

I have problem inserting into oracle. By looking at the command in repl_command, i found that the insert statement have columnnames specified. The column name in Oracel is different from sql. The order ofthe column is correct. By the the replication from sql 200 to oracle worked fine because the repl_commands didn't have the column name specified.)

I saw an option that said 'Insert statment without column name" under the Article properties that doesn't get saved when i save the article after cchanging that property.

any idea how to solve this issue without having to change the column name?

Any help is appreciated,
thanks
uday

Cannot add publication

Mon, 30 Oct 2006 15:43:47 Z

Hi!

I have a strange error, when I try to create publication

Msg 3933, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1222
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.

What is it?

P. S. The error arise with all types of replication.

SQL Server 2005 to SQL Server 2008

Thu, 19 Nov 2009 23:03:58 Z

Is it possible to replicate from 2005 to 2008?

Only one table can not add to the Articles

Mon, 23 Nov 2009 09:19:18 Z

I am trying to perform merge replication(For SQL Server 2005 / Windows 2003 server ),Only one table can not add to the Articles(other tables is ok).
when I add it in Articles , the snapshot agent run successfully .

but when start synchronization , it show some error :
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history log

is this table has something wrong???

anyones who can help me slove this problem , thanks!

billy

Custom Replication issue

Sat, 21 Nov 2009 18:17:23 Z

Hello all, I have deployed a Merge replication in a database farm. Everything works correctly until my customer told me that he doesn't need all data be available in the subscriber.
I found that STRANGE, after some extra interviews :

Subscriber databases must be empty and, after an all day activity database wil cover some new records.

At the time replication will run, the subscriber will commit data changes to the publisher with out refreshing it's own version of data.
The subscriber will empty tables.
The publisher must resolve conflict changes.

The question is : Is this possible? If yes How?

If no, I may get fired ... :).

Thanks for your precious help.

Moez T

MTounsi http://codydriver.blogspot.com

Unique constraint violation on parent table in merge replication

Sun, 22 Nov 2009 04:18:44 Z

I have a parent table Agent that has a unique constraint defined on a non-key column (tag) , and the key column is agentNo that is referenced on
child table(property) as foreign key.
Server1 is publisher and server2 is subscriber. Merge replication is configured with compensate_for_error set to true. the following scenario happens:
An agent(agentno 100) with tag (123) is added in server1
An agent(agentno 200) with tag (123) is added in server2
An property (child record) is added referencing agentno 200 in server2.

when synchronization starts, server 2 try to upload the newly added agent record(agentno200) fail due to unique key constraint violation.with the compensate_for_error set to true, publisher always win, so agent200 is deleted from server 2 and agent 100 from server1 is downloaded to server2.
That also cause the child record (property that reference agent200) got deleted.

What I would like to accomplish is that publisher wins, the winner should also propogate to the child table. that is update the child table(property) with
agent 100 from server1.

I am thinking to use business logic module to handle it.Probably overwrite the insertErrorHandler. However, how can I find out which row in publisher that cause the conflict? And what exactly the enumeration actionOnDateError.AcceptCustomErrorBehavior do.
is it possible to do it using the business logic module at all?

Thanks
Syncia

sqlcesa30.dll connection working correctly but cannot PULL/PUSH/REPLICATE

Mon, 12 Oct 2009 10:25:40 Z

Hi,

We have an existing working system - SQL 2000 back end DB, SQL mobile 2005. Handhelds perform merge replication and push/pulls. We upgrade the SQL SP4 to counter a problem which seemed to cause far more problems. Therefore tried to roll back by reinstalled SQL and SP3. However how we are having new problems which i haven't seen before. All pulls/pushes/replication is failing. I can successfully reach and log in using IE at http://1.2.3.4:2020/SQL30/sqlcesa30.dll

Error message for PULL attempt:

"A request to send data to the computer running IIS has failed" - 28037

Error message(s) for PUSH attempt:

"Failure to open SQL Server with given connect string"

"Login failed for user" - 18456

The log file in the virtual directory has the error messages:

Thread=7F0 RSCB=3 Command=SQL HR=80040E40 Login Failed for User 'machine\user' 18456
Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1

The user seems to be set up correctly everywhere? Do i have to reconfigure the virtual directory? One very strange thing is that now and again a PULL command will work but will take a long time (20 seconds). Any ideas would be welcome!

Thanks

Steve

2005 SP3 via Windows Update breaks Merge Replication

Thu, 05 Nov 2009 18:32:16 Z

Has anyone else noticed this problem we are starting to see it on machines now that are attempting to get SP3 for SQL Express 2005 via Windows Update.

The update failes to apply and the replmerg.exe agent can no longer connect to the distributor. Enterprise Manager can still connect to the distributor from the machine.

Attempting to remove SQL Express causes a faital error.

The only fix we have found so far is to remove SQL Express manually (the installer does not work anymore). Then reinstall and reinstate all of the databases (master, msdb, custom databases etc).

Once the reinstall is complete the agent can connect just fine.

It seems SP3 via Windows Update is some how corrupting something when it fails.

I also tried to apply SP3 manually on these machines and that fails too.

Martin

3 Publications from one Database to 1 subscriber_

Wed, 18 Nov 2009 19:12:05 Z

I have 3 Transactional Replication publications configured on Server A, we have configured 3 publications for administrative reasons dividing articles into 3 publications.
We have subscriber B that is the subscriber for Server A. we have combined 3 Tran. Repl. jobs into 1 so that only 1 job updates the Subscriber.
Server A to Server B using 3 publications with 1 job (Log Reader)

Sometimes we are seeing that the from Publication B - T2 transaction is reaching before Transaction T1 from Publication A, even when we send T1 then T2.

How can we address this ?
Please help gurus

replication

Fri, 20 Nov 2009 10:24:44 Z

Hi,

Can anyone tell me what are the functional requirements and nonfunctional requirements for replication

Regards,

Glnp

Queue Reader Failure after LAN Problems

Fri, 20 Nov 2009 12:05:05 Z

Hi All

We are having problems with the Queue Reader Agent not starting after a period WAN/LAN outage at a customer site. We get the site engineers to re-initialise the subscriptions to start the replication and all the agents start apart from the Queue Reader.

When you try to restart the queue reader you get the error "Failed while applying queued message to publisher" is this because the publisher and subscriber databases are now to far out of sync for it to apply any subscriber transactions?

No other error is reported by the agent. I have checked the event logs etc on the servers.

Any help would be appreciated.

Error while merging: "Could not retrieve column info from table tablename" and Could not find stored procedure MSmerger_sel_sp_134145123kjh12k34

Wed, 28 Oct 2009 00:08:39 Z

Hi i am getting following error message while merging. Can any one please help?

We are using sql server 2005
I have this problem in publisher.Gone throught his article http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/b0bbc330-91df-45d5-8dbf-e2df461a8005 but no luck.

The merge process could not retrieve column information for table 'dbo.tablename'. Verify that you have sufficient privileges on the database and retry the operation. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201016)
Get help: http://help/MSSQL_REPL-2147201016

Could not find stored procedure 'dbo.MSmerge_sel_sp_6481B06512B54C91FCC171C542E7'. (Source: MSSQLServer, Error number: 2812)
Get help: http://help/2812

Thanks

Can SQL 2000 recovery model is Simple participant in Backup and Recovery of Snapshot transaction replication

Wed, 18 Nov 2009 23:38:08 Z

Hello room,

Can SQL 2000 with Simple recovery model participant in Backup and Recovery of Snapshot transaction replication?

Thanks,
TJ

None

Replication slow to deliver changes

Mon, 16 Nov 2009 11:05:40 Z

Hello,

We are replicating a small set of tables (22) from our finance system. Looking at the Publisher to Distributor History, we often see messages similar to the following:

The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 500000 log records have been scanned in pass # 3, 466 of which were marked for replication, elapsed time 130874952 (ms).
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 1000000 log records have been scanned in pass # 3, 131 of which were marked for replication, elapsed time 120360593 (ms).
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 500000 log records have been scanned in pass # 3, 131 of which were marked for replication, elapsed time 19112591 (ms).

Is there anyway to reduce the elapsed time? If you convert the ms to minutes, in some cases it is taking over half an hour to scan the transaction log. Also, sometimes the elapsed time can appear as a large minus number. Any ideas what this means?

The data from the finance system is replicated to a data warehouse. During the month end process, the replicated tables in the data warehouse causes the DWH rebuild process to be blocked, for more than 7 hours. I think this is because replication has a number of changes which it needs to apply to the copy, but because it is still stuck reading the transaction logfile, it is taking a long time. Month end on the Finance system finished around 11pm. The data warehouse refresh starts at 12am, but stays blocked for 7 hours. While month end occurs, the transaction logfile would have grown (up until 11pm).

Any ideas what we can do to increase replication performance when large transactions occur on the fiance system?

Thanks,

Andy.

Filter in Merg Replication

Wed, 18 Nov 2009 06:51:32 Z

I am working on merge replication and i deployed succesfully on testing server. Now my client has following compony structure and they want to implement filtering on publication server.

Structure:-
                 Head office and Distribution and publication Server :- BIR. (UK)
                 Branch1 (sub1) :- Noida (India)
                 Branch2 (sub2) :- California (USA)
                 Branch3 (sub3) :- HongKong (China)

Now my client want if any subscriber make any changes in subscription DB then data should update only on publication server and other subscription should not be update.
Example:-
             Sub1:- Add a new vehicle now publisher should be update but Sub2 and Sub3 should not be update.

Please suggest how to implement filter for above scenario?? or is there any way to do it??

2005 Transactional Replication Use data already in subscriber

Wed, 18 Nov 2009 08:59:38 Z

Hello,

I am creating a simple Transactional Replication with Push Subscription. There is only one table that I want to be replicated. But the problem is that the same table exists in subscriber and have some data as well. So I just want to create the sync. and do NOT want the data to be bulk copied on first synchronization.

Is this possible? If yes then how?

Thanks

when we starts replication what are the jobs are started

Fri, 19 Jun 2009 05:03:20 Z

hi,

What are the log replication monitoring services?
and when we starts the replication what are the jobs are started?

help me.

Thanks,
Ramaprasad.

Default value in SQL 2000

Fri, 27 Jun 2008 18:21:08 Z

Hi All,

How to set default value of this 'msrepl_tran_version' column.

this is not Null field how to satisfy this conditions?

My question is after Replication i got new column 'msrepl_tran_version' in this column how to insert default value.

Thanks,

Ramaprasad.

Replication agent failure with error Unable to determine if the owner

Mon, 16 Nov 2009 22:41:04 Z

I have a problem with replication, I have just set it up using windows authentication, and for some reason the replication agent jobs are created with my domain account as the owner of the jobs, this causes replication agent jobs to fail for some reason, what I then do is update the msdb..sysjobs table with the owner of the jobs as "sa". I have observed that this resolves the problem, but before replication can start working again, the SQL agent service has to be restarted, this is particularly tricky when you have 7 subscribers.

The error I get is as follows.

The job failed. Unable to determine if the owner (domain\username) of job xxxx has server access (reason: Could not obtain information about Windows NT group/user 'domain\username', error code 0x5. [SQLSTATE 42000] (Error 15404)).

Is there a workaround to this problem ?

Thanks in advance

Best way to setup transactional replication on 40gb database

Tue, 10 Jun 2008 12:38:47 Z

Greetings,

I have a 40gb database that needs to be replicated offsite. We have replication setup and operational for other databases and have used the snapshots to get the initial setup completed, but am looking for a way to move the snapshot without pushing it over the wire.

I want to: create the snapshow locally; copy it to a portable hard drive; overnight the drive to the subscribing server; copy it on to the subscribing server and then consume it.

Is this possible? I'm sure this is an easy thing to do but I can't find documentation on how to do the disconnected-snapshot deal.

Any words of encouragement?

Thanks.

Dan Ribar