A database error has occured (FailDBReader)

smcguinness · Post by **smcguinness** » Thu Jul 20, 2006 3:12 pm

This is similar to an error someone else posted on Apr. 26 but there was no solution posted. Started getting this error after installing the latest windows updates, but even after uninstalling these updates, we still get the error. Looking at the sgvault log file, it states "System.Data.SqlClient.SqlException: Could not allocate space for object 'tblfileinfo' in database 'sgvault' because the 'PRIMARY' filegroup is full"

In the event log, I also see the following error:
"CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database." Another user had come across this issue when upgrading (May 11), and, according to jclausius from SourceGear, this shouldn't be an issue as SQLServerExpress allows up to 4GB. There is plenty space on the drive. Again, for this post there was no real solution posted - the user ended up clearing out space in Vault - which is not the route I want to go!

As is, we can not check files in or out of Vault. Version is 3.1.6.

Thanks in advance for any help!

Post by **jclausius** » Thu Jul 20, 2006 3:26 pm

It could be someone's changed the recovery mode, and your log file is too large.

Try the following query:

Code: Select all

USE sgvault
GO
sp_spaceused 
GO

If the log file is filled, you may need to:
a) Make a full, verified backup.
b) Run "BACKUP LOG sgvault WITH TRUNCATE_ONLY".
c) Put the sgvault DB in Simple Recovery mode.
c) Recheck your space usage..

smcguinness · Post by **smcguinness** » Thu Jul 20, 2006 4:05 pm

Thanks - I'll try this....

also, I got carried away reading the other post you'd replied to and, incorrectly assumed Vault had been installed with SQLServerExpress, but it seems that we actually have MSDE. Having said that, we have had no problem with large files before, so you're idea is definitely one to try.

ian_sg · Post by **ian_sg** » Fri Jul 21, 2006 7:15 am

If you're running MSDE, that error message makes more sense. 2GB is the limit for MSDE. Even if you're able to clean things up a bit and get a little space back, you're likely to hit this limit again very soon.

Now might be a good time to move to SQL Express.