How can we help you today? How can we help you today?
dhtucker
Activity overview Badges (0) Posts (9) Comments (32)

Comments

Sort by recent activity
I'm running in a non-domain environment, so the user account in question is simply part of the Administrators group. The chief DBA at our hosting service (Edgewebhosting in Baltimore, MD) says disabling SNMP isn't an option for us. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
I'm running in a non-domain environment, so the user account in question is simply part of the Administrators group. The chief DBA at our hosting service (Edgewebhosting in Baltimore, MD) says disa...
0 votes
Event data from a crashed service on another server: ================== Log Name: Application Source: Application Error Date: 7/26/2010 1:02:08 PM Event ID: 1000 Task Category: (100) Level: Error Keywords: Classic User: N/A Computer: EWHSERVER801 Description: Faulting application SQBCoreService.exe, version 6.4.0.56, time stamp 0x2a425e19, faulting module inetmib1.dll, version 6.0.6001.18000, time stamp 0x4791a719, exception code 0xc0000005, fault offset 0x00007cc6, process id 0x1024, application start time 0x01cb2ce35322a990. Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"&gt; <System> <Provider Name="Application Error" /> <EventID Qualifiers="0">1000</EventID> <Level>2</Level> <Task>100</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2010-07-26T17:02:08.000Z" /> <EventRecordID>116742</EventRecordID> <Channel>Application</Channel> <Computer>EWHSERVER801</Computer> <Security /> </System> <EventData> <Data>SQBCoreService.exe</Data> <Data>6.4.0.56</Data> <Data>2a425e19</Data> <Data>inetmib1.dll</Data> <Data>6.0.6001.18000</Data> <Data>4791a719</Data> <Data>c0000005</Data> <Data>00007cc6</Data> <Data>1024</Data> <Data>01cb2ce35322a990</Data> </EventData> </Event> ===================== Log Name: Application Source: Application Error Date: 7/26/2010 1:02:12 PM Event ID: 1000 Task Category: (100) Level: Error Keywords: Classic User: N/A Computer: EWHSERVER801 Description: Faulting application SQBCoreService.exe, version 6.4.0.56, time stamp 0x2a425e19, faulting module IPHLPAPI.DLL, version 6.0.6002.18005, time stamp 0x49e037a4, exception code 0xc0000005, fault offset 0x00003540, process id 0x1024, application start time 0x01cb2ce35322a990. Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"&gt; <System> <Provider Name="Application Error" /> <EventID Qualifiers="0">1000</EventID> <Level>2</Level> <Task>100</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2010-07-26T17:02:12.000Z" /> <EventRecordID>116743</EventRecordID> <Channel>Application</Channel> <Computer>EWHSERVER801</Computer> <Security /> </System> <EventData> <Data>SQBCoreService.exe</Data> <Data>6.4.0.56</Data> <Data>2a425e19</Data> <Data>IPHLPAPI.DLL</Data> <Data>6.0.6002.18005</Data> <Data>49e037a4</Data> <Data>c0000005</Data> <Data>00003540</Data> <Data>1024</Data> <Data>01cb2ce35322a990</Data> </EventData> </Event> ================================ / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
Event data from a crashed service on another server: ================== Log Name: Application Source: Application Error Date: 7/26/2010 1:02:08 PM Event ID: 1000 Task Cate...
0 votes
The service did not respond gracefully to the restart request, and wound up hung in the "stopping" state. I killed the process via TaskMgr and restarted the service, and I'll now perform all tests using the 6.3 GUI only. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
The service did not respond gracefully to the restart request, and wound up hung in the "stopping" state. I killed the process via TaskMgr and restarted the service, and I'll now perform all tests...
0 votes
Nothing in the Event log to indicate that the service stopped / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
Nothing in the Event log to indicate that the service stopped
0 votes
The last time this happened, I'm not sure the service crashed at all - there's nothing in the event logs to indicate a crash. It's just that the GUI isn't able to communicate with the service. I just restarted the 6.4 GUI and it reports: SQB service did not acknowledge receipt of data. (WAIT_TIMEOUT I'll download the 6.3 GUI and see if it can connect to the service as-is. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
The last time this happened, I'm not sure the service crashed at all - there's nothing in the event logs to indicate a crash. It's just that the GUI isn't able to communicate with the service. I ...
0 votes
I loaded the 6.3 GUI onto another machine - same as 6.4, it fails to connect to the service that's still running on my server (same error message that 6.4 gives, too). I'll restart the SQL Backup Agent service, and schedule more tests after-hours this evening, using only the 6.3 GUI / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
I loaded the 6.3 GUI onto another machine - same as 6.4, it fails to connect to the service that's still running on my server (same error message that 6.4 gives, too). I'll restart the SQL Backup A...
0 votes
(see event logs below) I set the Recovery Properties on the SQL Backup Agent service to 'Restart the Service' on First failure. Apparently, the service restarted successfully (the scheduled backup job ran without error), but the GUI still reports the server as inoperative (error: SQB service did not acknowledge receipt of data. (WAIT_TIMEOUT). The same condition appears whether the GUI is run on the server itself or when run from a remote administrative console. ============================================== Event Type: Error Event Source: SQLVDI Event Category: None Event ID: 1 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=2220. Thread=8188. Server. Instance=MSSQLSERVER. VD=Global\SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D30_SQLVDIMemoryName_0. ============================================= Event Type: Error Event Source: MSSQLSERVER Event Category: Backup Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupIoRequest::ReportIoError: write failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D3002'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ====================================== Event Type: Error Event Source: MSSQLSERVER Event Category: Backup Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupIoRequest::ReportIoError: write failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D3001'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. =========================================== Event Type: Error Event Source: MSSQLSERVER Event Category: Backup Event ID: 3041 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BACKUP failed to complete the command BACKUP DATABASE RENWEB_DEMO. Check the backup application log for detailed messages. 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: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ======================================= Event Type: Error Event Source: MSSQLSERVER Event Category: Backup Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupIoRequest::ReportIoError: write failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D30'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ======================================== Event Type: Error Event Source: MSSQLSERVER Event Category: Server Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D30'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ========================================== Event Type: Error Event Source: MSSQLSERVER Event Category: Server Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D3002'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ======================================= Event Type: Error Event Source: MSSQLSERVER Event Category: Server Event ID: 18210 Date: 7/25/2010 Time: 8:59:15 PM User: N/A Computer: EWHSERVER708 Description: BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_56266C88-4A05-4617-B0A8-A1DE8B890D3001'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 22 47 00 00 10 00 00 00 "G...... 0008: 0d 00 00 00 45 00 57 00 ....E.W. 0010: 48 00 53 00 45 00 52 00 H.S.E.R. 0018: 56 00 45 00 52 00 37 00 V.E.R.7. 0020: 30 00 38 00 00 00 00 00 0.8..... 0028: 00 00 .. ======================================== / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
(see event logs below) I set the Recovery Properties on the SQL Backup Agent service to 'Restart the Service' on First failure. Apparently, the service restarted successfully (the scheduled backup...
0 votes
I'm seeing the same behavior (my server is running Windows 2003 SP2) I've got it running in -sqbdebug mode in hopes of capturing some helpful diagnostic data. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Backup Service hangs
I'm seeing the same behavior (my server is running Windows 2003 SP2) I've got it running in -sqbdebug mode in hopes of capturing some helpful diagnostic data.
0 votes
I thought maybe it'd stop if I deleted that server from the group. Good news: Yes, that stops a job in progress. Bad news: It also caused SQL Backup I/F to crash (invalid object reference) and the SQL Backup Agent on that server stopped. Not quite the solution I was looking for... :oops: / comments
  1. Community
  2. SQL Backup Previous Versions
  3. abort a job in progress
I thought maybe it'd stop if I deleted that server from the group. Good news: Yes, that stops a job in progress. Bad news: It also caused SQL Backup I/F to crash (invalid object reference) and the ...
0 votes
FYI: I found a work-around that will suffice for at least simple scripts. It relies on the "On Error:" behavior "Stop executing on database with error" option. Using a two script approach, script 1 serves to "pre-qualify" the database. I created a simple pass/fail query: "select count(*) from ConfigDistrict" - that's a table guaranteed to exist in each of the databases I'm looking to reach, and equally guaranteed NOT to exist in any of the databases I don't want to reach. If script 1 fails (i.e. table not found), then script 2 isn't run for that database, but MultiScript forges on to the next database. If script 1 succeeds, then script 2 is invoked for that database. Suitable only for the simplest, single-script tasks, but it's a start. I do still have to build a Distribution List of "all databases on all servers" every time I've got a task to run (since that list is a moving target), but at least it's a fairly swift "select all, Add>" process. :idea: It would still be nice if an upcoming release gave Distribution Lists some kind of selection criteria or filtering option! [image] / comments
  1. Community
  2. SQL Multi Script
  3. Enhancement request - select database(s) by filtering
FYI: I found a work-around that will suffice for at least simple scripts. It relies on the "On Error:" behavior "Stop executing on database with error" option. Using a two script approach, script...
0 votes
Total activity
56
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
15