English 中文(简体)
交易 edb数据库中的记录文档
原标题:Transaction Log files in edb database

我试图从各种代用品数据库中提取数据(摘要和有选择地阅读栏目),我面临一个根本问题。 我有一个ed子数据库,有两.木文档。 我知道数据库中有哪些信息,但我仅从中提取一半信息。 我担心,其余一半人睡在原木档案中。 我假定欧亚开发银行的发动机知道,在附属数据库时,记录档案存放在哪里,而且自动装满(JET_paramSystemPath, JET_paramlogFilePath和JET_paramBaseName被适当确定)。 这种错误的假设吗? 如果是的话,我应该做些什么才能使这些标志装上?

或者,将交易简单地投入到欧亚开发银行的档案中去,并删除这些记录吗?

最佳回答

如果存在未结算的交易,数据库的标记将是不一致的。 你们可以对照数据库对ESENTUTL /MH进行核对。 CallingjetAttach 数据库若不连贯,总是会失败。

So, if your program is able to attach and open the database then it is consistent. There are two ways a database can be made consistent:

  1. A clean shutdown of ESENT.
  2. Running recovery using the logfiles at JetInit time.

喷口号公司所做的第一件事是寻找由JET指定的标识单。logFilePath and JET_paramBaseName. 记录单载有数据库参考的全部途径,记录单中的交易则承诺输入数据库。 因此,如果你适当确定系统参数,ESENT在附上该数据库时将装载记录。

另一方面,如果你没有适当确定参数,那么你的方案实际上将建立不需要恢复的数据库。 喷气公司赢得了任何记录单,因此它获得了任何结果,由于数据库一致,附属公司将取得成功。

还有一个扭曲之处是,记录单载有数据库的全面途径。 这意味着,如果你复制/搬走数据库,那么恢复工作就不会奏效。 从Windows 2003开始,你可以通过向载有该数据库的名录设立JET_paramAlternateDatabaseRecoveryPath来处理这一问题。

重要:为了安全起见,你应始终保持并开放使用只读旗帜的数据库。 这将避免出现故障记录仪环境所造成的任何问题。 一个共同的问题是,只有阅读的应用程序最终在不同的目录中建立了一套记录仪,从而使得数据库无法得到适当检索。

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签