Forum Discussion

RodneyC's avatar
RodneyC
Level 4
13 years ago

MSDE_INSTANCE DBCC error & SBSMONITORING Error

I have two errors currently running a backup-to-disc job which I’m trying to avoid a reinstall of backup exec/sql. There are two jobs that run on this server, one to tape which works fine, another to a nasbox, this is the nasbox job that fails.

 

Error 1 - Backup- SERVER\MSDE_INSTANCE An unknown or unexpected database error occurred while attempting a DBCC.

Database 'SBSMonitoring' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

 

Error 2 - Backup- SERVER\SBSMONITORING V-79-57344-33938 -

An error occurred on a query to database SBSMonitoring.

V-79-57344-33938 - Database 'SBSMonitoring' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

 

I’ve tried restarting services, BEutily to repair databases, re-created folders, re-created jobs but same error every time.

 

FYI The drive had ran out of space, we've since cloned and increased the partition so there is plenty of space now.

 

I’ve just logged into SQL Exress and ran a DBCC CheckDB, below are the results.

 

USEMSDE_INSTANCE

DBCC CheckDB

 

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'USEMSDE_INSTANCE'.

DBCC results for 'master'.

DBCC results for 'sysobjects'.

There are 1266 rows in 22 pages for object 'sysobjects'.

DBCC results for 'sysindexes'.

There are 102 rows in 4 pages for object 'sysindexes'.

DBCC results for 'syscolumns'.

There are 4861 rows in 70 pages for object 'syscolumns'.

DBCC results for 'systypes'.

There are 26 rows in 1 pages for object 'systypes'.

DBCC results for 'syscomments'.

There are 2011 rows in 818 pages for object 'syscomments'.

DBCC results for 'sysfiles1'.

There are 2 rows in 1 pages for object 'sysfiles1'.

DBCC results for 'syspermissions'.

There are 784 rows in 4 pages for object 'syspermissions'.

DBCC results for 'sysusers'.

There are 14 rows in 1 pages for object 'sysusers'.

DBCC results for 'sysproperties'.

There are 0 rows in 0 pages for object 'sysproperties'.

DBCC results for 'sysdepends'.

There are 5470 rows in 28 pages for object 'sysdepends'.

DBCC results for 'sysreferences'.

There are 0 rows in 0 pages for object 'sysreferences'.

DBCC results for 'sysfulltextcatalogs'.

There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.

DBCC results for 'sysfulltextnotify'.

There are 0 rows in 0 pages for object 'sysfulltextnotify'.

DBCC results for 'sysdatabases'.

There are 7 rows in 1 pages for object 'sysdatabases'.

DBCC results for 'sysxlogins'.

There are 3 rows in 1 pages for object 'sysxlogins'.

DBCC results for 'sysdevices'.

There are 7 rows in 1 pages for object 'sysdevices'.

DBCC results for 'sysmessages'.

There are 3841 rows in 166 pages for object 'sysmessages'.

DBCC results for 'sysconfigures'.

There are 38 rows in 1 pages for object 'sysconfigures'.

DBCC results for 'sysservers'.

There are 1 rows in 1 pages for object 'sysservers'.

DBCC results for 'syslanguages'.

There are 33 rows in 3 pages for object 'syslanguages'.

DBCC results for 'syscharsets'.

There are 114 rows in 33 pages for object 'syscharsets'.

DBCC results for 'sysaltfiles'.

There are 14 rows in 3 pages for object 'sysaltfiles'.

DBCC results for 'sysfilegroups'.

There are 1 rows in 1 pages for object 'sysfilegroups'.

DBCC results for 'spt_monitor'.

There are 1 rows in 1 pages for object 'spt_monitor'.

DBCC results for 'spt_values'.

There are 730 rows in 5 pages for object 'spt_values'.

DBCC results for 'spt_fallback_db'.

There are 0 rows in 0 pages for object 'spt_fallback_db'.

DBCC results for 'spt_fallback_dev'.

There are 0 rows in 0 pages for object 'spt_fallback_dev'.

DBCC results for 'spt_fallback_usg'.

There are 0 rows in 0 pages for object 'spt_fallback_usg'.

DBCC results for 'spt_provider_types'.

There are 25 rows in 1 pages for object 'spt_provider_types'.

DBCC results for 'MSreplication_options'.

There are 2 rows in 1 pages for object 'MSreplication_options'.

DBCC results for 'spt_datatype_info_ext'.

There are 10 rows in 1 pages for object 'spt_datatype_info_ext'.

DBCC results for 'spt_datatype_info'.

There are 36 rows in 1 pages for object 'spt_datatype_info'.

DBCC results for 'spt_server_info'.

There are 29 rows in 1 pages for object 'spt_server_info'.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

USESBSMONITORING

DBCC CheckDB

 

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'USESBSMONITORING'.

DBCC results for 'master'.

DBCC results for 'sysobjects'.

There are 1278 rows in 24 pages for object 'sysobjects'.

DBCC results for 'sysindexes'.

There are 100 rows in 4 pages for object 'sysindexes'.

DBCC results for 'syscolumns'.

There are 4976 rows in 89 pages for object 'syscolumns'.

DBCC results for 'systypes'.

There are 26 rows in 1 pages for object 'systypes'.

DBCC results for 'syscomments'.

There are 2234 rows in 1101 pages for object 'syscomments'.

DBCC results for 'sysfiles1'.

There are 2 rows in 1 pages for object 'sysfiles1'.

DBCC results for 'syspermissions'.

There are 787 rows in 4 pages for object 'syspermissions'.

DBCC results for 'sysusers'.

There are 14 rows in 1 pages for object 'sysusers'.

DBCC results for 'sysproperties'.

