Sigh… I’m at the office this evening trying this:
DBCC CHECKDB (‘sgvault’, REPAIR_ALLOW_DATA_LOSS)
First the mail server went down on the weekend while out of town. Got it back up yesterday afternoon over remote desktop with only a few problems. Then today discovered that there was a problem with the Vault database (source code control). Looks like the corruption happened prior to last night’s backup so the nightly backup is of a corrupted database. So trying a repair before restoring the previous backup.
Update: Ugh, not a good sign: There are 28948 rows in 129 pages for object ‘tblfolderentrypins’.
Update 2: I/O error (bad page ID) detected during read at offset 0x0000004d526000 in file ‘E:\Databases\sgvault.mdf’. Connection Broken. Grrrrrr.
Update 3: Ran repair a few more times. Now says: CHECKDB found 0 allocation errors and 0 consistency errors in database ‘sgvault’. And I can now select from tblfolderentrypins, which I couldn’t do before. Fingers still crossed.
Update 4: Can now access repository properties with Vault Admin tool. That’s an improvement.