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
Pete, Networking Engineer
Category: Networking
Satisfied Customers: 16500
Experience:  CISCO Certified Networking Engineer
30970729
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: 10 months ago.
Category: Networking
Expert:  Pete replied 10 months 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 10 months ago.
No, that's the default for new DBs. Question was physical location of an existing database
Expert:  Pete replied 10 months 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.