无需还原即可读取sql server备份文件 [英] Read sql server backup files without restoring

问题描述

大家好，

有没有办法从sql server备份文件中读取/提取数据而不进行恢复？



谢谢。

Hi All,
Is there any way to read/extract data from sql server backup file without restoring it?

Thanks.

推荐答案

我认为你在这里谈论的是SQL Server。备份文件是SQL Server使用的数据库文件。我认为SQL Server目前只能以可用的方式阅读其内容。



我不清楚你执行任务的目的。我怀疑你有数据库备份文件，并希望在不安装SQL Server的情况下使用数据。如何安装Free SQL Server Express Edition？查看 http://www.connectionstrings.com/sql-server-2005 [ ^ ]，它将向您展示如何连接备份文件。

I presume you are talking about SQL Server here. A backup file is a database file used by SQL Server. I think SQL Server is currently only way to read its contents in usable fashion.

I am unclear about your purpose of doing the task. I suspect you have database backup file and want to use the data without installing SQL Server. How about installing Free SQL Server Express Edition? Check out http://www.connectionstrings.com/sql-server-2005[^], it will show you how to connect with a backup file.

您可以使用第三方工具，例如 ApexSQL Restore [ ^ ]或 SQL虚拟还原 [ ^ ]您可以从备份文件制作的虚拟数据库中读取和提取数据，并像虚拟数据库一样工作虚拟数据库。

You can do it by using 3rd party tools such as ApexSQL Restore[^] or SQL Virtual Restore[^] You can read and extract data from virtual database made from backup file and work vith virtual database like it is live database.

您可以将备份还原到其他（新）数据库。我认为没有其他方法可以阅读该文件。

You could restore the backup to a different (new) database. I don't think there are other ways to read the file.

这篇关于无需还原即可读取sql server备份文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！