0

My old hard disk have a problem that I can't use it now and my database is currently still on it. How can I copy my database by connecting my old hard to my new laptop ?

Like excel that have a file for each database .

1 Answer 1

2

You need to locate the various database files on your old hard disc. There will be a minimum of one data file (*.mdf) and one log file (*.ldf). Then copy them over and attach them using SSMS (Right click the "Databases" node in object explorer and choose the "Attach" option in the context menu).

3
  • thanks for the answer martin . but where is the DB files ? Where are they stored Please give me an address like c:/programfiles/...
    – Arash
    Aug 10, 2011 at 23:58
  • 1
    Probably `C:\Program Files\Microsoft SQL Server\SomeFolderName\MSSQL\DATA` Aug 10, 2011 at 23:59
  • just do a search for *.mdf and *.ldf. Aug 11, 2011 at 3:30

You must log in to answer this question.