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 .
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).