There are 0 rows in 0 pages for object 'sysproperties'.

DBCC results for 'sysdepends'.

There are 5461 rows in 28 pages for object 'sysdepends'.

DBCC results for 'sysreferences'.

There are 0 rows in 0 pages for object 'sysreferences'.

DBCC results for 'sysfulltextcatalogs'.

There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.

DBCC results for 'sysfulltextnotify'.

There are 0 rows in 0 pages for object 'sysfulltextnotify'.

DBCC results for 'sysdatabases'.

There are 5 rows in 1 pages for object 'sysdatabases'.

DBCC results for 'sysxlogins'.

There are 3 rows in 1 pages for object 'sysxlogins'.

DBCC results for 'sysdevices'.

There are 6 rows in 1 pages for object 'sysdevices'.

DBCC results for 'sysmessages'.

There are 3853 rows in 166 pages for object 'sysmessages'.

DBCC results for 'sysconfigures'.

There are 38 rows in 1 pages for object 'sysconfigures'.

DBCC results for 'sysservers'.

There are 1 rows in 1 pages for object 'sysservers'.

DBCC results for 'syslanguages'.

There are 33 rows in 3 pages for object 'syslanguages'.

DBCC results for 'syscharsets'.

There are 114 rows in 33 pages for object 'syscharsets'.

DBCC results for 'sysaltfiles'.

There are 10 rows in 2 pages for object 'sysaltfiles'.

DBCC results for 'sysfilegroups'.

There are 1 rows in 1 pages for object 'sysfilegroups'.

DBCC results for 'spt_monitor'.

There are 1 rows in 1 pages for object 'spt_monitor'.

DBCC results for 'spt_values'.

There are 731 rows in 5 pages for object 'spt_values'.

DBCC results for 'spt_fallback_db'.

There are 0 rows in 0 pages for object 'spt_fallback_db'.

DBCC results for 'spt_fallback_dev'.

There are 0 rows in 0 pages for object 'spt_fallback_dev'.

DBCC results for 'spt_fallback_usg'.

There are 0 rows in 0 pages for object 'spt_fallback_usg'.

DBCC results for 'spt_provider_types'.

There are 25 rows in 1 pages for object 'spt_provider_types'.

DBCC results for 'MSreplication_options'.

There are 2 rows in 1 pages for object 'MSreplication_options'.

DBCC results for 'spt_datatype_info_ext'.

There are 10 rows in 1 pages for object 'spt_datatype_info_ext'.

DBCC results for 'spt_datatype_info'.

There are 36 rows in 1 pages for object 'spt_datatype_info'.

DBCC results for 'spt_server_info'.

There are 29 rows in 1 pages for object 'spt_server_info'.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

 

11.x and Earlier
Backup and Recovery
Backup Exec
Troubleshooting
  • RodneyC's avatar
    RodneyC
    13 years ago

    After trying lots of different things...datasebase fixes, restarts, test backups, copying backups, changing selections etc, I've now narrowed the fault down to a different problem...exchange.

    So backup are now working but not with exchange,

    Backup- \\SERVER\Microsoft Information Store\First Storage Group WARNING: "\\SERVER\Microsoft Information Store\First Storage Group\Mailbox Store (SERVER)" is a corrupt file.
    This file cannot verify.
    Verify- \\SERVER\Microsoft Information Store\First Storage Group WARNING: "Mailbox Store (SERVER)" is a corrupt file.
    This file cannot verify.

     

    So the SQL problem has now gone, I just can't complete a backup with exchange in the selection. Looks like I need to do an offline defrag of exchange to try and fix it then I expect Backup Exec to be working again.

  • RodneyC's avatar
    RodneyC
    Level 4
    13 years ago

    Thanks for that but I ran the "Database consistency in SQL" to check, the results are above.

    As for the workaround, that box is already ticked. sad

  • RodneyC's avatar
    RodneyC
    Level 4
    13 years ago

    After trying lots of different things...datasebase fixes, restarts, test backups, copying backups, changing selections etc, I've now narrowed the fault down to a different problem...exchange.

    So backup are now working but not with exchange,

    Backup- \\SERVER\Microsoft Information Store\First Storage Group WARNING: "\\SERVER\Microsoft Information Store\First Storage Group\Mailbox Store (SERVER)" is a corrupt file.
    This file cannot verify.
    Verify- \\SERVER\Microsoft Information Store\First Storage Group WARNING: "Mailbox Store (SERVER)" is a corrupt file.
    This file cannot verify.

     

    So the SQL problem has now gone, I just can't complete a backup with exchange in the selection. Looks like I need to do an offline defrag of exchange to try and fix it then I expect Backup Exec to be working again.

  • CraigV's avatar
    CraigV
    Moderator
    13 years ago

    ...turn off AOFO if you're running it an try again...

  • RodneyC's avatar
    RodneyC
    Level 4
    13 years ago

    Thanks Craig but its already off and I have disabled "enable the restore of individual mail messages".

     

    I'm pretty sure its exchange playing up as the event viewer shows the following...

     

    Event Type: Error
    Event Source: ESE
    Event Category: Logging/Recovery
    Event ID: 478
    Date:  11/05/2012
    Time:  19:10:55
    User:  N/A
    Computer: SERVER
    Description:
    Information Store (5516) The streaming page read from the file "D:\Exchange\Exchsrvr\priv1.stm" at offset 1192656896 (0x0000000047168000) for 4096 (0x00001000) bytes failed verification due to a page checksum mismatch.  The expected checksum was 2244534997 (0x0000000085c8e2d5) and the actual checksum was 3803103718 (0x00000000e2aec1e6).  The read operation will fail with error -613 (0xfffffd9b).  If this condition persists then please restore the database from a previous backup.