How to Attached Database MDF and LDF File in SQL Server

 Attached are MDF and LDF files in SQL Server 

If you want to attach the MDF file in SQL Server if you have not file type this one you can not 

Attached is the Database.....

After that open the SQL Server any Version of SQL Server you are using 

First, all of open the SQL Server when opening the SQL login through the user 

if you want to can do log in as a window authenticate and SQL Server authenticates




Right Click on Database Select Attache
Image(1)


image(2)

image(3)




Ø  Open a new Popup-Click on Add (Select MDF and LDF File) See image(1)

Ø  Next Popup showing that’s MDF and LDF File then click on ok

·         After that Showing both files in two Coolum’s. see image(3)

·         First MDF and 2nd LDF after that showing  below Ok option then click there

·         Showing percentage on upper corner 100 % you have to understand database attached Done.




Thanks  for Visit


Post a Comment

0 Comments