Apr 22 2023 06:31 AM
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?
Apr 23 2023 11:28 PM
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?
Apr 24 2023 09:30 AM
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.
Apr 24 2023 11:07 PM
Trying to do just this I get error 5123.
@bboudj , please post the complete error message, not only the number.
Apr 27 2023 10:50 AM
Thanks for your support. I got tired of trying to attach the database to the new instance of 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 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.
Apr 27 2023 11:36 PM
May 08 2023 05:14 AM