Shrinking the Vault Database

colin.desmond · Post by **colin.desmond** » Sun Jul 30, 2006 10:48 am

My team has been using Vault for about a year now and our SQL Server data files are becoming increasingly large, the .mdf file is ~800MB and the .ldf is ~ 1.6GB.

Is there anyway of reducing these file sizes by either shrinking the databases/files or archiving out older data into another file which can then be put on a DVD?

Thanks

Colin

Post by **jclausius** » Sun Jul 30, 2006 8:32 pm

Take a look at making a FULL backup of the database, and then running

Code: Select all

BACKUP LOG sgvault WITH TRUNCATE_ONLY

within a query tool.

Also, if you do not use transaction log backups, you may want to consider placing the sgvault database into SIMPLE recovery mode.