Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problems with backup on SQL server Expand / Collapse
Author
Message
Posted Friday, August 22, 2008 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 1:14 PM
Points: 9, Visits: 64
Hi all SQL brainers.
Im starting to receive these errors on my SQL server, when I run my daily FULL backup. I cant seem to find the source of the problem, and I dont know if its the SQL server, or my backup agent which is causing the problem. I tried troubleshoot them both, but the backup is still causing theses problems.
Can someone please help me on my way?

Thanks alot!

I receive these 4 kinds of errors


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 21-08-2008
Time: 22:12:01
User: NT AUTHORITY\SYSTEM
Computer: SQL1
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [master] TO VIRTUAL_DEVICE='BE_SQLAgent-master__6df2c99b_f398_44d2_aa55_2b1d4d938e95_' WITH name='Backup Exec SQL Server Agent', SNAPSHOT


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: 05 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 31 00 00 00 07 00 L.1.....
0018: 00 00 6d 00 61 00 73 00 ..m.a.s.
0020: 74 00 65 00 72 00 00 00 t.e.r...


Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Date: 21-08-2008
Time: 22:12:01
User: N/A
Computer: SQL1
Description:
An error occurred while executing the following query: "BACKUP DATABASE [master] TO VIRTUAL_DEVICE='BE_SQLAgent-master__6df2c99b_f398_44d2_aa55_2b1d4d938e95_' WITH name='Backup Exec SQL Server Agent', SNAPSHOT".
On server: "SQL1".
SQL error number: "0C98".
SQL error message: "Cannot create worker thread.
".

For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Data:
0000: 98 0c 00 00 00 00 00 00 ˜.......
0008: 00 00 00 00 00 00 00 00 ........


Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 21-08-2008
Time: 22:12:14
User: N/A
Computer: SQL1
Description:
17120 :
SQL Server could not spawn process_loginread thread.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e0 42 00 00 10 00 00 00 àB......
0008: 05 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 31 00 00 00 00 00 L.1.....
0018: 00 00 ..


Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Date: 21-08-2008
Time: 22:12:23
User: N/A
Computer: SQL1
Description:
An error occurred while executing the following query: "DBCC CHECKDB([CSI2005]) WITH PHYSICAL_ONLY".
On server: "SQL1".
SQL error number: "21C2".
SQL error message: "The query processor could not start the necessary thread resources for parallel query execution.
".

For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Data:
0000: c2 21 00 00 00 00 00 00 Â!......
0008: 00 00 00 00 00 00 00 00 ........
Post #557085
Posted Friday, August 22, 2008 6:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:20 PM
Points: 194, Visits: 334
Looks like some disc related issue to me (May be I am wrong),,
Can you take a full backup manually using TSQL and see what it is doing?
Also do a checkdb and fix errors ASAP and do a scandisc on HDD also.



CDBA
Post #557686
Posted Tuesday, August 26, 2008 12:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 06, 2010 1:37 PM
Points: 259, Visits: 436

From the error messages provided, seems like the server load was too high to create a worker thread. Please check the following and proceed accordingly.

>> Try to run the FULL backup in non peak hours and check if this works.
>> While the backup is running, check to see if they are any parallel high resource intensity jobs\process is running, which is causing this error.
>> This can also be because of the huge concurrently active user connections on the server.
>> Also it could be because of the virtual memory issues. SQL Server may generate these kind of error messages after the whole virtual address space is used up.

Check if the server is facing any of the above situation.

-Rajini
Post #558621
Posted Tuesday, August 26, 2008 12:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 20, 2012 1:14 PM
Points: 9, Visits: 64
Thanks for both of your suggestions. I did run some diagnostics on my server, and backup last night.
My backup is always in nonpeak hours at night, so user load shouldnt be an issue.
The next thing is I did a backup job without the Symantec Open File Option, and It came out allright. SQL server didnt generate any errors.
This is quite strange, because Its been working fine the last couple of months, when it suddenly started with these errors.

Bottom line is I now localized the error, the Symantec Backup Exec 11d Open File Option. An I will therefore continue troubleshooting my problem with symantec.

Thanks for your responses :)
Post #558632
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse