如何从损坏的备份文件中恢复SQL Server 2000?

时间:2022-01-22 10:10:44

I am using SQL Server 2000. I have a corrupted backup file. How can I restore the database from that corrupted backup file? Any help or suggestions really appreciated.

我使用的是SQL Server 2000.我的备份文件已损坏。如何从损坏的备份文件中恢复数据库?任何帮助或建议真的很感激。

1 个解决方案

#1


Do you have a specific error? Right now your only hope is the file is actually okay, but you aren't using the right syntax or what have you to restore it. Products like SQL log explorer exist--which allow you to look into proprietary format of the log files, but I've never seen anything comparable for the backup file.

你有特定的错误吗?现在你唯一的希望是文件实际上没问题,但你没有使用正确的语法或者你有什么恢复它。像SQL日志浏览器这样的产品存在 - 它允许您查看日志文件的专有格式,但我从未见过任何可比较的备份文件。

#1


Do you have a specific error? Right now your only hope is the file is actually okay, but you aren't using the right syntax or what have you to restore it. Products like SQL log explorer exist--which allow you to look into proprietary format of the log files, but I've never seen anything comparable for the backup file.

你有特定的错误吗?现在你唯一的希望是文件实际上没问题,但你没有使用正确的语法或者你有什么恢复它。像SQL日志浏览器这样的产品存在 - 它允许您查看日志文件的专有格式,但我从未见过任何可比较的备份文件。