02-24-2015 07:18 AM
02-24-2015 10:43 PM
...it states a bunch of SQL DBs are offline. Are you using Advanced Open File Option, and if so, turn it off. Then try the backup again.
Check the TN below for the error in the Event Viewer:
http://www.symantec.com/business/support/index?page=content&id=TECH4955
For the offline SQL DBs, check the TN below:
http://www.symantec.com/business/support/index?page=content&id=TECH206101
Thanks!
02-24-2015 10:53 AM
...you don't put down much additional information, so is this your error?
http://www.symantec.com/docs/TECH190079
Thanks!
02-24-2015 09:49 PM
If you need more informations:
Backup- SDC01.domain.local - AOFO: Initialization failure on: "\\SDC01.domain.local\Shadow?Copy?Components". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS). V-79-10000-11226 - VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) snapshot provider selected returned: "Unexpected provider error". Ensure that all provider services are enabled and can be started. Check the Windows Event Viewer for details. - AOFO: Initialization failure on: "\\SDC01.domain.local\System?State". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS). V-79-10000-11226 - VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) snapshot provider selected returned: "Unexpected provider error". Ensure that all provider services are enabled and can be started. Check the Windows Event Viewer for details.
Backup- SSQL01.domain.local V-79-57344-65085 - There was a problem running the DBCC. Database 'U4Salaris' cannot be opened because it is offline. V-79-57344-65085 - There was a problem running the DBCC. Database 'U4Salaris_cnv' cannot be opened because it is offline. V-79-57344-65085 - There was a problem running the DBCC. Database 'U4Salaris_dca' cannot be opened because it is offline. V-79-57344-65085 - There was a problem running the DBCC. Database 'U4SServices' cannot be opened because it is offline. V-79-57344-65085 - There was a problem running the DBCC. Database 'U4SUpdateDB' cannot be opened because it is offline. V-79-57344-65085 - There was a problem running the DBCC. Database 'VeeamBackup' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database U4Salaris. V-79-65323-942 - Database 'U4Salaris' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database U4Salaris_cnv. V-79-65323-942 - Database 'U4Salaris_cnv' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database U4Salaris_dca. V-79-65323-942 - Database 'U4Salaris_dca' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database U4SServices. V-79-65323-942 - Database 'U4SServices' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database U4SUpdateDB. V-79-65323-942 - Database 'U4SUpdateDB' cannot be opened because it is offline. V-79-65323-942 - An error occurred on a query to database VeeamBackup. V-79-65323-942 - Database 'VeeamBackup' cannot be opened because it is offline.
Verify- \\SSQL03.domain.local\System?State \\SSQL03.domain.local\System?State Unexpected end of backup set encountered on B2D01. V-79-57344-34004 - End of data set was unexpectedly encountered.
Log Name: Application
Source: Backup Exec
Date: 25-2-2015 6:09:09
Event ID: 34113
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: SBCK02.domain.local
Description:
Backup Exec Alert: Job Failed
(Server: "SBCK02") (Job: "SQL-SystemState-Full-databases-Duplicate") SQL-SystemState-Full-databases-Duplicate -- The job failed with the following error: End of data set was unexpectedly encountered.
For more information, click the following link:
http://eventlookup.veritas.com/eventlookup/EventLookup.jhtml
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Backup Exec" />
<EventID Qualifiers="8192">34113</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2015-02-25T05:09:09.000000000Z" />
<EventRecordID>244882</EventRecordID>
<Channel>Application</Channel>
<Computer>SBCK02.domain.local</Computer>
<Security />
</System>
<EventData>
<Data>Backup Exec Alert: Job Failed
(Server: "SBCK02") (Job: "SQL-SystemState-Full-databases-Duplicate") SQL-SystemState-Full-databases-Duplicate -- The job failed with the following error: End of data set was unexpectedly encountered.
</Data>
</EventData>
</Event>
02-24-2015 10:43 PM
...it states a bunch of SQL DBs are offline. Are you using Advanced Open File Option, and if so, turn it off. Then try the backup again.
Check the TN below for the error in the Event Viewer:
http://www.symantec.com/business/support/index?page=content&id=TECH4955
For the offline SQL DBs, check the TN below:
http://www.symantec.com/business/support/index?page=content&id=TECH206101
Thanks!
02-24-2015 10:48 PM
Thank you. I am going to try it.
02-24-2015 10:51 PM
OK just report back with an update!
03-04-2015 03:10 AM
Everything is OK now. Thank you CraigV. I had offline SQL DB's. Thanks once again for solution.
03-04-2015 03:19 AM
Great stuff, glad to have helped!