March 25, 2008 at 11:26 pm
Hi Guys,
This one has to be addressed for an MVP, I can not find this error anywhere on the web.
Here is the sp info
Index Name Internal_Value Character_Value
------ ------------------------------ -------------- ------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.818
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.0818.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2003 Microsoft Corp. Al
11 LegalTrademarks NULL Microsoft® is a registered tra
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 53608448 NULL
15 WindowsVersion 248381957 5.2 (3790)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 1023 1023 (1073205248)
20 Product ID NULL NULL
Issue:
Client sends and email with this message:
File object
Log file Write error -Microsoft ODBC SQL Server Driver-BACKUP DATABASE permission denied in database Initial error -Export script backup err #1 Microsoft ODBC SQL Server BACKUP DATABASE denied
SQL logs indicate the following:
BACKUP failed to complete the command spx_mkexpbkp;1
BACKUP failed to complete the command spx_mkexpbkp;
(Observation there is a 1 missing at the end of the second entry)
Application Log: (BEFORE ERROR WARNINGS)
Event Type:Warning
Event Source:TimeServ
Event Category:None
Event ID:11
Date:3/25/2008
Time:1:59:47 PM
User:N/A
Computer:WHQWLBMKT2
Description:
The NTP server didn't respond
Event Type:Warning
Event Source:TimeServ
Event Category:None
Event ID:25
Date:3/25/2008
Time:1:59:47 PM
User:N/A
Computer:WHQWLBMKT2
Description:
It has been over 24 hours since we got a network success
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:3/25/2008
Time:5:44:20 PM
User:N/A
Computer:WHQWLBMKT2
Description:
3041 :
BACKUP failed to complete the command spx_mkexpbkp
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 á.......
0008: 0b 00 00 00 57 00 48 00 ....W.H.
0010: 51 00 57 00 4c 00 42 00 Q.W.L.B.
0018: 4d 00 4b 00 54 00 32 00 M.K.T.2.
0020: 00 00 0a 00 00 00 58 00 ......X.
0028: 5f 00 4d 00 4b 00 54 00 _.M.K.T.
0030: 49 00 4d 00 45 00 52 00 I.M.E.R.
0038: 00 00 ..
(AFTER ERROR WARNING AND INFORMATIONAL)
Event Type:Warning
Event Source:Userenv
Event Category:None
Event ID:1524
Date:3/25/2008
Time:6:30:23 PM
User:SUNAMERICA-LA\t70lbmk
Computer:WHQWLBMKT2
Description:
Windows cannot unload your classes registry file - it is still in use by other applications or services. The file will be unloaded when it is no longer in use.
Event Type:Information
Event Source:Userenv
Event Category:None
Event ID:1516
Date:3/25/2008
Time:6:30:25 PM
User:NT AUTHORITY\SYSTEM
Computer:WHQWLBMKT2
Description:
Windows unloaded user S-1-5-21-111897851-1212101582-1542789818-5309_Classes registry when it received a notification that no other applications or services were using the profile.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
:w00t:
Guess: Tape backups running while network gave out?
March 26, 2008 at 3:33 am
Well, it seems like a straight forward 'acces denied' error...
Whatever account that was trying to do a backup got denied.
'spx_mkexpbkp' seems to be some sort of homegrown proc?
As to the reason *why* the command was rejected, well I can only guess.
Networking seems to be somewhat flaky, and it's not uncommon that a failure to authenticate can happen due to broken network.
/Kenneth
March 27, 2008 at 3:27 pm
Kenneth,
You make that sound so easy ! I know it was a denied error but I was curious why these error and warning messages came up and made it seem like more.
Anyhow, your assessment is correct, after involving the app team it has come to my knowledge that we migrated some databases off a msde version off someones desktop, which was managed by the application. Well when they pointed the app server to the new database location their stor procedure was being used to do the backup maintence! That is why it failed since their login has not access, but I could of sworn that I carried those logins over. Anyhow that is the story that fit the piece of the puzzle. Thanks for your feedback your guess was correct, it was a in house store proc and a simple permissionis denied error.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply