读取SQL Server文件 [英] Reading SQL Server File

问题描述

如何在不停止sqlserver服务的情况下读取使用该数据库的运行程序的Sql mdf文件？

How to Read Sql mdf file of running program that use this database without stopping sqlserver services?

推荐答案

不要。



说真的 - 不要这样做。如果SQL Server正在处理该文件，请将其保留。您所要做的就是读取更改或无效数据并导致问题。通过SQL访问数据，一切都会好的。

Don''t.

Seriously - don''t do it. If SQL server is handling the file, leave it to it. All you will do is read changing or invalid data and cause problems. Access the data via SQL and all will be fine.

OriginalGriff是对的：不要尝试这样做。 mdf文件结构并不简单，首先不公开。它是一种专有格式 - 你更新了解你真正的逆向工程。但至少，在服务器使用它时，您将无法直接打开数据库文件 - 甚至不能读取。它有一个独家锁。如果使用VSS（卷影复制），则只能访问它。

OriginalGriff is right: don''t try do that. The mdf file structure is not simple, and first of all, not public. It is a proprietary format - and you newer know how much your really reverse engineered. But not at least, you will not be able to open the database file directly while the server is using it - not even for reading. It has an exclusive lock. You could only access it if you use VSS (Volume Shadow Copy).

这篇关于读取SQL Server文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！