View Sidebar
Running DBCC CHECKDB Tonight

Running DBCC CHECKDB Tonight

November 13, 2006 11:42 pmComments are Disabled

Sigh…  I’m at the office this evening trying this:

DBCC CHECKDB (‘sgvault’, REPAIR_ALLOW_DATA_LOSS)

Fingers crossed.

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.


Comments are closed