Transaction log error
I am receiving an error that:
Log Name: Application
Source: Enterprise Vault
Date: 2/17/2012 9:00:03 AM
Event ID: 41013
Task Category: Monitoring
Level: Warning
Keywords: Classic
User: N/A
Computer: EServer01.mkllp.com
Description:
The SQL database transaction log for Vault Store 'EVExchMVS01' has used 97% of its allocated space.
I backed up the DB and ran a shrinkDB without any success.
The DB is set to: Autogrowth. File Growth: 10%, Max File Size: 2GB, Full Backup Mode.
When I ran DBCC SQLPERF(logspace), it still shows 98%.
Database Name | Log Size (MB) | Log Space Used (%) | Status |
master | 0.7421875 | 45.26316 | 0 |
tempdb | 6.117188 | 60.66411 | 0 |
model | 1.742188 | 95.06727 | 0 |
msdb | 2.742188 | 39.03134 | 0 |
EnterpriseVaultDirectory | 24.99219 | 65.56541 | 0 |
EnterpriseVaultMonitoring | 79.99219 | 24.57393 | 0 |
EVServer01ExchangeGroup_1_1 | 90.17969 | 7.777441 | 0 |
EvServer01ExchMVS01_1 | 502.4297 | 97.45495 | 0 |
EVServer01JournalVS01_2 | 79.99219 | 2.299419 | 0 |
Why is it not shrinking?
I am the DBA (not really a DBA though) and I run EV.
To be honest, I've never never known anyone to do Point In time restores when it comes to SQL and data consistency, especially when you have to work with fingerprint databases and other vault stores, the idea of restoring a single database is a little aimless.
Also depending on how the SQL Storage is set for the databases and such, having it simple logging causes a lot less strain on the disks and can improve throughput and what not