Forum Discussion
TimB
Jan 17, 2025Copper Contributor
Restore SQL 2019 Database from files
We lost our most current changes to our SQL 2019 database while trying to upgrade to windows 11. We've installed a new copy of SQL 2019 onto a new Windows 11 install. We have also restored the databa...
TimB
Jan 18, 2025Copper Contributor
I think I can restore the database using SSMS and copying MDF and LDF files from my old C backup.
I found the following MDF and LDF files
For 1/4/2025 there are 4 MDF and 4 LDF files. I don't know if I need to only copy the HOPE_WW2 files ( 1 MDF and 1 LDF) or should I copy all 8 files
Using SSMS I can attach a database by selecting the MDF file.
Depending on the answer to which files I should copy over, I'm not sure which files to attach where.
1 or all 4 MDF in the "Databases to attach" section
1 or all 4 LDF in the "Associated Files" section
I also don't know if I need to do anything in the connection properties section
Thanks for the support