Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

cant find distribution database data and log files

i installed sql server 2008 on a server and i specified 'd' folder for the data files and log files including the root folder. I cant locate the distribution database data and log files.
In SQL server 2005, after a new install and without replication being configured, i can find the distribution db data and log files.
Is something wrong with the install or in SQL 08, is the distribution database created after repliation is configured.
1 Solution
Start Microsoft SQL Server Management Studio, connect to the server, right click on the database and select Properties option from the menu. Properties dialog contains File pathes.

If you've selected D: for data then your data should be in

This folder is visible to the user running SQL Server Service only.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now