Forum Discussion

bboudj's avatar
bboudj
Copper Contributor
Apr 22, 2023

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 ...
olafhelper's avatar
olafhelper
Bronze Contributor
Apr 24, 2023

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's avatar
bboudj
Copper Contributor
Apr 24, 2023

olafhelper 

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's avatar
    olafhelper
    Bronze Contributor
    Apr 25, 2023
    Trying to do just this I get error 5123.

    bboudj , please post the complete error message, not only the number.

    • bboudj's avatar
      bboudj
      Copper Contributor
      Apr 27, 2023

      olafhelper 

      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.

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        Apr 28, 2023
        You still didn't provide any usefull information and also not the error message; it's impossible to assist you.

Resources