Full database and moving to SQL Server Express

GazzaJ · Post by **GazzaJ** » Tue Apr 17, 2007 10:24 am

I am using Vault 3.1.8.3771. This was installed a long time ago and I assume it uses an MSDE database.

I am receiving the error about a full filegroup and from other posts it looks like I may have hit the MSDE limit of 2Gb. As a temporary message I wished to clean up some data in Vault but I cannot delete anything as the delete transaction fails because of the same reason. I have dumped the transaction log. Is there anything I can do to free up some space?

It looks as though I should update to SQL Server Express. Are there any instructions to do this?

Beth · Post by **Beth** » Tue Apr 17, 2007 12:21 pm

As with all database things, first, do a back up.

We don't have any specific instructions for the move from MSDE to Express. Here is a link to one of Microsoft's articles on how to do that: http://www.microsoft.com/technet/prodte ... press.mspx

What is the size of the sgvault.mdf file?

GazzaJ · Post by **GazzaJ** » Tue Apr 17, 2007 2:00 pm

The mdf file is 1.82 GB (1,959,591,936 bytes)

Is there anything I can do so I can delete some items from the repository as a temporary measure. Currently I get the following error in the log:

Could not allocate space for object 'tbldeletedfsobjects' in database 'sgvault' because the 'PRIMARY' filegroup is full.

Beth · Post by **Beth** » Tue Apr 17, 2007 2:48 pm

If you have some items that are already deleted, you could obliterate them and then shrink the database. I believe the command is: DBCC SHRINKDATABASE('sgvault', 0, TRUNCATEONLY)

Again, make sure you have a recent backup first.

You may just have to upgrade your SQL server if you don't have enough space.

GazzaJ · Post by **GazzaJ** » Tue Apr 24, 2007 11:10 am

Just to let you know I followed the upgrade instructions (noting the selection of the instance to upgrade) and the upgrade was successfully with no issues.

Beth · Post by **Beth** » Tue Apr 24, 2007 3:11 pm

Thanks for the follow up.