Attach/Detach sql server database

Question

I had sql server 2014 installed in my pc on hard drive c:. But then I wanted to improve the pc performance by installing an ssd drive instead of the physical hard drive without taking the precaution to detach or backup my sql server database. I am now using the original hard drive as an external one.

After reinstalling sql server and sql server management studio I can't attach the sql server database from the hard drive to the (new) sql server instance in my pc.

Is there a way to proceed in order to attach the database from the external hard disk to the sql server?

olafhelper · Answer

After reinstalling sql server and sql server management studio I can't attach the sql server database from the hard drive to the (new) sql server instance in my pc.

bboudj , what in detail means "you can't"? Do you get an error message and if, which one?

bboudj · Answer

olafhelper&nbsp;Hi; Using ssms and right clicking on database tab on the left panel, opens a contextual windows with the option of attaching a database. Trying to do just this I get error 5123.

olafhelper · Answer

Trying to do just this I get error 5123.bboudj&nbsp;, please post the complete error message, not only the number.

bboudj · Answer

olafhelper&nbsp;Thanks for your support. I got tired of trying to attach the database to&nbsp; the new instance of&nbsp;sql on the ssd drive. But each attempt failed. So I reinstalled my old system hard disk on my pc and had sql server detach&nbsp; the database after which I removed the hard disk and reinstalled the ssd drive. I still have to attach the database to sql server. I will try this later. Again thank you for enquiring.

olafhelper · Answer

You still didn't provide any usefull information and also not the error message; it's impossible to assist you.

Forum Discussion

Attach/Detach sql server database

Share

Resources