[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Express 2005 dump log problem - running out of disk space

Posted on 2009-12-31
5
Medium Priority
?
1,287 Views
Last Modified: 2012-05-08
Hi everyone,

I got back from my holiday and noticed that our server running SQL Server Express 2005 (SP2) run out of disk space.
After short investigation I found that the error logs took up all the disk space:
Folder C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG
consists of more than 60GB of files such as

SQLDumpXXXX.txt
SQLDumpXXXX.log
SQLDmprXXXX.mdmp

The server is running two instances: Symantec Backup Exec and VMware vCenter.

CPU usage remains close to 50% (sqlservr.exe).

This all looks very similar to this post:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23359245.html

I do not want to just blindly execute the scripts from the solution above, as the database that has issues is probably different in my case.

Can anyone have a look at that and advise? I have no experience in SQL and I dont know what to change in the script file.

Quick help greatly appreciated.

Example of SQLdumpxxxx.log

77670000  777A8FFF  00139000
2009-12-25 06:28:51.89 spid51      * msv1_0                         76C90000  76CB6FFF  00027000
2009-12-25 06:28:51.89 spid51      * cryptdll                       766E0000  766EBFFF  0000c000
2009-12-25 06:28:51.89 spid51      * iphlpapi                       76CF0000  76D09FFF  0001a000
2009-12-25 06:28:51.89 spid51      * kerberos                       71CA0000  71CF8FFF  00059000
2009-12-25 06:28:51.89 spid51      * schannel                       76750000  76777FFF  00028000
2009-12-25 06:28:51.89 spid51      * security                       71F60000  71F63FFF  00004000
2009-12-25 06:28:51.89 spid51      * VERSION                        77B90000  77B97FFF  00008000
2009-12-25 06:28:51.89 spid51      * dssenh                         68100000  68126FFF  00027000
2009-12-25 06:28:51.89 spid51      * hnetcfg                        34220000  34279FFF  0005a000
2009-12-25 06:28:51.89 spid51      * wshtcpip                       71AE0000  71AE7FFF  00008000
2009-12-25 06:28:51.89 spid51      * NTMARTA                        77E00000  77E20FFF  00021000
2009-12-25 06:28:51.89 spid51      * WLDAP32                        76F10000  76F3DFFF  0002e000
2009-12-25 06:28:51.89 spid51      * SAMLIB                         7E020000  7E02EFFF  0000f000
2009-12-25 06:28:51.89 spid51      * ntdsapi                        766F0000  76703FFF  00014000
2009-12-25 06:28:51.89 spid51      * DNSAPI                         76ED0000  76EF9FFF  0002a000
2009-12-25 06:28:51.89 spid51      * winrnr                         76F70000  76F76FFF  00007000
2009-12-25 06:28:51.89 spid51      * rasadhlp                       76F80000  76F84FFF  00005000
2009-12-25 06:28:51.89 spid51      * xpsp2res                       4A080000  4A344FFF  002c5000
2009-12-25 06:28:51.89 spid51      * CLBCatQ                        777B0000  77832FFF  00083000
2009-12-25 06:28:51.89 spid51      * OLEAUT32                       77D00000  77D8AFFF  0008b000
2009-12-25 06:28:51.89 spid51      * COMRes                         77010000  770D5FFF  000c6000
2009-12-25 06:28:51.89 spid51      * sqlncli                        4A370000  4A596FFF  00227000
2009-12-25 06:28:51.89 spid51      * COMCTL32                       77530000  775C6FFF  00097000
2009-12-25 06:28:51.89 spid51      * comdlg32                       762B0000  762F8FFF  00049000
2009-12-25 06:28:51.89 spid51      * SQLNCLIR                       4A5C0000  4A5F2FFF  00033000
2009-12-25 06:28:51.89 spid51      * XPDLOShareu                    4A600000  4A81BFFF  0021c000
2009-12-25 06:28:51.89 spid51      * MPR                            71BD0000  71BE0FFF  00011000
2009-12-25 06:28:51.89 spid51      * SensApi                        722F0000  722F4FFF  00005000
2009-12-25 06:28:51.89 spid51      * msi                            745E0000  7489DFFF  002be000
2009-12-25 06:28:51.89 spid51      * OLEACC                         7FE00000  7FE30FFF  00031000
2009-12-25 06:28:51.89 spid51      * msvcp60                        4A820000  4A884FFF  00065000
2009-12-25 06:28:51.89 spid51      * WINSPOOL                       73070000  73096FFF  00027000
2009-12-25 06:28:51.89 spid51      * xplog70                        34010000  3401BFFF  0000c000
2009-12-25 06:28:51.89 spid51      * xplog70                        49B70000  49B72FFF  00003000
2009-12-25 06:28:51.89 spid51      * dbghelp                        4AC60000  4AD74FFF  00115000
2009-12-25 06:28:51.89 spid51      *
2009-12-25 06:28:51.89 spid51      *        Edi: 49F6E544:  00148A70  49F6E638  00000000  099174F8  49F6E650  0246A875  
2009-12-25 06:28:51.89 spid51      *        Esi: 00000000:  
2009-12-25 06:28:51.89 spid51      *        Eax: 49F6D6E0:  000042AC  00000000  00000000  77E4BEF7  00000000  7C827739  
2009-12-25 06:28:51.89 spid51      *        Ebx: 0000003F:  
2009-12-25 06:28:51.89 spid51      *        Ecx: 49F6DD50:  00000000  00010007  0000002E  49F6FF5C  00A30040  049000E8  
2009-12-25 06:28:51.89 spid51      *        Edx: 0000003D:  
2009-12-25 06:28:51.89 spid51      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF  
2009-12-25 06:28:51.89 spid51      *        Ebp: 49F6D730:  49F6D774  021A29C4  000042AC  00000000  00000000  00000000  
2009-12-25 06:28:51.89 spid51      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:51.89 spid51      *     EFlags: 00000246:  
2009-12-25 06:28:51.89 spid51      *        Esp: 49F6D6DC:  03D1B2E0  000042AC  00000000  00000000  77E4BEF7  00000000  
2009-12-25 06:28:51.89 spid51      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:51.89 spid51      * *******************************************************************************
2009-12-25 06:28:51.89 spid51      * -------------------------------------------------------------------------------
2009-12-25 06:28:51.89 spid51      * Short Stack Dump
2009-12-25 06:28:51.90 spid51      77E4BEF7 Module(kernel32+0000BEF7)
2009-12-25 06:28:51.90 spid51      021A29C4 Module(sqlservr+011A29C4)
2009-12-25 06:28:51.90 spid51      021A6880 Module(sqlservr+011A6880)
2009-12-25 06:28:51.90 spid51      01E509E1 Module(sqlservr+00E509E1)
2009-12-25 06:28:51.90 spid51      01E50B97 Module(sqlservr+00E50B97)
2009-12-25 06:28:51.90 spid51      014DF027 Module(sqlservr+004DF027)
2009-12-25 06:28:51.90 spid51      01026125 Module(sqlservr+00026125)
2009-12-25 06:28:51.90 spid51      01058EEF Module(sqlservr+00058EEF)
2009-12-25 06:28:51.90 spid51      01033160 Module(sqlservr+00033160)
2009-12-25 06:28:51.90 spid51      010259F5 Module(sqlservr+000259F5)
2009-12-25 06:28:51.90 spid51      01048CD2 Module(sqlservr+00048CD2)
2009-12-25 06:28:51.90 spid51      01048B4C Module(sqlservr+00048B4C)
2009-12-25 06:28:51.90 spid51      010227F3 Module(sqlservr+000227F3)
2009-12-25 06:28:51.90 spid51      010293B5 Module(sqlservr+000293B5)
2009-12-25 06:28:51.90 spid51      010286DC Module(sqlservr+000286DC)
2009-12-25 06:28:51.90 spid51      01C1A0E2 Module(sqlservr+00C1A0E2)
2009-12-25 06:28:51.90 spid51      01C19CC2 Module(sqlservr+00C19CC2)
2009-12-25 06:28:51.90 spid51      01C1C517 Module(sqlservr+00C1C517)
2009-12-25 06:28:51.90 spid51      01C1CDFF Module(sqlservr+00C1CDFF)
2009-12-25 06:28:51.90 spid51      01032A36 Module(sqlservr+00032A36)
2009-12-25 06:28:51.90 spid51      0102F1F4 Module(sqlservr+0002F1F4)
2009-12-25 06:28:51.90 spid51      010077A6 Module(sqlservr+000077A6)
2009-12-25 06:28:51.90 spid51      010078CC Module(sqlservr+000078CC)
2009-12-25 06:28:51.90 spid51      010075DC Module(sqlservr+000075DC)
2009-12-25 06:28:51.90 spid51      010B94A5 Module(sqlservr+000B94A5)
2009-12-25 06:28:51.90 spid51      010B939C Module(sqlservr+000B939C)
2009-12-25 06:28:51.90 spid51      010B9064 Module(sqlservr+000B9064)
2009-12-25 06:28:51.90 spid51      010B9201 Module(sqlservr+000B9201)
2009-12-25 06:28:51.90 spid51      781329BB Module(MSVCR80+000029BB)
2009-12-25 06:28:51.90 spid51      78132A47 Module(MSVCR80+00002A47)
2009-12-25 06:28:51.90 spid51      Stack Signature for the dump is 0x584ADA4F
2009-12-25 06:28:52.11 spid51      External dump process return code 0x20000001.
External dump process returned no errors.

2009-12-25 06:28:52.19 spid51      Using 'dbghelp.dll' version '4.0.5'
2009-12-25 06:28:52.19 spid51      **Dump thread - spid = 51, PSS = 0x03D1B2E0, EC = 0x03D1B2E8
2009-12-25 06:28:52.19 spid51      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump2920.txt
2009-12-25 06:28:52.19 spid51      * *******************************************************************************
2009-12-25 06:28:52.19 spid51      *
2009-12-25 06:28:52.19 spid51      * BEGIN STACK DUMP:
2009-12-25 06:28:52.19 spid51      *   12/25/09 06:28:52 spid 51
2009-12-25 06:28:52.19 spid51      *
2009-12-25 06:28:52.19 spid51      * CPerIndexMetaQS::ErrorAbort - Index corruption
2009-12-25 06:28:52.19 spid51      *
2009-12-25 06:28:52.19 spid51      * Input Buffer 228 bytes -
2009-12-25 06:28:52.19 spid51      *  ÿÿ      &  ÿÿÿÿ  c ff ff 0d 00 00 00 00 01 26 04 04 ff ff ff ff 00 00 63
2009-12-25 06:28:52.19 spid51      *      	 Ð 4    @ P 1 0e 00 00 00 09 04 d0 00 34 0e 00 00 00 40 00 50 00 31
2009-12-25 06:28:52.19 spid51      *     i n t   cž   	  00 20 00 69 00 6e 00 74 00 00 00 63 9e 00 00 00 09 04
2009-12-25 06:28:52.19 spid51      *  Ð 4ž   U P D A T E d0 00 34 9e 00 00 00 55 00 50 00 44 00 41 00 54 00 45
2009-12-25 06:28:52.19 spid51      *     M e d i a   S E 00 20 00 4d 00 65 00 64 00 69 00 61 00 20 00 53 00 45
2009-12-25 06:28:52.19 spid51      *   T   L o c a t i o 00 54 00 20 00 4c 00 6f 00 63 00 61 00 74 00 69 00 6f
2009-12-25 06:28:52.19 spid51      *   n I D   =   0 ,   00 6e 00 49 00 44 00 20 00 3d 00 20 00 30 00 2c 00 20
2009-12-25 06:28:52.19 spid51      *   L o c a t i o n I 00 4c 00 6f 00 63 00 61 00 74 00 69 00 6f 00 6e 00 49
2009-12-25 06:28:52.19 spid51      *   n d e x   =   0   00 6e 00 64 00 65 00 78 00 20 00 3d 00 20 00 30 00 20
2009-12-25 06:28:52.19 spid51      *   W H E R E   (   L 00 57 00 48 00 45 00 52 00 45 00 20 00 28 00 20 00 4c
2009-12-25 06:28:52.19 spid51      *   o c a t i o n I D 00 6f 00 63 00 61 00 74 00 69 00 6f 00 6e 00 49 00 44
2009-12-25 06:28:52.19 spid51      *     =   @ P 1   )   00 20 00 3d 00 20 00 40 00 50 00 31 00 20 00 29 00 20
2009-12-25 06:28:52.19 spid51      *   ;   &  ë          00 3b 00 00 00 26 04 04 eb 03 00 00
2009-12-25 06:28:52.19 spid51      *  
2009-12-25 06:28:52.19 spid51      *
2009-12-25 06:28:52.19 spid51      *  MODULE                          BASE      END       SIZE
2009-12-25 06:28:52.19 spid51      * sqlservr                       01000000  02C09FFF  01c0a000
2009-12-25 06:28:52.19 spid51      * ntdll                          7C800000  7C8C1FFF  000c2000
2009-12-25 06:28:52.19 spid51      * kernel32                       77E40000  77F41FFF  00102000
2009-12-25 06:28:52.19 spid51      * MSVCR80                        78130000  781CAFFF  0009b000
2009-12-25 06:28:52.19 spid51      * msvcrt                         77BA0000  77BF9FFF  0005a000
2009-12-25 06:28:52.19 spid51      * MSVCP80                        7C420000  7C4A6FFF  00087000
2009-12-25 06:28:52.19 spid51      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
2009-12-25 06:28:52.19 spid51      * RPCRT4                         77C50000  77CEEFFF  0009f000
2009-12-25 06:28:52.19 spid51      * Secur32                        76F50000  76F62FFF  00013000
2009-12-25 06:28:52.19 spid51      * USER32                         77380000  77410FFF  00091000
2009-12-25 06:28:52.19 spid51      * GDI32                          77C00000  77C48FFF  00049000
2009-12-25 06:28:52.19 spid51      * CRYPT32                        761B0000  76242FFF  00093000
2009-12-25 06:28:52.19 spid51      * MSASN1                         76190000  761A1FFF  00012000
2009-12-25 06:28:52.19 spid51      * MSWSOCK                        71B20000  71B60FFF  00041000
2009-12-25 06:28:52.19 spid51      * WS2_32                         71C00000  71C16FFF  00017000
2009-12-25 06:28:52.19 spid51      * WS2HELP                        71BF0000  71BF7FFF  00008000
2009-12-25 06:28:52.19 spid51      * USERENV                        76920000  769E1FFF  000c2000
2009-12-25 06:28:52.19 spid51      * opends60                       333E0000  333E6FFF  00007000
2009-12-25 06:28:52.19 spid51      * NETAPI32                       71C40000  71C96FFF  00057000
2009-12-25 06:28:52.19 spid51      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
2009-12-25 06:28:52.19 spid51      * SHLWAPI                        77DA0000  77DF1FFF  00052000
2009-12-25 06:28:52.19 spid51      * IMM32                          76290000  762ACFFF  0001d000
2009-12-25 06:28:52.19 spid51      * comctl32                       77420000  77522FFF  00103000
2009-12-25 06:28:52.19 spid51      * psapi                          76B70000  76B7AFFF  0000b000
2009-12-25 06:28:52.19 spid51      * instapi                        48060000  48069FFF  0000a000
2009-12-25 06:28:52.19 spid51      * sqlevn70                       4F610000  4F7B8FFF  001a9000
2009-12-25 06:28:52.19 spid51      * SQLOS                          344D0000  344D4FFF  00005000
2009-12-25 06:28:52.19 spid51      * rsaenh                         68000000  68034FFF  00035000
2009-12-25 06:28:52.19 spid51      * AUTHZ                          76C40000  76C53FFF  00014000
2009-12-25 06:28:52.19 spid51      * MSCOREE                        79000000  79045FFF  00046000
2009-12-25 06:28:52.19 spid51      * ole32                          77670000  777A8FFF  00139000
2009-12-25 06:28:52.19 spid51      * msv1_0                         76C90000  76CB6FFF  00027000
2009-12-25 06:28:52.19 spid51      * cryptdll                       766E0000  766EBFFF  0000c000
2009-12-25 06:28:52.19 spid51      * iphlpapi                       76CF0000  76D09FFF  0001a000
2009-12-25 06:28:52.19 spid51      * kerberos                       71CA0000  71CF8FFF  00059000
2009-12-25 06:28:52.19 spid51      * schannel                       76750000  76777FFF  00028000
2009-12-25 06:28:52.19 spid51      * security                       71F60000  71F63FFF  00004000
2009-12-25 06:28:52.19 spid51      * VERSION                        77B90000  77B97FFF  00008000
2009-12-25 06:28:52.19 spid51      * dssenh                         68100000  68126FFF  00027000
2009-12-25 06:28:52.19 spid51      * hnetcfg                        34220000  34279FFF  0005a000
2009-12-25 06:28:52.19 spid51      * wshtcpip                       71AE0000  71AE7FFF  00008000
2009-12-25 06:28:52.19 spid51      * NTMARTA                        77E00000  77E20FFF  00021000
2009-12-25 06:28:52.19 spid51      * WLDAP32                        76F10000  76F3DFFF  0002e000
2009-12-25 06:28:52.19 spid51      * SAMLIB                         7E020000  7E02EFFF  0000f000
2009-12-25 06:28:52.19 spid51      * ntdsapi                        766F0000  76703FFF  00014000
2009-12-25 06:28:52.19 spid51      * DNSAPI                         76ED0000  76EF9FFF  0002a000
2009-12-25 06:28:52.19 spid51      * winrnr                         76F70000  76F76FFF  00007000
2009-12-25 06:28:52.19 spid51      * rasadhlp                       76F80000  76F84FFF  00005000
2009-12-25 06:28:52.19 spid51      * xpsp2res                       4A080000  4A344FFF  002c5000
2009-12-25 06:28:52.19 spid51      * CLBCatQ                        777B0000  77832FFF  00083000
2009-12-25 06:28:52.19 spid51      * OLEAUT32                       77D00000  77D8AFFF  0008b000
2009-12-25 06:28:52.19 spid51      * COMRes                         77010000  770D5FFF  000c6000
2009-12-25 06:28:52.19 spid51      * sqlncli                        4A370000  4A596FFF  00227000
2009-12-25 06:28:52.19 spid51      * COMCTL32                       77530000  775C6FFF  00097000
2009-12-25 06:28:52.19 spid51      * comdlg32                       762B0000  762F8FFF  00049000
2009-12-25 06:28:52.19 spid51      * SQLNCLIR                       4A5C0000  4A5F2FFF  00033000
2009-12-25 06:28:52.19 spid51      * XPDLOShareu                    4A600000  4A81BFFF  0021c000
2009-12-25 06:28:52.19 spid51      * MPR                            71BD0000  71BE0FFF  00011000
2009-12-25 06:28:52.19 spid51      * SensApi                        722F0000  722F4FFF  00005000
2009-12-25 06:28:52.19 spid51      * msi                            745E0000  7489DFFF  002be000
2009-12-25 06:28:52.19 spid51      * OLEACC                         7FE00000  7FE30FFF  00031000
2009-12-25 06:28:52.19 spid51      * msvcp60                        4A820000  4A884FFF  00065000
2009-12-25 06:28:52.19 spid51      * WINSPOOL                       73070000  73096FFF  00027000
2009-12-25 06:28:52.19 spid51      * xplog70                        34010000  3401BFFF  0000c000
2009-12-25 06:28:52.19 spid51      * xplog70                        49B70000  49B72FFF  00003000
2009-12-25 06:28:52.19 spid51      * dbghelp                        4AC60000  4AD74FFF  00115000
2009-12-25 06:28:52.19 spid51      *
2009-12-25 06:28:52.19 spid51      *        Edi: 49F6E544:  00148A70  49F6E638  00000000  099174F8  49F6E650  0246A875  
2009-12-25 06:28:52.19 spid51      *        Esi: 00000000:  
2009-12-25 06:28:52.19 spid51      *        Eax: 49F6D6E0:  000042AC  00000000  00000000  77E4BEF7  00000000  7C827739  
2009-12-25 06:28:52.19 spid51      *        Ebx: 0000003F:  
2009-12-25 06:28:52.19 spid51      *        Ecx: 49F6DD50:  00000000  00010007  0000002E  49F6FF5C  00A30040  049000E8  
2009-12-25 06:28:52.19 spid51      *        Edx: 0000003D:  
2009-12-25 06:28:52.19 spid51      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF  
2009-12-25 06:28:52.19 spid51      *        Ebp: 49F6D730:  49F6D774  021A29C4  000042AC  00000000  00000000  00000000  
2009-12-25 06:28:52.19 spid51      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:52.19 spid51      *     EFlags: 00000246:  
2009-12-25 06:28:52.19 spid51      *        Esp: 49F6D6DC:  03D1B2E0  000042AC  00000000  00000000  77E4BEF7  00000000  
2009-12-25 06:28:52.19 spid51      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:52.19 spid51      * *******************************************************************************
2009-12-25 06:28:52.19 spid51      * -------------------------------------------------------------------------------
2009-12-25 06:28:52.19 spid51      * Short Stack Dump
2009-12-25 06:28:52.20 spid51      77E4BEF7 Module(kernel32+0000BEF7)
2009-12-25 06:28:52.20 spid51      021A29C4 Module(sqlservr+011A29C4)
2009-12-25 06:28:52.20 spid51      021A6880 Module(sqlservr+011A6880)
2009-12-25 06:28:52.20 spid51      01E509E1 Module(sqlservr+00E509E1)
2009-12-25 06:28:52.20 spid51      01E50B97 Module(sqlservr+00E50B97)
2009-12-25 06:28:52.20 spid51      014DF027 Module(sqlservr+004DF027)
2009-12-25 06:28:52.20 spid51      01026125 Module(sqlservr+00026125)
2009-12-25 06:28:52.20 spid51      01058EEF Module(sqlservr+00058EEF)
2009-12-25 06:28:52.20 spid51      01033160 Module(sqlservr+00033160)
2009-12-25 06:28:52.20 spid51      010259F5 Module(sqlservr+000259F5)
2009-12-25 06:28:52.20 spid51      01048CD2 Module(sqlservr+00048CD2)
2009-12-25 06:28:52.20 spid51      01048B4C Module(sqlservr+00048B4C)
2009-12-25 06:28:52.20 spid51      010227F3 Module(sqlservr+000227F3)
2009-12-25 06:28:52.20 spid51      010293B5 Module(sqlservr+000293B5)
2009-12-25 06:28:52.20 spid51      010286DC Module(sqlservr+000286DC)
2009-12-25 06:28:52.20 spid51      01C1A0E2 Module(sqlservr+00C1A0E2)
2009-12-25 06:28:52.20 spid51      01C19CC2 Module(sqlservr+00C19CC2)
2009-12-25 06:28:52.20 spid51      01C1C517 Module(sqlservr+00C1C517)
2009-12-25 06:28:52.20 spid51      01C1CDFF Module(sqlservr+00C1CDFF)
2009-12-25 06:28:52.20 spid51      01032A36 Module(sqlservr+00032A36)
2009-12-25 06:28:52.20 spid51      0102F1F4 Module(sqlservr+0002F1F4)
2009-12-25 06:28:52.20 spid51      010077A6 Module(sqlservr+000077A6)
2009-12-25 06:28:52.20 spid51      010078CC Module(sqlservr+000078CC)
2009-12-25 06:28:52.20 spid51      010075DC Module(sqlservr+000075DC)
2009-12-25 06:28:52.20 spid51      010B94A5 Module(sqlservr+000B94A5)
2009-12-25 06:28:52.20 spid51      010B939C Module(sqlservr+000B939C)
2009-12-25 06:28:52.20 spid51      010B9064 Module(sqlservr+000B9064)
2009-12-25 06:28:52.20 spid51      010B9201 Module(sqlservr+000B9201)
2009-12-25 06:28:52.20 spid51      781329BB Module(MSVCR80+000029BB)
2009-12-25 06:28:52.20 spid51      78132A47 Module(MSVCR80+00002A47)
2009-12-25 06:28:52.20 spid51      Stack Signature for the dump is 0x584ADA4F
2009-12-25 06:28:52.40 spid51      External dump process return code 0x20000001.
External dump process returned no errors.

2009-12-25 06:28:52.87 spid51      Using 'dbghelp.dll' version '4.0.5'
2009-12-25 06:28:52.87 spid51      **Dump thread - spid = 51, PSS = 0x03D1B2E0, EC = 0x03D1B2E8
2009-12-25 06:28:52.87 spid51      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump2921.txt
2009-12-25 06:28:52.87 spid51      * *******************************************************************************
2009-12-25 06:28:52.87 spid51      *
2009-12-25 06:28:52.87 spid51      * BEGIN STACK DUMP:
2009-12-25 06:28:52.87 spid51      *   12/25/09 06:28:52 spid 51
2009-12-25 06:28:52.87 spid51      *
2009-12-25 06:28:52.87 spid51      * CPerIndexMetaQS::ErrorAbort - Index corruption
2009-12-25 06:28:52.87 spid51      *
2009-12-25 06:28:52.87 spid51      * Input Buffer 228 bytes -
2009-12-25 06:28:52.87 spid51      *  ÿÿ      &  ÿÿÿÿ  c ff ff 0d 00 00 00 00 01 26 04 04 ff ff ff ff 00 00 63
2009-12-25 06:28:52.87 spid51      *      	 Ð 4    @ P 1 0e 00 00 00 09 04 d0 00 34 0e 00 00 00 40 00 50 00 31
2009-12-25 06:28:52.87 spid51      *     i n t   cž   	  00 20 00 69 00 6e 00 74 00 00 00 63 9e 00 00 00 09 04
2009-12-25 06:28:52.87 spid51      *  Ð 4ž   U P D A T E d0 00 34 9e 00 00 00 55 00 50 00 44 00 41 00 54 00 45
2009-12-25 06:28:52.87 spid51      *     M e d i a   S E 00 20 00 4d 00 65 00 64 00 69 00 61 00 20 00 53 00 45
2009-12-25 06:28:52.87 spid51      *   T   L o c a t i o 00 54 00 20 00 4c 00 6f 00 63 00 61 00 74 00 69 00 6f
2009-12-25 06:28:52.87 spid51      *   n I D   =   0 ,   00 6e 00 49 00 44 00 20 00 3d 00 20 00 30 00 2c 00 20
2009-12-25 06:28:52.87 spid51      *   L o c a t i o n I 00 4c 00 6f 00 63 00 61 00 74 00 69 00 6f 00 6e 00 49
2009-12-25 06:28:52.87 spid51      *   n d e x   =   0   00 6e 00 64 00 65 00 78 00 20 00 3d 00 20 00 30 00 20
2009-12-25 06:28:52.87 spid51      *   W H E R E   (   L 00 57 00 48 00 45 00 52 00 45 00 20 00 28 00 20 00 4c
2009-12-25 06:28:52.87 spid51      *   o c a t i o n I D 00 6f 00 63 00 61 00 74 00 69 00 6f 00 6e 00 49 00 44
2009-12-25 06:28:52.87 spid51      *     =   @ P 1   )   00 20 00 3d 00 20 00 40 00 50 00 31 00 20 00 29 00 20
2009-12-25 06:28:52.87 spid51      *   ;   &  ë          00 3b 00 00 00 26 04 04 eb 03 00 00
2009-12-25 06:28:52.87 spid51      *  
2009-12-25 06:28:52.87 spid51      *
2009-12-25 06:28:52.87 spid51      *  MODULE                          BASE      END       SIZE
2009-12-25 06:28:52.87 spid51      * sqlservr                       01000000  02C09FFF  01c0a000
2009-12-25 06:28:52.87 spid51      * ntdll                          7C800000  7C8C1FFF  000c2000
2009-12-25 06:28:52.87 spid51      * kernel32                       77E40000  77F41FFF  00102000
2009-12-25 06:28:52.87 spid51      * MSVCR80                        78130000  781CAFFF  0009b000
2009-12-25 06:28:52.87 spid51      * msvcrt                         77BA0000  77BF9FFF  0005a000
2009-12-25 06:28:52.87 spid51      * MSVCP80                        7C420000  7C4A6FFF  00087000
2009-12-25 06:28:52.87 spid51      * ADVAPI32                       7D1E0000  7D27BFFF  0009c000
2009-12-25 06:28:52.87 spid51      * RPCRT4                         77C50000  77CEEFFF  0009f000
2009-12-25 06:28:52.87 spid51      * Secur32                        76F50000  76F62FFF  00013000
2009-12-25 06:28:52.87 spid51      * USER32                         77380000  77410FFF  00091000
2009-12-25 06:28:52.87 spid51      * GDI32                          77C00000  77C48FFF  00049000
2009-12-25 06:28:52.87 spid51      * CRYPT32                        761B0000  76242FFF  00093000
2009-12-25 06:28:52.87 spid51      * MSASN1                         76190000  761A1FFF  00012000
2009-12-25 06:28:52.87 spid51      * MSWSOCK                        71B20000  71B60FFF  00041000
2009-12-25 06:28:52.87 spid51      * WS2_32                         71C00000  71C16FFF  00017000
2009-12-25 06:28:52.87 spid51      * WS2HELP                        71BF0000  71BF7FFF  00008000
2009-12-25 06:28:52.87 spid51      * USERENV                        76920000  769E1FFF  000c2000
2009-12-25 06:28:52.87 spid51      * opends60                       333E0000  333E6FFF  00007000
2009-12-25 06:28:52.87 spid51      * NETAPI32                       71C40000  71C96FFF  00057000
2009-12-25 06:28:52.87 spid51      * SHELL32                        7C8D0000  7D0CEFFF  007ff000
2009-12-25 06:28:52.87 spid51      * SHLWAPI                        77DA0000  77DF1FFF  00052000
2009-12-25 06:28:52.87 spid51      * IMM32                          76290000  762ACFFF  0001d000
2009-12-25 06:28:52.87 spid51      * comctl32                       77420000  77522FFF  00103000
2009-12-25 06:28:52.87 spid51      * psapi                          76B70000  76B7AFFF  0000b000
2009-12-25 06:28:52.87 spid51      * instapi                        48060000  48069FFF  0000a000
2009-12-25 06:28:52.87 spid51      * sqlevn70                       4F610000  4F7B8FFF  001a9000
2009-12-25 06:28:52.87 spid51      * SQLOS                          344D0000  344D4FFF  00005000
2009-12-25 06:28:52.87 spid51      * rsaenh                         68000000  68034FFF  00035000
2009-12-25 06:28:52.87 spid51      * AUTHZ                          76C40000  76C53FFF  00014000
2009-12-25 06:28:52.87 spid51      * MSCOREE                        79000000  79045FFF  00046000
2009-12-25 06:28:52.87 spid51      * ole32                          77670000  777A8FFF  00139000
2009-12-25 06:28:52.87 spid51      * msv1_0                         76C90000  76CB6FFF  00027000
2009-12-25 06:28:52.87 spid51      * cryptdll                       766E0000  766EBFFF  0000c000
2009-12-25 06:28:52.87 spid51      * iphlpapi                       76CF0000  76D09FFF  0001a000
2009-12-25 06:28:52.87 spid51      * kerberos                       71CA0000  71CF8FFF  00059000
2009-12-25 06:28:52.87 spid51      * schannel                       76750000  76777FFF  00028000
2009-12-25 06:28:52.87 spid51      * security                       71F60000  71F63FFF  00004000
2009-12-25 06:28:52.87 spid51      * VERSION                        77B90000  77B97FFF  00008000
2009-12-25 06:28:52.87 spid51      * dssenh                         68100000  68126FFF  00027000
2009-12-25 06:28:52.87 spid51      * hnetcfg                        34220000  34279FFF  0005a000
2009-12-25 06:28:52.87 spid51      * wshtcpip                       71AE0000  71AE7FFF  00008000
2009-12-25 06:28:52.87 spid51      * NTMARTA                        77E00000  77E20FFF  00021000
2009-12-25 06:28:52.87 spid51      * WLDAP32                        76F10000  76F3DFFF  0002e000
2009-12-25 06:28:52.87 spid51      * SAMLIB                         7E020000  7E02EFFF  0000f000
2009-12-25 06:28:52.87 spid51      * ntdsapi                        766F0000  76703FFF  00014000
2009-12-25 06:28:52.87 spid51      * DNSAPI                         76ED0000  76EF9FFF  0002a000
2009-12-25 06:28:52.87 spid51      * winrnr                         76F70000  76F76FFF  00007000
2009-12-25 06:28:52.87 spid51      * rasadhlp                       76F80000  76F84FFF  00005000
2009-12-25 06:28:52.87 spid51      * xpsp2res                       4A080000  4A344FFF  002c5000
2009-12-25 06:28:52.87 spid51      * CLBCatQ                        777B0000  77832FFF  00083000
2009-12-25 06:28:52.87 spid51      * OLEAUT32                       77D00000  77D8AFFF  0008b000
2009-12-25 06:28:52.87 spid51      * COMRes                         77010000  770D5FFF  000c6000
2009-12-25 06:28:52.87 spid51      * sqlncli                        4A370000  4A596FFF  00227000
2009-12-25 06:28:52.87 spid51      * COMCTL32                       77530000  775C6FFF  00097000
2009-12-25 06:28:52.87 spid51      * comdlg32                       762B0000  762F8FFF  00049000
2009-12-25 06:28:52.87 spid51      * SQLNCLIR                       4A5C0000  4A5F2FFF  00033000
2009-12-25 06:28:52.87 spid51      * XPDLOShareu                    4A600000  4A81BFFF  0021c000
2009-12-25 06:28:52.87 spid51      * MPR                            71BD0000  71BE0FFF  00011000
2009-12-25 06:28:52.87 spid51      * SensApi                        722F0000  722F4FFF  00005000
2009-12-25 06:28:52.87 spid51      * msi                            745E0000  7489DFFF  002be000
2009-12-25 06:28:52.87 spid51      * OLEACC                         7FE00000  7FE30FFF  00031000
2009-12-25 06:28:52.87 spid51      * msvcp60                        4A820000  4A884FFF  00065000
2009-12-25 06:28:52.87 spid51      * WINSPOOL                       73070000  73096FFF  00027000
2009-12-25 06:28:52.87 spid51      * xplog70                        34010000  3401BFFF  0000c000
2009-12-25 06:28:52.87 spid51      * xplog70                        49B70000  49B72FFF  00003000
2009-12-25 06:28:52.87 spid51      * dbghelp                        4AC60000  4AD74FFF  00115000
2009-12-25 06:28:52.87 spid51      *
2009-12-25 06:28:52.87 spid51      *        Edi: 49F6E544:  00148A70  49F6E638  00000000  099174F8  49F6E650  0246A875  
2009-12-25 06:28:52.87 spid51      *        Esi: 00000000:  
2009-12-25 06:28:52.87 spid51      *        Eax: 49F6D6E0:  000042AC  00000000  00000000  77E4BEF7  00000000  7C827739  
2009-12-25 06:28:52.87 spid51      *        Ebx: 0000003F:  
2009-12-25 06:28:52.87 spid51      *        Ecx: 49F6DD50:  00000000  00010007  00000000  00000000  00000000  049000E8  
2009-12-25 06:28:52.87 spid51      *        Edx: 0000003D:  
2009-12-25 06:28:52.87 spid51      *        Eip: 77E4BEF7:  10C2C95E  01093D00  840FC000  00000095  F29DE950  9090FFFF  
2009-12-25 06:28:52.87 spid51      *        Ebp: 49F6D730:  49F6D774  021A29C4  000042AC  00000000  00000000  00000000  
2009-12-25 06:28:52.87 spid51      *      SegCs: 7813001B:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:52.87 spid51      *     EFlags: 00000246:  
2009-12-25 06:28:52.87 spid51      *        Esp: 49F6D6DC:  03D1B2E0  000042AC  00000000  00000000  77E4BEF7  00000000  
2009-12-25 06:28:52.87 spid51      *      SegSs: 78130023:  00000000  00000000  00000000  00000000  00000000  00000000  
2009-12-25 06:28:52.87 spid51      * *******************************************************************************
2009-12-25 06:28:52.87 spid51      * -------------------------------------------------------------------------------
2009-12-25 06:28:52.87 spid51      * Short Stack Dump
2009-12-25 06:28:52.87 spid51      77E4BEF7 Module(kernel32+0000BEF7)
2009-12-25 06:28:52.87 spid51      021A29C4 Module(sqlservr+011A29C4)
2009-12-25 06:28:52.87 spid51      021A6880 Module(sqlservr+011A6880)
2009-12-25 06:28:52.87 spid51      01E509E1 Module(sqlservr+00E509E1)
2009-12-25 06:28:52.87 spid51      01E50B97 Module(sqlservr+00E50B97)
2009-12-25 06:28:52.87 spid51      014DF027 Module(sqlservr+004DF027)
2009-12-25 06:28:52.87 spid51      01026125 Module(sqlservr+00026125)
2009-12-25 06:28:52.87 spid51      01058EEF Module(sqlservr+00058EEF)
2009-12-25 06:28:52.87 spid51      01033160 Module(sqlservr+00033160)
2009-12-25 06:28:52.87 spid51      010259F5 Module(sqlservr+000259F5)
2009-12-25 06:28:52.87 spid51      01048CD2 Module(sqlservr+00048CD2)
2009-12-25 06:28:52.87 spid51      01048B4C Module(sqlservr+00048B4C)
2009-12-25 06:28:52.87 spid51      010227F3 Module(sqlservr+000227F3)
2009-12-25 06:28:52.87 spid51      010293B5 Module(sqlservr+000293B5)
2009-12-25 06:28:52.87 spid51      010286DC Module(sqlservr+000286DC)
2009-12-25 06:28:52.87 spid51      01C1A0E2 Module(sqlservr+00C1A0E2)
2009-12-25 06:28:52.87 spid51      01C19CC2 Module(sqlservr+00C19CC2)
2009-12-25 06:28:52.87 spid51      01C1C517 Module(sqlservr+00C1C517)
2009-12-25 06:28:52.87 spid51      01C1CDFF Module(sqlservr+00C1CDFF)
2009-12-25 06:28:52.87 spid51      01032A36 Module(sqlservr+00032A36)
2009-12-25 06:28:52.87 spid51      0102F1F4 Module(sqlservr+0002F1F4)
2009-12-25 06:28:52.87 spid51      010077A6 Module(sqlservr+000077A6)
2009-12-25 06:28:52.87 spid51      010078CC Module(sqlservr+000078CC)
2009-12-25 06:28:52.87 spid51      010075DC Module(sqlservr+000075DC)
2009-12-25 06:28:52.87 spid51      010B94A5 Module(sqlservr+000B94A5)
2009-12-25 06:28:52.87 spid51      010B939C Module(sqlservr+000B939C)
2009-12-25 06:28:52.87 spid51      010B9064 Module(sqlservr+000B9064)
2009-12-25 06:28:52.87 spid51      010B9201 Module(sqlservr+000B9201)
2009-12-25 06:28:52.87 spid51      781329BB Module(MSVCR80+000029BB)
2009-12-25 06:28:52.89 spid51      78132A47 Module(MSVCR80+00002A47)
2009-12-25 06:28:52.89 spid51      Stack Signature for the dump is 0x584ADA4F

Open in new window

0
Comment
Question by:itorana
  • 3
  • 2
5 Comments
 

Author Comment

by:itorana
ID: 26156640
and part of SQLdumpxxxx.txt:
=====================================================================                                            
       BugCheck Dump                                                                                             
=====================================================================                                            
                                                                                                                 
This file is generated by Microsoft SQL Server                                                                   
version 9.00.3042.00                                                                                             
upon detection of fatal unexpected error. Please return this file,                                               
the query or program that produced the bugcheck, the database and                                                
the error log, and any other pertinent information with a Service Request.                                       
                                                                                                                 
                                                                                                                 
Computer type is AT/AT COMPATIBLE.                                                                               
Bios Version is HP     - 6040000                                                                                 
Ver 1.00PARTTBL                                                                                                  
Current time is 06:28:52 12/25/09.                                                                               
2 Intel x86 level 6, 2333 Mhz processor (s).                                                                     
Windows NT 5.2 Build 3790 CSD Service Pack 2.                                                                    
                                     
Memory                               
MemoryLoad = 41%                     
Total Physical = 3965 MB             
Available Physical = 2324 MB         
Total Page File = 5338 MB            
Available Page File = 3663 MB        
Total Virtual = 2047 MB              
Available Virtual = 534 MB           

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
                                                   
Begin transaction log dump for database 'BEDB'; for Index maintenance - filter on ObjId.
                       
                   Current LSN = 000001b5:00000128:000e                                                          
                     Operation = LOP_MODIFY_COLUMNS                                                              
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 144                                                                             
                  Previous LSN = 000001b5:00000128:000d                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 5                                                                               
             Previous Page LSN = 000001b5:00000128:000b                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:357;ACQUIRE_LOC
K_X KEY: 5:323783533133824 (ed005f07e8f8)                                                                        
                   Description =                                                                                 
                    Log Record = 00003e00b5010000280100000d0002001c7d00000000060265010000010005007aba7a26b5010000
280100000b00010000007aba7a26010000000000000008000800040008001a000200020004000400580058005c005c000200040016ed03000
00100000101000c00007aba7a260000010200040204000aed005f07e8f81a00eb03020000000400ffffffff00000000                  
                                                                                                                 
                   Current LSN = 000001b5:00000128:000d                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:000c                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 4                                                                               
             Previous Page LSN = 000001b5:00000128:000c                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (ec004979c51a)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b5010000280100000c0002001c7d0000000002036b010000010004007aba7a26b5010000
280100000c00040000007aba7a2604000000030000000300100000001a000200160000000000000000ec0300000300f80101000c00007aba7
a260000010200040204000aec004979c51a0100                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:000c                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 112                                                                             
                  Previous LSN = 000001b5:00000128:000b                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 10                                                                              
             Previous Page LSN = 000001b5:00000128:000a                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (d701aeb820ba)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b5010000280100000b0002001c7d0000000003136b01000001000a007aba7a26b5010000
280100000a00040000007aba7a260400010001000000020010001a0016eb03000000000000ec0300000300f80101000c00007aba7a2600000
10200040204000ad701aeb820ba0400                                                                                  
                                                                                                                 
                   Current LSN = 000001b5:00000128:000b                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:000a                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 4                                                                               
             Previous Page LSN = 000001b5:00000128:0008                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:357;ACQUIRE_LOC
K_X KEY: 5:323783533133824 (ec003a605440)                                                                        
                   Description =                                                                                 
                    Log Record = 00003e00b5010000280100000a0002001c7d00000000040265010000010004007aba7a26b5010000
280100000800010000007aba7a26010058000200000004000200020008001a00eb0300000000040216ec0300000100000101000c00007aba7
a260000010200040204000aec003a6054400200                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:000a                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0009                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 2                                                                               
             Previous Page LSN = 000001b5:00000128:0009                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (ea009526ae3f)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000090002001c7d0000000002036b010000010002007aba7a26b5010000
280100000900040000007aba7a2604000000030000000300100000001a000200160000000000000000ea0300000300f80101000c00007aba7
a260000010200040204000aea009526ae3f0100                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:0009                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 112                                                                             
                  Previous LSN = 000001b5:00000128:0008                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 9                                                                               
             Previous Page LSN = 000001b5:00000128:0007                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (d50172e74b9f)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000080002001c7d0000000003136b010000010009007aba7a26b5010000
280100000700040000007aba7a260400010001000000020010001a0016eb03000000000000ea0300000300f80101000c00007aba7a2600000
10200040204000ad50172e74b9f0400                                                                                  
                                                                                                                 
                   Current LSN = 000001b5:00000128:0008                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0007                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 2                                                                               
             Previous Page LSN = 000001b5:00000128:0005                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:357;ACQUIRE_LOC
K_X KEY: 5:323783533133824 (ea00e63f3f65)                                                                        
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000070002001c7d00000000040265010000010002007aba7a26b5010000
280100000500010000007aba7a26010058000200000004000200020008001a00eb0300000000040216ea0300000100000101000c00007aba7
a260000010200040204000aea00e63f3f650200                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:0007                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0006                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 1                                                                               
             Previous Page LSN = 000001b5:00000128:0006                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (e9007b891b2d)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000060002001c7d0000000002036b010000010001007aba7a26b5010000
280100000600040000007aba7a2604000000030000000300100000001a000200160000000000000000e90300000300f80101000c00007aba7
a260000010200040204000ae9007b891b2d0100                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:0006                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 112                                                                             
                  Previous LSN = 000001b5:00000128:0005                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 8                                                                               
             Previous Page LSN = 000001b5:00000128:0004                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (d4019c48fe8d)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000050002001c7d0000000003136b010000010008007aba7a26b5010000
280100000400040000007aba7a260400010001000000020010001a0016eb03000000000000e90300000300f80101000c00007aba7a2600000
10200040204000ad4019c48fe8d0400                                                                                  
                                                                                                                 
                   Current LSN = 000001b5:00000128:0005                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0004                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 1                                                                               
             Previous Page LSN = 000001b5:00000128:0002                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:357;ACQUIRE_LOC
K_X KEY: 5:323783533133824 (e90008908a77)                                                                        
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000040002001c7d00000000040265010000010001007aba7a26b5010000
280100000200010000007aba7a26010058000200000004000200020008001a00eb0300000000040216e90300000100000101000c00007aba7
a260000010200040204000ae90008908a770200                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:0004                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0003                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 0                                                                               
             Previous Page LSN = 000001b5:00000128:0003                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (e8001eeea795)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000030002001c7d0000000002036b010000010000007aba7a26b5010000
280100000300040000007aba7a2604000000030000000300100000001a000200160000000000000000e80300000300f80101000c00007aba7
a260000010200040204000ae8001eeea7950100                                                                          
                                                                                                                 
                   Current LSN = 000001b5:00000128:0003                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 112                                                                             
                  Previous LSN = 000001b5:00000128:0002                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 7                                                                               
             Previous Page LSN = 000001b5:0000011b:0037                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:363;ACQUIRE_LOC
K_X KEY: 5:1168208463265792 (d301f92f4235)                                                                       
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000020002001c7d0000000003136b010000010007007aba7a26b5010000
1b0100003700040000007aba7a260400010001000000020010001a0016eb03000000000000e80300000300f80101000c00007aba7a2600000
10200040204000ad301f92f42350200                                                                                  
                                                                                                                 
                   Current LSN = 000001b5:00000128:0002                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d1c                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 116                                                                             
                  Previous LSN = 000001b5:00000128:0001                                                          
                     Flag Bits = 0200                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 0                                                                               
             Previous Page LSN = 000001b5:0000011b:0038                                                          
               Number of Locks = 3                                                                               
              Lock Information = ACQUIRE_LOCK_IX OBJECT: 5:645577338:0 ;ACQUIRE_LOCK_IX PAGE: 5:1:357;ACQUIRE_LOC
K_X KEY: 5:323783533133824 (e8006df736cf)                                                                        
                   Description =                                                                                 
                    Log Record = 00003e00b501000028010000010002001c7d00000000040265010000010000007aba7a26b5010000
1b0100003800010000007aba7a26010058000200000004000200020008001a00eb0300000000000016e80300000100000101000c00007aba7
a260000010200040204000ae8006df736cf7b00                                                                          
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0038                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 76                                                                              
                  Previous LSN = 000001b5:0000011b:001e                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 0                                                                               
             Previous Page LSN = 000001b5:0000011b:0035                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b0100001e000300197d00000000040265010000010000007aba7a26b5010000
1b0100003500010000007aba7a26010058000200000004000000020000000000eb033000                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0037                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 88                                                                              
                  Previous LSN = 000001b5:0000011b:001f                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 7                                                                               
             Previous Page LSN = 000001b5:0000011b:0036                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b0100001f000300197d0000000002036b010000010007007aba7a26b5010000
1b0100003600040000007aba7a2604000000020000000300100000000000000016eb03000000000000e80300000300f8                 
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0036                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 68                                                                              
                  Previous LSN = 000001b5:0000011b:0020                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 0                                                                               
             Previous Page LSN = 000001b5:0000011b:0034                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000020000300197d0000000003136b010000010000007aba7a26b5010000
1b0100003400040000007aba7a260400010000000000020000000000                                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0035                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 76                                                                              
                  Previous LSN = 000001b5:0000011b:0021                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 1                                                                               
             Previous Page LSN = 000001b5:0000011b:0032                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000021000300197d00000000040265010000010001007aba7a26b5010000
1b0100003200010000007aba7a26010058000200000004000000020000000000eb030400                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0034                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 88                                                                              
                  Previous LSN = 000001b5:0000011b:0022                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 8                                                                               
             Previous Page LSN = 000001b5:0000011b:0033                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000022000300197d0000000002036b010000010008007aba7a26b5010000
1b0100003300040000007aba7a2604000000020000000300100000000000000016eb03000000000000e90300000300f8                 
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0033                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 68                                                                              
                  Previous LSN = 000001b5:0000011b:0023                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 1                                                                               
             Previous Page LSN = 000001b5:0000011b:0031                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000023000300197d0000000003136b010000010001007aba7a26b5010000
1b0100003100040000007aba7a260400010000000000020000000000                                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0032                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 76                                                                              
                  Previous LSN = 000001b5:0000011b:0024                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 2                                                                               
             Previous Page LSN = 000001b5:0000011b:002f                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000024000300197d00000000040265010000010002007aba7a26b5010000
1b0100002f00010000007aba7a26010058000200000004000000020000000000eb030400                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0031                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 88                                                                              
                  Previous LSN = 000001b5:0000011b:0025                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 9                                                                               
             Previous Page LSN = 000001b5:0000011b:0030                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000025000300197d0000000002036b010000010009007aba7a26b5010000
1b0100003000040000007aba7a2604000000020000000300100000000000000016eb03000000000000ea0300000300f8                 
                                                                                                                 
                   Current LSN = 000001b5:0000011b:0030                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 68                                                                              
                  Previous LSN = 000001b5:0000011b:0026                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 2                                                                               
             Previous Page LSN = 000001b5:0000011b:002e                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000026000300197d0000000003136b010000010002007aba7a26b5010000
1b0100002e00040000007aba7a260400010000000000020000000000                                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:002f                                                          
                     Operation = LOP_MODIFY_ROW                                                                  
                       Context = LCX_CLUSTERED                                                                   
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 76                                                                              
                  Previous LSN = 000001b5:0000011b:0027                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 323783533133824                                                                 
                 AllocUnitName = dbo.Media.Media_PKEY                                                            
                       Page ID = 0001:00000165                                                                   
                       Slot ID = 4                                                                               
             Previous Page LSN = 000001b5:0000011b:002c                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000027000300197d00000000040265010000010004007aba7a26b5010000
1b0100002c00010000007aba7a26010058000200000004000000020000000000eb030400                                         
                                                                                                                 
                   Current LSN = 000001b5:0000011b:002e                                                          
                     Operation = LOP_INSERT_ROWS                                                                 
                       Context = LCX_INDEX_LEAF                                                                  
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 88                                                                              
                  Previous LSN = 000001b5:0000011b:0028                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 10                                                                              
             Previous Page LSN = 000001b5:0000011b:002d                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000028000300197d0000000002036b01000001000a007aba7a26b5010000
1b0100002d00040000007aba7a2604000000020000000300100000000000000016eb03000000000000ec0300000300f8                 
                                                                                                                 
                   Current LSN = 000001b5:0000011b:002d                                                          
                     Operation = LOP_DELETE_ROWS                                                                 
                       Context = LCX_MARK_AS_GHOST                                                               
                Transaction ID = 0000:00007d19                                                                   
                      Tag Bits = 0000                                                                            
       Log Record Fixed Length = 62                                                                              
             Log Record Length = 68                                                                              
                  Previous LSN = 000001b5:0000011b:0029                                                          
                     Flag Bits = 0300                                                                            
                   AllocUnitId = 1168208463265792                                                                
                 AllocUnitName = dbo.Media.Media_Location_INDEX                                                  
                       Page ID = 0001:0000016b                                                                   
                       Slot ID = 4                                                                               
             Previous Page LSN = 000001b5:0000011b:002a                                                          
               Number of Locks = 0                                                                               
              Lock Information =                                                                                 
                   Description = COMPENSATION                                                                    
                    Log Record = 00003e00b50100001b01000029000300197d0000000003136b010000010004007aba7a26b5010000
1b0100002a00040000007aba7a260400010000000000020000000000

Open in new window

0
 
LVL 13

Accepted Solution

by:
geek_vj earned 2000 total points
ID: 26157001
The error messages are similar but for you, the database is BEDB. As such, you need to run the following commands to check and fix for any errors:

Use BEDB
Go
sp_dboption 'BEDB', 'single_user', 'true'
GO
DBCC CHECKDB('BEDB', REPAIR_REBUILD)
go
sp_dboption 'BEDB', 'single_user', 'false'

Also, the stack dumps are usually created when there is an issue with database. So the above commands should work for you. Please try and revert in case of any queries.
0
 

Author Comment

by:itorana
ID: 26157099
Thank you geek_vj for the quick reply!

I have run this script first:

DECLARE  tempcursor
CURSOR
READ_ONLY
FOR
      select spid From master..sysprocesses
      where dbid = (select database_id from sys.databases where name = 'BEDB')

DECLARE @name int
OPEN tempcursor

FETCH NEXT FROM tempcursor INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
      exec('kill ' + @name)

      FETCH NEXT FROM tempcursor INTO @name
END

CLOSE tempcursor
DEALLOCATE tempcursor

This one was successful.

Next I ran the script you sent, but received a number of errors:

Msg 5070, Level 16, State 2, Line 1
Database state cannot be changed while other users are using the database 'BEDB'
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
sp_dboption command failed.
Msg 7919, Level 16, State 3, Line 1
Repair statement not processed. Database needs to be in single user mode.

which is just like the one here
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23359245.html

any thoughts?
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 26158167
Hmmm..you need to keep the database in single user mode before running the above repair option:

First, try running this:

alter database BEDB set single_user with rollback immediate

After running this, execute the above repair query in the same query window as above.
0
 

Author Comment

by:itorana
ID: 26159507
Hi geek_vj,

I changed the database mode to single user manually (through SQL Server Management Studio Express, RMB on faulty database, Properties > Options > Restrict Access changed from Multi_User to Single_User).

I was able to run the script with no problems after that. I also made sure to revert changes Multi_User.
Worked fine from then on.

Thanks a lot for your help!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question