Avatar of ShawnGray
ShawnGray
 asked on

SQL Database reconnect

MS SQL server on a C drive, database files on D.
OS had issues, had to rebuild the OS on C.
D files were untouched.
Installed OS 2019, and MS SQL server 2017 on C.
Created an instance with the same original name but pointed the data folder location to another folder.
(I didn't want anything inadvertently overwritten).
Original data files at D:\Microsoft SQL Sever\
New location of data at D:\MS SQL Server\

How can I connect the new instance to the original files?
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
ShawnGray

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
lcohan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Peter Chan

Hi,
How about that you do Database backup and after you've rebuilt the server OS in C drive, and have also re-setup SQL server, you then restore SQL server into new server OS?
arnold

What was the original setup?windows OS and SQL server versions?
ShawnGray

ASKER
Thanks Icohan; we ended up using some .bak files to restore.
But your solution, I believe, could have worked and your comments the most thorough.
Thank you
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck