在MSSQL中找不到数据文件夹 [英] Can't find data folder in MSSQL

问题描述

我通过远程连接从我的计算机连接到sql server，该计算机上有sql server express 2014。我正在尝试在两者之间进行交易性重新调整。我正在关注微软为此提供的教程，现在根据教程设置
服务器以准备复制。

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.

在该指南的第2课设置你的教程我试图在这个位于这个生产设施的服务器上找到文件路径，文件路径是C：/ ProgramFiles / Microsoft SQL Server / MSSQL.X / MSSQL / data这是创建一个快照文件夹
发布者分享它。问题是虽然我没有看到MSSQL中的数据文件夹，但我一直在寻找它，但仍然无法找到它。所以我的问题是让这个repl_data文件夹在该特定目录中共享有多重要，我可以将它放在
MSSQL下吗？

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?

推荐答案

您好farooqui.masih，



从您的描述中，您已经安装了SQL Server 2014 Express电脑，你想要在它上面创建出版物，是不是？如果我误解了，请告诉我。 从Microsoft官方文档，在发布服务器（源），您可以安装
任何版本的SQL Server，SQL Server Express或SQL Server Compact除外。这些版本不能是复制发布者。请参阅

教程：在两个完全连接的服务器（事务性）先决条件之间配置复制。

>>所以我的问题是重要的是要使这个repl_data文件夹在该特定目录中共享，我可以在MSSQL下进行吗？

是的，你可以。快照文件夹是存储快照文件的目录。文件夹路径：X：\Program Files \ Microsoft Microsoft SQL Server \< instance> \ MSSQL \ _ReplData只是一个默认路径，您可以更改它。创建分发后，我们还可以更改
快照文件夹位置。请参阅
修改默认快照位置。

从我的环境中，repl_data文件夹位于MSSOL下，如下面的屏幕截图所示，它不是由我们创建的。

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.

希望它能帮到你。



最好的问候，

Cathy Ji

Hope it helpes you.

Best regards,
Cathy Ji

这篇关于在MSSQL中找不到数据文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！