Search code examples
sql-serverdatabasesql-server-2014

Re-connect to SQL Server database after SQL Server 2014 reinstallation

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?

Solution

  • 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