Database size

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
gsieber

Database size

Post by gsieber » Tue Jun 07, 2005 7:53 pm

In trying to resolve our recurring database connection failure issue, we are also attempting to reduce the size of the sgvault.MDF file.

I deleted a repository in Vault admin that was almost 1.5GB, but the MDF file size remained unchanged.

Is there a way to reduce the size of the file?

Thanks

jclausius
Posts: 3706
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Wed Jun 08, 2005 7:14 am

Just deleting a repository does not automatically the size of the database's physical file. You'll want to look at SQL Server's 'DBCC SHRINKDATABASE' command to reduce the size of the file.
Jeff Clausius
SourceGear

Post Reply