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

Replication-Distribution Database already exists problem Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 7:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 9:13 AM
Points: 98, Visits: 1,110
Hi All,

When i complete the replication wizard it will try to run through, but the following error message appears:

Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\distribution.MDF' because it already exists. Change the file path or the file name, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Changed database context to 'master'. (Microsoft SQL Server, Error: 5170)


I have checked in the system database folder and the Distribution database isnt there. However, the mdf and ldf files reside in the following location:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA.

Question 1. Can i delete these two files?
Question 2. will the replicaiton wizard create a new mdf and ldf?

thanks in advance guys!
Post #1498352
Posted Thursday, September 26, 2013 7:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:50 AM
Points: 49, Visits: 335
with which Login you are looking for the database. Is this a member of sysadmin?

are there any results starting this query:

SELECT name
FROM master..sysdatabases

or

EXEC sp_databases
Post #1498814
Posted Friday, September 27, 2013 7:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 9:13 AM
Points: 98, Visits: 1,110
Hi, thanks for your reply.

the select query shows all my db's tht i have on the server, it does not display the distributor.

The account is a domain account. I've checked with Networks that it has full access rights to the correct path and publisher etc.

I've got replication setup on another server using the same account and its working fine for months. if i deleted these two files on the new server i am trying to set the replication will this pose any issues?

thanks for your help.

Post #1499381
Posted Friday, September 27, 2013 7:53 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:13 AM
Points: 1,532, Visits: 2,577
.. Can you try attaching it and drop it ? Just my thinking... Other experts might guide you..
Post #1499385
Posted Friday, September 27, 2013 7:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 9:13 AM
Points: 98, Visits: 1,110
Hey, yeah i decided to delete them after all they did not contain any subscriptions. It has allowed me to set the replication back up on the new server.

Thanks Guys for your replies!
Post #1499388
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse