May 19, 2010 at 12:24 am
We are not able backup MSDB database.There is no consistency error in the database.We have done with rebuilding of database but of no use.Also checked and found datafiles are not under AV Scanning.
===========================================================================
===========================================================================
Below is the errorlog :
LogDate ProcessInfo Text
----------------------- ------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2010-05-08 14:10:28.090 Server Microsoft SQL Server 2005 - 9.00.4226.00 (Intel X86)
May 26 2009 15:08:32
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2010-05-08 14:10:28.090 Server (c) 2005 Microsoft Corporation.
2010-05-08 14:10:28.090 Server All rights reserved.
2010-05-08 14:10:28.090 Server Server process ID is 4244.
2010-05-08 14:10:28.090 Server Authentication mode is MIXED.
2010-05-08 14:10:28.090 Server Logging SQL Server messages in file 'D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-05-08 14:10:28.090 Server This instance of SQL Server last reported using a process ID of 4456 at 5/8/2010 2:09:24 PM (local) 5/8/2010 8:39:24 AM (UTC). This is an informational message only; no user action is required.
2010-05-08 14:10:28.090 Server Registry startup parameters:
2010-05-08 14:10:28.090 Server -d D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-05-08 14:10:28.090 Server -e D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-05-08 14:10:28.090 Server -l D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-05-08 14:10:28.100 Server SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
2010-05-08 14:10:28.100 Server Detected 4 CPUs. This is an informational message; no user action is required.
2010-05-08 14:10:28.130 Server Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2010-05-08 14:10:28.190 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-05-08 14:10:28.210 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-05-08 14:10:30.250 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-05-08 14:10:30.250 Server Database mirroring has been enabled on this instance of SQL Server.
2010-05-08 14:10:30.250 spid4s Starting up database 'master'.
2010-05-08 14:10:30.340 spid4s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-05-08 14:10:30.350 spid4s CHECKDB for database 'master' finished without errors on 2009-08-12 10:18:05.127 (local time). This is an informational message only; no user action is required.
2010-05-08 14:10:30.360 spid4s SQL Trace ID 1 was started by login "sa".
2010-05-08 14:10:30.390 spid4s Starting up database 'mssqlsystemresource'.
2010-05-08 14:10:30.400 spid4s The resource database build version is 9.00.4226. This is an informational message only. No user action is required.
2010-05-08 14:10:30.570 spid4s Error: 15466, Severity: 16, State: 1.
2010-05-08 14:10:30.570 spid4s An error occurred during decryption.
2010-05-08 14:10:30.620 spid9s Starting up database 'model'.
2010-05-08 14:10:30.620 spid4s Server name is 'JDB-REPLICA'. This is an informational message only. No user action is required.
2010-05-08 14:10:30.760 spid9s Clearing tempdb database.
2010-05-08 14:10:30.850 spid9s Starting up database 'tempdb'.
2010-05-08 14:10:30.950 spid12s The Service Broker protocol transport is disabled or not configured.
2010-05-08 14:10:30.950 spid12s The Database Mirroring protocol transport is disabled or not configured.
2010-05-08 14:10:30.960 spid12s Service Broker manager has started.
2010-05-08 14:10:30.960 Server A self-generated certificate was successfully loaded for encryption.
2010-05-08 14:10:30.970 Server Server is listening on [ 'any' <ipv4> 1433].
2010-05-08 14:10:30.970 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-05-08 14:10:30.970 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-05-08 14:10:30.970 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-05-08 14:10:30.970 Server Dedicated admin connection support was established for listening locally on port 1434.
2010-05-08 14:10:31.070 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-05-08 14:10:31.100 spid20s Starting up database 'JCTX'.
2010-05-08 14:10:31.100 spid21s Starting up database 'TRACE'.
2010-05-08 14:10:31.100 spid18s Starting up database 'C001'.
2010-05-08 14:10:31.100 spid19s Starting up database 'msdb'.
2010-05-08 14:10:31.100 spid22s Starting up database 'JEENAPRODUCTIONNEW'.
2010-05-08 14:10:31.100 spid23s Starting up database 'COMPDATA'.
2010-05-08 14:10:31.100 spid24s Starting up database 'C002'.
2010-05-08 14:10:32.020 spid19s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-05-08 14:10:32.030 spid19s CHECKDB for database 'msdb' finished without errors on 2009-08-12 10:19:29.437 (local time). This is an informational message only; no user action is required.
2010-05-08 14:10:34.220 spid22s Analysis of database 'JEENAPRODUCTIONNEW' (8) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2010-05-08 14:10:34.350 spid22s CHECKDB for database 'JEENAPRODUCTIONNEW' finished without errors on 2009-05-23 09:46:11.597 (local time). This is an informational message only; no user action is required.
2010-05-08 14:10:34.720 spid4s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-05-08 14:10:34.720 spid4s Error: 8355, Severity: 16, State: 1.
2010-05-08 14:10:34.720 spid4s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
2010-05-08 14:10:34.720 spid4s Recovery is complete. This is an informational message only. No user action is required.
2010-05-08 14:10:40.480 spid52 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-05-08 14:10:40.920 spid52 Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2010-05-08 14:10:41.030 spid52 Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2010-05-08 14:10:41.070 spid52 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-05-08 14:12:16.730 spid62 Using 'dbghelp.dll' version '4.0.5'
2010-05-08 14:12:16.740 spid62 ***Stack Dump being sent to D:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0063.txt
2010-05-08 14:12:16.740 spid62 SqlDumpExceptionHandler: Process 4988 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2010-05-08 14:12:16.740 spid62 * *******************************************************************************
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 * BEGIN STACK DUMP:
2010-05-08 14:12:16.740 spid62 * 05/08/10 14:12:16 spid 62
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 * Exception Address = 023102BB Module(sqlservr+013102BB)
2010-05-08 14:12:16.740 spid62 * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2010-05-08 14:12:16.740 spid62 * Access Violation occurred reading address 00000620
2010-05-08 14:12:16.740 spid62 * Input Buffer 152 bytes -
2010-05-08 14:12:16.740 spid62 * backup database msdb to disk='G:\clover\msdb.bak' with stat
2010-05-08 14:12:16.740 spid62 * s=1
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 * MODULE BASE END SIZE
2010-05-08 14:12:16.740 spid62 * sqlservr 01000000 02C22FFF 01c23000
2010-05-08 14:12:16.740 spid62 * ntdll 7D600000 7D6EFFFF 000f0000
2010-05-08 14:12:16.740 spid62 * kernel32 7D4C0000 7D5EFFFF 00130000
2010-05-08 14:12:16.740 spid62 * MSVCR80 78130000 781CAFFF 0009b000
2010-05-08 14:12:16.740 spid62 * msvcrt 77BA0000 77BF9FFF 0005a000
2010-05-08 14:12:16.740 spid62 * MSVCP80 7C420000 7C4A6FFF 00087000
2010-05-08 14:12:16.740 spid62 * ADVAPI32 7D1E0000 7D27BFFF 0009c000
2010-05-08 14:12:16.740 spid62 * RPCRT4 7DA20000 7DAFFFFF 000e0000
2010-05-08 14:12:16.740 spid62 * Secur32 7D8D0000 7D91FFFF 00050000
2010-05-08 14:12:16.740 spid62 * sqlos 344D0000 344D4FFF 00005000
2010-05-08 14:12:16.740 spid62 * USERENV 76920000 769E1FFF 000c2000
2010-05-08 14:12:16.740 spid62 * USER32 7D930000 7D9FFFFF 000d0000
2010-05-08 14:12:16.740 spid62 * GDI32 7D800000 7D88FFFF 00090000
2010-05-08 14:12:16.740 spid62 * WINMM 76AA0000 76ACCFFF 0002d000
2010-05-08 14:12:16.740 spid62 * opends60 333E0000 333E6FFF 00007000
2010-05-08 14:12:16.740 spid62 * NETAPI32 71C40000 71C96FFF 00057000
2010-05-08 14:12:16.740 spid62 * psapi 76B70000 76B7AFFF 0000b000
2010-05-08 14:12:16.740 spid62 * instapi 48060000 48069FFF 0000a000
2010-05-08 14:12:16.740 spid62 * sqlevn70 4F610000 4F7B8FFF 001a9000
2010-05-08 14:12:16.740 spid62 * NTMARTA 03260000 03280FFF 00021000
2010-05-08 14:12:16.740 spid62 * WLDAP32 76F10000 76F3DFFF 0002e000
2010-05-08 14:12:16.740 spid62 * SAMLIB 7E020000 7E02EFFF 0000f000
2010-05-08 14:12:16.740 spid62 * ole32 77670000 777A8FFF 00139000
2010-05-08 14:12:16.740 spid62 * rsaenh 097A0000 097D4FFF 00035000
2010-05-08 14:12:16.740 spid62 * AUTHZ 76C40000 76C53FFF 00014000
2010-05-08 14:12:16.740 spid62 * MSCOREE 0A270000 0A2B5FFF 00046000
2010-05-08 14:12:16.740 spid62 * msapsspc 0A4D0000 0A4E3FFF 00014000
2010-05-08 14:12:16.740 spid62 * MSVCRT40 78080000 78090FFF 00011000
2010-05-08 14:12:16.740 spid62 * msnsspc 0A500000 0A54FFFF 00050000
2010-05-08 14:12:16.740 spid62 * msv1_0 76C90000 76CB6FFF 00027000
2010-05-08 14:12:16.740 spid62 * cryptdll 0A560000 0A56BFFF 0000c000
2010-05-08 14:12:16.740 spid62 * WS2_32 71C00000 71C16FFF 00017000
2010-05-08 14:12:16.740 spid62 * WS2HELP 71BF0000 71BF7FFF 00008000
2010-05-08 14:12:16.740 spid62 * iphlpapi 76CF0000 76D09FFF 0001a000
2010-05-08 14:12:16.740 spid62 * Kerberos 0A5C0000 0A618FFF 00059000
2010-05-08 14:12:16.740 spid62 * MSASN1 0A620000 0A631FFF 00012000
2010-05-08 14:12:16.740 spid62 * schannel 0A650000 0A677FFF 00028000
2010-05-08 14:12:16.740 spid62 * CRYPT32 0A680000 0A712FFF 00093000
2010-05-08 14:12:16.740 spid62 * COMRES 0A760000 0A825FFF 000c6000
2010-05-08 14:12:16.740 spid62 * XOLEHLP 0A830000 0A835FFF 00006000
2010-05-08 14:12:16.740 spid62 * MSDTCPRX 0A840000 0A8B8FFF 00079000
2010-05-08 14:12:16.740 spid62 * OLEAUT32 0A8C0000 0A94AFFF 0008b000
2010-05-08 14:12:16.740 spid62 * msvcp60 0A950000 0A9B4FFF 00065000
2010-05-08 14:12:16.740 spid62 * MTXCLU 0A9C0000 0A9D8FFF 00019000
2010-05-08 14:12:16.740 spid62 * VERSION 77B90000 77B97FFF 00008000
2010-05-08 14:12:16.740 spid62 * WSOCK32 71BB0000 71BB8FFF 00009000
2010-05-08 14:12:16.740 spid62 * CLUSAPI 0A9E0000 0A9F1FFF 00012000
2010-05-08 14:12:16.740 spid62 * RESUTILS 0AA00000 0AA12FFF 00013000
2010-05-08 14:12:16.740 spid62 * mswsock 0AA30000 0AAAFFFF 00080000
2010-05-08 14:12:16.740 spid62 * DNSAPI 76ED0000 76EF9FFF 0002a000
2010-05-08 14:12:16.740 spid62 * winrnr 0AAF0000 0AAF6FFF 00007000
2010-05-08 14:12:16.740 spid62 * rasadhlp 0AB10000 0AB14FFF 00005000
2010-05-08 14:12:16.740 spid62 * security 0AFE0000 0AFE3FFF 00004000
2010-05-08 14:12:16.740 spid62 * msfte 0B910000 0BB69FFF 0025a000
2010-05-08 14:12:16.740 spid62 * dbghelp 0BB70000 0BC84FFF 00115000
2010-05-08 14:12:16.740 spid62 * WINTRUST 76BB0000 76BDBFFF 0002c000
2010-05-08 14:12:16.740 spid62 * imagehlp 76C10000 76C37FFF 00028000
2010-05-08 14:12:16.740 spid62 * dssenh 0BFD0000 0BFF6FFF 00027000
2010-05-08 14:12:16.740 spid62 * hnetcfg 0C240000 0C299FFF 0005a000
2010-05-08 14:12:16.740 spid62 * wshtcpip 71AE0000 71AE7FFF 00008000
2010-05-08 14:12:16.740 spid62 * ntdsapi 0C3A0000 0C3B3FFF 00014000
2010-05-08 14:12:16.740 spid62 * xpsp2res 0C3C0000 0C684FFF 002c5000
2010-05-08 14:12:16.740 spid62 * CLBCatQ 777B0000 77832FFF 00083000
2010-05-08 14:12:16.740 spid62 * sqlncli 0C690000 0C8B6FFF 00227000
2010-05-08 14:12:16.740 spid62 * COMCTL32 77530000 775C6FFF 00097000
2010-05-08 14:12:16.740 spid62 * comdlg32 00A40000 00A88FFF 00049000
2010-05-08 14:12:16.740 spid62 * SHLWAPI 7D180000 7D1D1FFF 00052000
2010-05-08 14:12:16.740 spid62 * SHELL32 0C8C0000 0D0BEFFF 007ff000
2010-05-08 14:12:16.740 spid62 * comctl32 0D0C0000 0D1C2FFF 00103000
2010-05-08 14:12:16.740 spid62 * SQLNCLIR 0D1D0000 0D202FFF 00033000
2010-05-08 14:12:16.740 spid62 * msftepxy 0D390000 0D3A4FFF 00015000
2010-05-08 14:12:16.740 spid62 * xpsqlbot 0DA10000 0DA15FFF 00006000
2010-05-08 14:12:16.740 spid62 * xpstar90 0DA30000 0DA7AFFF 0004b000
2010-05-08 14:12:16.740 spid62 * SQLSCM90 0DA90000 0DA98FFF 00009000
2010-05-08 14:12:16.740 spid62 * ODBC32 0DAB0000 0DAECFFF 0003d000
2010-05-08 14:12:16.740 spid62 * BatchParser90 0DAF0000 0DB0EFFF 0001f000
2010-05-08 14:12:16.740 spid62 * ATL80 0DB20000 0DB3AFFF 0001b000
2010-05-08 14:12:16.740 spid62 * odbcint 0DD00000 0DD16FFF 00017000
2010-05-08 14:12:16.740 spid62 * xpstar90 0DD20000 0DD45FFF 00026000
2010-05-08 14:12:16.740 spid62 * xplog70 0DE50000 0DE5BFFF 0000c000
2010-05-08 14:12:16.740 spid62 * xplog70 0DE70000 0DE72FFF 00003000
2010-05-08 14:12:16.740 spid62 * dbghelp 0E120000 0E234FFF 00115000
2010-05-08 14:12:16.740 spid62 *
2010-05-08 14:12:16.740 spid62 * Edi: 4F8D4FC2:
2010-05-08 14:12:16.740 spid62 * Esi: 1CA7A6A0: 0164C8D4 1CA7A47C 1CA7A9CC 4F8F2F02 19F6236C 19F6236C
2010-05-08 14:12:16.740 spid62 * Eax: 00000000:
2010-05-08 14:12:16.740 spid62 * Ebx: 0900F600: 4E494653 0000023A 0000002C 00000000 00002000 00000003
2010-05-08 14:12:16.740 spid62 * Ecx: 00000000:
2010-05-08 14:12:16.740 spid62 * Edx: 00000000:
2010-05-08 14:12:16.740 spid62 * Eip: 023102BB: 062080F6 89020000 0474D045 40084B83 061C888B 8B890000
2010-05-08 14:12:16.740 spid62 * Ebp: 0900F890: 0900F8C8 022FEE05 00000000 1CA7AA90 1CA7A6A0 00000001
2010-05-08 14:12:16.740 spid62 * SegCs: 00000023:
2010-05-08 14:12:16.740 spid62 * EFlags: 00010246: 00720067 006D0061 00360057 00330034 003D0032 003A0043
2010-05-08 14:12:16.740 spid62 * Esp: 0900F600: 4E494653 0000023A 0000002C 00000000 00002000 00000003
2010-05-08 14:12:16.740 spid62 * SegSs: 0000002B:
2010-05-08 14:12:16.740 spid62 * *******************************************************************************
2010-05-08 14:12:16.740 spid62 * -------------------------------------------------------------------------------
2010-05-08 14:12:16.740 spid62 * Short Stack Dump
2010-05-08 14:12:16.740 spid62 023102BB Module(sqlservr+013102BB)
2010-05-08 14:12:16.740 spid62 022FEE05 Module(sqlservr+012FEE05)
2010-05-08 14:12:16.740 spid62 022FDC93 Module(sqlservr+012FDC93)
2010-05-08 14:12:16.740 spid62 02315952 Module(sqlservr+01315952)
2010-05-08 14:12:16.740 spid62 02316971 Module(sqlservr+01316971)
2010-05-08 14:12:16.740 spid62 0231E08B Module(sqlservr+0131E08B)
2010-05-08 14:12:16.740 spid62 013583E5 Module(sqlservr+003583E5)
2010-05-08 14:12:16.740 spid62 01006684 Module(sqlservr+00006684)
2010-05-08 14:12:16.740 spid62 010067AA Module(sqlservr+000067AA)
2010-05-08 14:12:16.740 spid62 010064BA Module(sqlservr+000064BA)
2010-05-08 14:12:16.740 spid62 0145E8D4 Module(sqlservr+0045E8D4)
2010-05-08 14:12:16.740 spid62 0145F88C Module(sqlservr+0045F88C)
2010-05-08 14:12:16.740 spid62 0145F33C Module(sqlservr+0045F33C)
2010-05-08 14:12:16.750 spid62 0145F4D9 Module(sqlservr+0045F4D9)
2010-05-08 14:12:16.750 spid62 781329BB Module(MSVCR80+000029BB)
2010-05-08 14:12:16.750 spid62 78132A47 Module(MSVCR80+00002A47)
2010-05-08 14:12:16.760 spid62 Stack Signature for the dump is 0xC8B6319A
2010-05-08 14:12:17.120 spid62 External dump process return code 0x20002001.
The error information has been submitted to Watson error reporting.
2010-05-08 14:12:17.120 Backup Error: 3041, Severity: 16, State: 1.
2010-05-08 14:12:17.120 Backup BACKUP failed to complete the command BACKUP DATABASE msdb. Check the backup application log for detailed messages.
(195 row(s) affected)
May 19, 2010 at 12:28 am
2010-05-08 14:10:34.720 spid4s Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply