Link to home
Start Free TrialLog in
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?
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
What was the original setup?windows OS and SQL server versions?
Avatar of ShawnGray
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