Old Vault 2.0.6, DB storage growing out of control

[Assaf]

We are using an older Vault 2.0.6 installation to do some basic version control. Our total stored data is around 3GB and the SQL enterprise manager is indeed reporting a similar database size.
However, the folder where the DB is stored in on the server is filled with .BAK and .TRN files totaling about 240GB.
As far as I can tell these are weekly backups (.BAK) and daily transaction log backups (.TRN).

What I do not understand is what's creating them, there is no maintenance plan established for the database on the server since we are using a remote CA SQL backup solution to backup to tape.
There are no scheduled jobs on the server and nothing I can see in the Vault Admin tool to indicate that a backup plan has been established there.

Any idea if I can safely delete them and how to stop them from being created in the future?



Thanks to anyone who might know!

[lbauer]

There's no automatic backup in Vault, though an admin user can easily do a quick backup from the Vault Admin client.

Check the dates on your backups. Are they recent? Then there must be someone or some scheduled job running these. Backups can be done via a script, so there may be a Windows scheduled task or other type of automated script somewhere that's not specifically configured in SQL Server Enterprise Manager.

If you don't need the old backups, you can probably delete them, unless they're all incremental backups. You can change your SQL Server backup strategy to Simple, and just do complete backups on a regular basis, instead of incremental backups.

[Assaf]

Thanks for the quick response!


There is no maintenance plan setup through SQL server nor a Windows scheduled task creating them.

They have been created (and still are being created) with on apperantly full backup per week (the .BAK) and six incrementals (the .TRN files).
Our backup server performs remote tape backups so I don't believe it's responsible for creating them, but I'll check it out.


I'll back them up and delete them from the server to verify that nothing breaks.

[lbauer]

Hope you figure out what's creating these backups.

[Assaf]

It turns out there was a maintenance plan on the SQL server, I just wasn't looking at it properly. Now I really feel silly
Sorry for asking silly questions, and thanks for reassuring me regarding Vault's own behavior.

[lbauer]

No problem. Our Tech Support motto is:

It seems simple when you know, and a total mystery when you don't know. We run into a lot of mysteries ourselves.