Reversed incremental do not truncate SQL2000 logs

[jaguar00]

Veeam Enterprise 6.1.0.181
SQL 2000
W2003

Application-Aware Image Processing enable
I tried both options (truncate transaction logs after successful VM backup or truncate transaction logs immediately) bad without success. Backups finished ok but logs stayed big. What can I try?

I used Veritas before and it woked. Now is Veritas service stopped.

Thank you.
Radek

[Gostev]

Do you have VSS enabled on SQL 2000?

[jaguar00]

VSS service is Manual on SQL server.

I have read that MSDEWriter is important for SQL2000 backup.

C:\>vssadmin list writers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001 Microsoft Corp.

Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {79404da0-0ce0-4eda-ae4d-7d29e66bdad5}
State: [1] Stable
Last error: No error

Writer name: 'MSDEWriter'
Writer Id: {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
Writer Instance Id: {24b5080c-8e01-4cec-936d-c05699e93e0a}
State: [1] Stable
Last error: No error

Writer name: 'Registry Writer'
Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
Writer Instance Id: {0a08e3fc-5634-4bef-b4f0-f831660196a9}
State: [1] Stable
Last error: No error

Writer name: 'Event Log Writer'
Writer Id: {eee8c692-67ed-4250-8d86-390603070d00}
Writer Instance Id: {66b27365-b1d9-4fd3-af11-fcc2fdd49c09}
State: [1] Stable
Last error: No error

Writer name: 'COM+ REGDB Writer'
Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
Writer Instance Id: {7d0aad7d-1ec4-40ac-8776-839bf67b17a6}
State: [1] Stable
Last error: No error

Writer name: 'WMI Writer'
Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
Writer Instance Id: {854c4e64-87d4-48b0-8d04-3e3fd0762804}
State: [1] Stable
Last error: No error

Writer name: 'IIS Metabase Writer'
Writer Id: {59b1f0cf-90ef-465f-9609-6ca8b2938366}
Writer Instance Id: {f0d3afc4-7297-4b05-9eb9-27d6809c5462}
State: [1] Stable
Last error: No error


C:\>vssadmin list providers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001 Microsoft Corp.

Provider name: 'Microsoft Software Shadow Copy provider 1.0'
Provider type: System
Provider Id: {b5946137-7b9f-4925-af80-51abd60b20d5}
Version: 1.0.0.7

[Gostev]

OK, thanks for checking. I didn't believe we ever supported log truncation on SQL 2000 (only 2005 or later), but best would be to have support review your logs, and have them confirm this with R&D. Please open a support case, and include case ID here in this thread for further reference. Thanks!

[jaguar00]

Veeam support reply:
"That is true, log truncation is not supported for SQL 2000 and has never been. "