Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Transactional Replication without snapshot replication (SQL Server 2005)? Expand / Collapse
Author
Message
Posted Monday, June 29, 2009 8:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 3, 2009 9:49 AM
Points: 2, Visits: 45
Hi Roy Ernest,

Sub :Synchronization failed - Due to OS 3 error

I am using SQL2005. I created a publication on one SQL Server and am trying to do a pull Subscription from another SQL Server. It all sets up fine. I create the snapshot. Then I create the subscription to pull. The Synchronization is failing. This is the message in the
history log.
the process could not read C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\repldata\Test\20070608101042\vehicle_report_log_18.pre' due to OS error 3.
2007-06-08 15:12:15.643 Category:OS
Source:
Number: 3
Message: The system cannot find the path specified.

i have share network path for publication server.

Any help would be appreciated.

Thanks
M.Sureshkumar
Post #744122
Posted Tuesday, June 30, 2009 7:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:04 AM
Points: 2,372, Visits: 6,767
What is the user that is running the Replication Agent? And also what is the user that is running the SQL Server Agent? They both need to have modify permission on the specified folder (Network Share) both from the publisher and the distributor. This is a permission issue.


-Roy
Post #744390
Posted Monday, March 12, 2012 11:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 24, 2014 8:33 AM
Points: 1, Visits: 42
you need to do it in 2008 management studio

--Hari
Post #1265430
Posted Thursday, May 16, 2013 2:14 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 136, Visits: 631
It's the Database!!! (6/29/2009)
Does anybody know how to replicate a DB from 2005 to 2008? It will not let me add 2008 as a subscriber? any ideas?


It is about the Distribution database, which has to be the same version as the subscriber. So you will have to move the distribution db at subscriber.


Don't just give the hungry man a fish, teach him how to catch it as well.

the sqlist

Post #1453774
Posted Thursday, May 16, 2013 2:48 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:28 AM
Points: 301, Visits: 597
Thanks however this was 3 years and 2 companys ago!

MCSA SQL Server 2012
Post #1453785
Posted Thursday, May 16, 2013 3:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 136, Visits: 631
It's the Database!!! (5/16/2013)
Thanks however this was 3 years and 2 companys ago!




I wasn't paying attention to the date of your post but to the more recent ones. I thought was recent. Anyway, I came over the thread after a search.


Don't just give the hungry man a fish, teach him how to catch it as well.

the sqlist

Post #1453802
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse