How can we help you today? How can we help you today?
siebke
Activity overview Badges (0) Posts (1) Comments (10)

Activity overview

Latest activity by siebke

Any ideas? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Any ideas?
0 votes
I'd run the tests again but each time it fails on the same point. Only if i reboor the server en run it before i yry to make an backup it runs okay. I've checked and tried the issues in the technet article but whitout any luck. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
I'd run the tests again but each time it fails on the same point. Only if i reboor the server en run it before i yry to make an backup it runs okay. I've checked and tried the issues in the technet...
0 votes
Hi, I’ve just tested with the new version off the tool. I’d also rebooted the server before running it to make sure that nothings else was hanging or running. Below the results of the test. I’d also tried to make another backup to test if it was still going wrong, this failed again. The strange thing that happened when I tried to run the test again after I tried to make a backup this test failed with error 1450. Results before backup: Creating buffered test file on network drive File created. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block written. Writing block (3145728) Block written. Writing block (4194304) Block written. Comparing file size File size is consistent. Creating non-buffered test file on network drive File created. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block written. Writing block (3145728) Block written. Writing block (4194304) Block written. Comparing file size File size is consistent. Results after backup: Creating buffered test file on network drive File created. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block written. Writing block (3145728) Block written. Writing block (4194304) Block write failed. BytesWritten: -1 Error 1450: Insufficient system resources exist to complete the requested service Comparing file size File size is consistent. Creating non-buffered test file on network drive File created. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block written. Writing block (3145728) Block written. Writing block (4194304) Block write failed. BytesWritten: -1 Error 1450: Insufficient system resources exist to complete the requested service Comparing file size File size is consistent. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Hi, I’ve just tested with the new version off the tool. I’d also rebooted the server before running it to make sure that nothings else was hanging or running. Below the results of the test. Iâ€...
0 votes
The output of the Start Test: I’m not familiar with this tool but the output I don’t understand. Block write failed en after that The operation completed successfully? Creating buffered test file on network drive File created. Writing block (512) Block written. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Writing block (3145728) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Writing block (4194304) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Comparing file size File size is consistent. Creating non-buffered test file on network drive File created. Writing block (512) Block written. Writing block (1024) Block written. Writing block (1048576) Block written. Writing block (2097152) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Writing block (3145728) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Writing block (4194304) Block write failed. BytesWritten: -1 Error 0: The operation completed successfully Comparing file size File size is consistent. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
The output of the Start Test: I’m not familiar with this tool but the output I don’t understand. Block write failed en after that The operation completed successfully? Creating buffered test fi...
0 votes
It appears immediately after i issue the command. (Just a few seconds.) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
It appears immediately after i issue the command. (Just a few seconds.)
0 votes
Sorry missed that question before. :oops: Indeed 1024 bytes. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Sorry missed that question before. :oops: Indeed 1024 bytes.
0 votes
Indeed the backup fails also on a single large database. I already tried to backup to another share also another server etc. but the errors remain the same. We’re using MS Windows 2003 Enterprise Edition with SP1 and latest patches, MS SQL Server 2000 Enterprise Edition with Service Pack 3a. I just tested with a database size of 4,5 GB and these are the errors. The SQL Logfile indicates an space error on the disk, but this can’t be the problem because there is plenty of free space. SQL Logfile: 2006-01-31 10:47:20.29 spid57 BackupMedium::ReportIoError: write failure on backup device 'SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236'. Operating system error 112(There is not enough space on the disk.). 2006-01-31 10:47:20.31 spid57 Internal I/O request 0x00D49108: Op: Write, pBuffer: 0x0B0F0000, Size: 1048576, Position: 16973824, UMS: Internal: 0x0, InternalHigh: 0x100000, Offset: 0x1000000, OffsetHigh: 0x0, m_buf: 0x0B0F0000, m_len: 1048576, m_actualBytes: 1048576, m_errcode: 112, BackupFile: SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 2006-01-31 10:47:20.31 backup BACKUP failed to complete the command sp_executesql;1 2006-01-31 10:47:20.34 spid57 BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). VDILog: 2006/01/31 10:47:20 pid(1804) tid(3016) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at CVD::GetCommand: AbortDetected 2006/01/31 10:47:20 pid(1308) tid(2160) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at TriggerAbort: invoked 2006/01/31 10:47:20 pid(1804) tid(3016) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at TriggerAbort: invoked 2006/01/31 10:47:20 pid(1308) tid(2160) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at SVDS::CloseDevice: Abort detected 2006/01/31 10:47:20 pid(1308) tid(2160) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at TriggerAbort: invoked 2006/01/31 10:47:20 pid(1308) tid(2932) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at TriggerAbort: invoked 2006/01/31 10:47:20 pid(1804) tid(3400) Error on Global\SQLBACKUP_91ED56C8-854C-4859-9AEA-A0A3FA6F7236 Error at TriggerAbort: invoked / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Indeed the backup fails also on a single large database. I already tried to backup to another share also another server etc. but the errors remain the same. We’re using MS Windows 2003 Enterprise...
0 votes
Yes it’s always the IHDATA_test but this was just an example. Normally we have to backup approximately 31 databases. Almost all are failing. I think it has something to do with the size of the database because a small database (only a few Mb) works okay. Larger databases I think above 1 GB fail. The backup file is created and is always 1Kb large. Manually I receive the exact same error. Any ideas? I was very enthusiast about SQL Backup but I really need to fix this problem because it’s consuming a lot of time. Roger / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Yes it’s always the IHDATA_test but this was just an example. Normally we have to backup approximately 31 databases. Almost all are failing. I think it has something to do with the size of the da...
0 votes
Sorry but that isn't my solution. These things i've already checked. So any ideas? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Sorry but that isn't my solution. These things i've already checked. So any ideas?
0 votes
Indeed these are backups to a network drive. I’ve tested it also on a local drive and this seems to work. But unfortunately I need it to backup tot a network drive because we’re short on disk space locally. Also the log I’ve posted is not the normal backup procedure, this procedure normally includes 32 databases with a total size of 150GB. I tried to use a script but this seems to be the exact same problem. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Some database Backups fail.
Indeed these are backups to a network drive. I’ve tested it also on a local drive and this seems to work. But unfortunately I need it to backup tot a network drive because we’re short on disk s...
0 votes
Total activity
12
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1