Forum Discussion
Attach/Detach sql server database
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?
- olafhelperBronze Contributor
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?
- bboudjCopper Contributor
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.
- olafhelperBronze Contributor
Trying to do just this I get error 5123.bboudj , please post the complete error message, not only the number.