数据的恢复日志时候出现的问题!!!!!
wpyyl 2004-08-30 02:56:20 我用LOG EXPL0RER 工具做恢复时出现如下的问题:
YOUR LOG CONTAINS ONLY RECYCLED DATA.
THIS DATA EXITS TEMPORARILY UNTIL SQL SERVER OVERWRITES IT WITH NEW INFORMATION.
THIS CONDITION IS DUE TO ONE OF THE FOLLOWING REASONS;
1,YOUR LOG HAS TRUNCATE LOG ON CHECKPOINT OPTION SET TO TRUE.
2.YOUR DATABASE HAS NEVER BEEN BACKED UP.
3.YOUR LOG WAS TRUNCATED BY DUMP TRANSACTION WITH NO_LOG.
请问是什么原因?