Forum Discussion

anon1m0us1's avatar
anon1m0us1
Level 6
13 years ago
Solved

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