April 8, 2010 at 6:36 am
My transaction job is failing in production, I get error
Sql Severity16
Sql Message ID3262
Is anyone knows how to fix this asap. Thank you
April 8, 2010 at 6:40 am
In order to get an ASAP help, you will need to give a bit more information.
What does the application do? What are the errors before and after the Error 16 you get?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 8, 2010 at 6:51 am
I got this error from transaction job failing:
Date4/8/2010 5:30:00 AM
LogJob History (SAVVIS Transaction Log Backup)
Step ID1
ServerS602561DC4EW30
Job NameSAVVIS Transaction Log Backup
Step NamePreform a Transaction Log Backup.
Duration00:00:04
Sql Severity16
Sql Message ID3262
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: NT AUTHORITY\SYSTEM. ..., file 'db1_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP LOG successfully processed 0 pages in 0.042 seconds (0.000 MB/sec). [SQLSTATE 01000] (Message 3014) The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262) Processed 0 pages for database 'db2, file 'db2_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP LOG successfully processed 0 pages in 0.035 seconds (0.000 MB/sec). [SQLSTATE 01000] (Message 3014) The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262) Processed 1 pages for database 'db3', file 'db3_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP LOG successfully processed 1 pages in 0.062 seconds (0.132 MB/sec). [SQLSTATE 01000] (Message 3014) The backup set on file 1 is valid. [SQLSTATE 01000] (Message 3262) Processed 0 pages for database 'Co... The step failed.
April 8, 2010 at 7:16 am
You can check the SQL Error Log and Windows Application event log to get more information on why the step is failing
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 8, 2010 at 7:55 am
I found in sql server logs someone ran backup, how can I check who is the user?Thank you
April 8, 2010 at 3:17 pm
If you don't find anything useful in logs then try running the backup command in ssms manually to see if it o/p's any error..
MJ
April 9, 2010 at 9:13 am
Krasavita (4/8/2010)
I found in sql server logs someone ran backup, how can I check who is the user?Thank you
Check for the event to show up in the Window Application Event Log. Should look something similar to:
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:18264
Date:4/9/2010
Time:3:12:37 PM
User:<USER that initiated backup>
Computer:<server>
Description:
<information about the backup>
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply