How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete, Networking Engineer
Category: Networking
Satisfied Customers: 17274
Experience:  CISCO Certified Networking Engineer
Type Your Networking Question Here...
Pete is online now
A new question is answered every 9 seconds

In SQL server 2014 management studio, how do you find the

Customer Question

In SQL server 2014 management studio, how do you find the physical location of a database? In earlier versions, it was contained in the DB's properties, but I don't see it.
Submitted: 1 year ago.
Category: Networking
Expert:  Pete replied 1 year ago.
Hi there!In SQL Server 2014 Management Studio, In Object Explorer, right-click a server and click Properties.In the left panel, click the Database settings page.In Database default locations, view the current default locations for new data files and new log files.
Customer: replied 1 year ago.
No, that's the default for new DBs. Question was physical location of an existing database
Expert:  Pete replied 1 year ago.
To see the path to an existing database, open Enterprise Manager, right click on the database you are interested in and select Properties. Select the Files section then scroll across to the Path and Filename columns.