Path: csiph.com!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Make a backup only if necessary Date: Sat, 01 Jun 2024 11:34:27 +0200 Organization: Erland Sommarskog Lines: 14 Message-ID: References: <20240527125929.d701039c2aec3196dc3d4731@g{oogle}mail.com> <20240528124112.80ab65ec4a358da57093539b@g{oogle}mail.com> <20240529005233.d0405d2f6f826fd0e8ae0624@gmail.moc> <20240531135309.a107b0e4fc99f9659bed7d8c@g{oogle}mail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Date: Sat, 01 Jun 2024 11:34:27 +0200 (CEST) Injection-Info: dont-email.me; posting-host="1a1befb63b52c4cc0da9ab040f75117e"; logging-data="2863927"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/a9dQPkaph1rn86VDaY+4w" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:Eb6hYENcOJQa7XB6SWQSv84Q+Ek= Xref: csiph.com comp.databases.ms-sqlserver:2254 Anton Shepelev (anton.txt@g{oogle}mail.com) writes: > The major problem with this approach is that fn_dblog is an > undocumented function apt to change or disappear any time. > If anybody know how to perform an equivalent test using more > stable and reliable method, I shall be grateful if they > share it. > Since you are settling on a recovery strategy that few other people would consider, I'm afraid that you are quite much on your own. Beside the fact that fn_dblog being undocumented, you are also relying on that there are some rows left around in the log after a write operation. This is something that could change over time.