How big is your sgvault Database?

Tri · Post by **Tri** » Thu Oct 27, 2005 9:13 am

Do any of you has concerns about the growing size of your sgvault DB? Big size takes more time and space for back ups.

I wish to use Vault server for codes and small documentations that support the codes. As users get used to Vault, some find convenient to use Vault as a LAN storage device. They check in big binary files like DB backups, video or big PDF. In addition, most of the users are not aware that a deleted file still consumes storage space in Vault server.

I would appreciate any advice on the good practice to manage these big binaries.

Thanks very much in advance.

nmcalpin · Post by **nmcalpin** » Wed Dec 14, 2005 10:49 am

Sometimes our developers like to do the same thing (use vault as LAN storage and check in large to huge to gargantuan files).

would be nice to have an official statement/recommendation from SG on this one.

nmcalpin · Post by **nmcalpin** » Wed Apr 12, 2006 10:55 am

SourceGear? any input?

lbauer · Post by **lbauer** » Wed Apr 12, 2006 1:50 pm

It's difficult to have an official answer when much depends on user preferences.

A large database is not necessary a problem. Technically, Vault database size is limited only by SQL Server limits. We have customers with databases of 160 GB and more. However, as Tri said, you need adequate hardware and disk space when your database grows. You should be doing regular database maintenance.

But Vault performance depends more on how many users/transactions/checkouts there are, rather than database size.

Some users use Vault only for source files, and archive large binaries elsewhere; other users like to have everything in one database.

Use Vault in the way that best meets your needs.