Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-12 : 07:54:28
|
| Santhosh writes "I am backing up a 115 GB SQL Database.I am using a backup software for doing the same.The backup fails after backing up 50+ GB.The SQL ERRORLOG says:2004-02-10 08:53:58.70 spid71 BackupMedium::ReportIoError: write failure on backup device 'DBASQL_DB_eTRAX_PID2624TID304BID0TS935002015VD0'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).2004-02-10 08:53:58.70 spid71 Internal I/O request 0x49B9D618: Op: Write, pBuffer: 0x173E0000, Size: 2097152, Position: 61548396544, UMS: Internal: 0x0, InternalHigh: 0x200000, Offset: 0x6AED0000, OffsetHigh: 0xE, m_buf: 0x173E0000, m_len: 2097152, m_actualBytes: 0, m_errcode: 995, BackupFile: DBASQL_DB_eTRAX_PID2624TID304BID0TS935002015VD02004-02-10 08:53:58.70 backup BACKUP failed to complete the command backup database [eTRAX] to virtual_device = 'DBASQL_DB_eTRAX_PID2624TID304BID0TS935002015VD0' WITH BLOCKSIZE=65536, BUFFERCOUNT=1, MAXTRANSFERSIZE=2097152 2004-02-10 08:53:58.72 spid71 BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'DBASQL_DB_eTRAX_PID2624TID304BID0TS935002015VD0'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).The VDI Log says2004/02/10 08:53:58 pid(1304) tid(2116)Error on DBASQL_DB_eTRAX_PID2624TID304BID0TS935002015VD0Error at SVDS::ExecuteCompletionAgent: Waitfailed Status Code: -1, xFFFFFFFFPlease adviseSanthosh" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-02-12 : 08:06:55
|
| 115 GB sounds like a lot...are you sure this isn't bigger than the maximum capacity of the media? You should really invest in something like this: http://www.dbassociatesit.com/OS |
 |
|
|
|
|
|
|
|
SQL Backup