December 4, 2009 at 8:35 am
I have on my test enviroments an installed copy of SQL Server 2005 Enterprise Edition. This replicates fine and have no problems, but once I have started to replicate onto the live server I have hit problems.
I have tried the same process as I followed before using the step by step off the webiste here
http://www.codeproject.com/KB/database/sql2005-replication.aspx
my problem is that my Live server is on SQL Server 2005 Standard edition always tells me when I name my publication that it cant publish the database as it cant create tables due to the distribution.mdf already existing, but there is no way of me changing this or is there?
how can I get around this problem?
December 4, 2009 at 8:57 am
jez.lisle (12/4/2009)
my problem is that my Live server is on SQL Server 2005 Standard edition always tells me when I name my publication that it cant publish the database as it cant create tables due to the distribution.mdf already existing, but there is no way of me changing this or is there?how can I get around this problem?
At what step are you getting this error and post the exact error code and message that is displayed.
Have you configured distribution?
Is distributor and publisher on the same instance?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 4, 2009 at 9:33 am
It sounds like you already have set the distributor up. Skip Step 1a and start from 1b.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply