Forum Discussion
Restore SQL 2019 Database from files
I found this link on how to use SQL Server Management Studio (SSMS) to attach a database via .mdf and .ldf files. https://learn.microsoft.com/en-us/sql/relational-databases/databases/attach-a-database?view=sql-server-ver16&f1url=%3FappId%3DDev15IDEF1%26l%3DEN-US%26k%3Dk(sql13.swb.attachdatabase.f1)%26rd%3Dtrue In my C drive search the most recent .mdf and .ldf files were created on 1/4/2025. I found 4 .mdf and 4 .ldf files
I don't know if I need to copy all 4 of these .mdf and .ldf files over or just the "Hope_WW2" Any help would be appreciated.
Depending on that answer I am also unsure on which files do I attach where using SSMS. If I am suppose to copy all 8 files over do I attach all 4 MDF files in the top section (Databases to attach)? Do I also attach all 4 LDF files in the lower section (Associated Files)?
Also the database name has changed. Not sure if I need to change anything else - like in the connection section. Appreciate the support!