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!