Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Thursday, April 25, 2019 11:33 PM
I'm connected to a sql server via remote connection from my computer that has sql server express 2014 on it. I'm trying to do transactional replciation between the two. I'm following along with the tutorials that microsoft has for this and right now setting up servers in preparation for replication according to the tutorials.
On lesson 2 of that guide to set up your tutorials I'm trying to find the filepath on this server that's located at this production facility, the filepath is C:/ProgramFiles/Microsoft SQL Server/MSSQL.X/MSSQL/data this is to create a snapshot folder at the publisher to share it. The thing is though I don't see the data folder in MSSQL and i've looked for it and still can't find it. So my question is how important is it to make this repl_data folder for sharing in that specific directory, can I just make it under MSSQL?
Friday, April 26, 2019 3:34 AM | 1 vote
Hi farooqui.masih,
From your description, you installed SQL Server 2014 Express on your computer, and you want create a publication on it, is it right? If I misunderstood, please let me know. From Microsoft official document, at the publisher server (source), you can install any edition of SQL Server, except SQL Server Express or SQL Server Compact. These editions cannot be replication publishers. Please refer to Tutorial: Configure replication between two fully connected servers (transactional) prerequisites.
>>So my question is how important is it to make this repl_data folder for sharing in that specific directory, can I just make it under MSSQL?
Yes, you can. The snapshot folder is a directory that stores snapshot files. The folder path:X:\Program Files\Microsoft SQL Server\instance>\MSSQL\ReplData is just a defaults path, you can change it. After we created a distribution, we can also change the snapshot folder location. Please refer to modify the default snapshot location.
From my environment, the repl_data folder is under MSSOL like below screenshot and it is not created by us.
Hope it helpes you.
Best regards,
Cathy Ji
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
Friday, April 26, 2019 2:48 PM
No I meant to say that I know already that I can't do replication using sql express as my publisher. The second answer is essentially my main concern. That seems to have helped I was unsure if not having the repl_data folder under the DATA folder would cause all sorts of crazy things. Thanks!
Friday, April 26, 2019 3:13 PM | 1 vote
The replication folder doesnt need to go there - its just that folder already has permissions for SQL. If you cant see DATA here then you probably have it installed on a separate drive. Is there a D drive with a similar file path? This should be where all your databases MDF files are stored
Friday, April 26, 2019 3:34 PM
The default directory is defined when you create the distribution database.
You can see the default location by using SSMS, right click on "Replication" and select "Distributer Properties...", then "Publishers" on the left and the … button next to the distribution database.
Sunday, April 28, 2019 4:50 AM
Express supports witness only. See the link below for features supported by the different editions of SQL Server 2014.
https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
Monday, April 29, 2019 2:00 PM
Yup I found it under the D drive. Thanks!
Monday, April 29, 2019 2:02 PM
Cool. So did the replication set-up work as you expected with the Express instance acting as subscriber?
Saturday, May 4, 2019 8:10 PM
Hi,
Did you get manage to get this working for your POC?
Thanks,
Matt