恢复 MSSQL 备份文件

huangapple go评论67阅读模式
英文:

Restore MSSQL backup file

问题

I receive a file like this from my hosting provider when I downloaded the backup. The file had no extension and was inside a zip file. I want to read the data that is inside this backup or better yet, throw all info in the tables if that's possible. I am afraid everything is gone, hopefully someone knows a way. I am using EntityFrameworkCore so the tables I have back using migration but it's the data that I need.

The file.

恢复 MSSQL 备份文件

英文:

I receive a file like this from my hosting provider when I downloaded the backup.The file had no extention and was inside a zip file. I want to read de data what is inside this backup or better yet throw all info in the tables if that's possble. I am afraid everything is gone, hopefully someone knows a way. I am using EntityFrameworkCore so the tables I have back using migration but it's the data that I need.

The file.

恢复 MSSQL 备份文件

答案1

得分: 1

Your file seems to refer to database_db.mdf and database_db_log.ldf. Those info are generally in database_db.bak files type. Try to add .bak extension to your file and then in an SQL SERVER instance, restore your database_db from this file.

英文:

Your file seams to refer to database_db.mdf and database_db_log.ldf. Those info are generaly in database_db.bakfiles type. Try to add .bak extension to your file and the in an SQL SERVER instance, restore your database_db from this file.

huangapple
  • 本文由 发表于 2023年4月17日 16:55:18
  • 转载请务必保留本文链接:https://go.coder-hub.com/76033348.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定