We have a db which reports errors when trying to do a backup:
Starting to dig in, the first thing that was suggested was to run
DBCC CHECKDB. I've been trying to run that all day now, and googling different things, and different options, but just cannot get it to run. Running:
DBCC CHECKDB ('XiaconBackupServer') WITH NO_INFOMSGS, ALL_ERRORMSGS
yields this output, and absolutely nothing else:
Msg 8921, Level 16, State 1, Line 2 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
There are no other errors, or any other output, so check previous errors is completely unhelpful. Tried running the same command on all the other DBs on the server and they work fine, so it's definitely something isolated just to this DB.
The other thing it mentions is disk space for
tempdb, and I saw someone say in a post that they needed to manually increase the tempdb log file for it to work.
ESTIMATE option with
CHECKDB says it needs all of about 4MB. So I've gone overboard, and manually sized my tempdb files (data and log) up to a minimum of 100MB. And they are set to autogrow on a drive which has about 300GB free, so tempdb space should not be the issue either.
Is there anything else we can check, or is this db likely hosed?
We are running SQL Server 2014 Express on Windows Server 2008 R2.
(Yes, I know they are both way old version, ... out of my control.)