Cant find *.mdf & *.ldf files on sql server 2017

Did my installation of sql server 2017 express on a new pc not complete properly or is the file structure different than in previous versions?  In the pas it was in a folder called "Data" but I cant find that in my 2017 Program Files.

Thanks!
Bob SchneiderCo-OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
For me the location is this

C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL

In this location you will get a folder called DATA.

Please check if you are getting this or not ?
0
Deepak ChauhanSQL Server DBACommented:
Are you able to connect SQL server after installation ? If yes then execute below query and look into the physical_name column to see the data file location. Or you can check it from database property. However default directory structure for SQL 2017 is same as previous versions.

select * from sys.master_files

Open in new window

0
Bob SchneiderCo-OwnerAuthor Commented:
Pawan, That is what I was expecting but it is not there.  Any ideas?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Deepak ChauhanSQL Server DBACommented:
Have you checked using above query.
0
Bob SchneiderCo-OwnerAuthor Commented:
Where do I enter that script?
0
Pawan KumarDatabase ExpertCommented:
Open SSMS

Connect to SQL 2017.

then run below query

SELECT TOP 1 REPLACE(physical_name,'\master.mdf','') PathLocation from sys.master_files

OUTPUT

PathLocation
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\DATA

(1 row(s) affected)
0
Deepak ChauhanSQL Server DBACommented:
connect SQL server and execute the script. If you are able to connect SQl server.
0
Bob SchneiderCo-OwnerAuthor Commented:
There is nothing to connect to.  I think I need to re-install?
0
Pawan KumarDatabase ExpertCommented:
Go to RUN -> Type Services.msc -> see if you get SQL Server(2017)
0
Pawan KumarDatabase ExpertCommented:
If you dont get anything then Reinstall SQL Server 2017.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bob SchneiderCo-OwnerAuthor Commented:
I reinstalled and all is good. Thanks everyone!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.