Please excuse my ignorance as I have not had to do this before.

The C: drive on our server failed yesterday (Microsoft Server 2012 R2) taking with it an installed instance of SQL Server 2014.

Luckily, our databases were stored on the D: drive. I have installed new C: drives, reinstalled Windows Server 2012 and I am currently in the process of reinstalling SQL Server 2014.

My question is: what is the best way to regain access to the databases on the D: drive and get back up and running?

CodePudding user response：

You can Move databases Files "DatabaseName.mdf" & "DatabaseName_log.ldf"

to the new path and open sqlserver

then click right click on Databases then select Attach

and choose MDF file after click "OK" the Database will attached in Sqlserver