| Author |
 Topic  |
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
 Posted - 12/29/2005 : 12:25:59
|
I've never had any problems running backup log during the reindex. What error are you getting?
Tara Kizer
aka tduggan |
 |
|
|
dsweeney
Starting Member
3 Posts |
Posted - 12/29/2005 : 12:48:55
|
looking at the logs, it doesn't look like it tried to run.
Logs are set to backup ever 20 min (24x7)
they ran successfully at 02:00:02AM
the reindex starts at 02:00:03AM (took 09:48:16)
the next trans log entry doesn't run until 11:15:20 AM (runs for 30 min then fails)
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on '\\orfs01\sql\tlogs\CommerceCenter_tlog_200512251115.TRN' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.
then runs again at 12:00:03 (for about 30 min again) and fails
the runs successfully at 12:40:02 PM (about an hour) |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 12/29/2005 : 12:58:52
|
Try backing up the tlog to the local disk instead of to a UNC path during the reindex. If it works, then the problem is associated with backing up to a UNC path. The issue would probably be that the database server is being severely taxed and can't get to the UNC path during that time.
Tara Kizer
aka tduggan |
|
|
|
sumitsahay
Starting Member
India
5 Posts |
Posted - 04/25/2006 : 01:19:29
|
Hello Friends
I too got the same error, please help me to find out solution, my error is :
for Maintenance plan----
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'E:\Program Files\Microsoft SQL Server\MSSQL$xxxxxx\BACKUP\xxxxxxxxxx.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
Error log;
Internal I/O request 0x324FCA58: Op: Write, pBuffer: 0x089B0000, Size: 786432, Position: 6656, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x1A00, OffsetHigh: 0x0, m_buf: 0x089B0000, m_len: 786432, m_actualBytes: 0, m_errcode: 112, BackupFile: E:\Program Files\Microsoft SQL Server\MSSQL$xxxxx\BACKUP\xxxxxxxxxxxxxxxx.BAK
BackupMedium::ReportIoError: write failure on backup device 'E:\Program Files\Microsoft SQL Server\MSSQL$xxxxxxxx\BACKUP\xxxxxxxxxxxxxxxxxx.BAK'. Operating system error 112(There is not enough space on the disk.).
Regards,
Sumit
sahay |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 04/25/2006 : 01:35:12
|
"BackupMedium::ReportIoError: write failure on backup device 'E:\Program Files\Microsoft SQL Server\MSSQL$xxxxxxxx\BACKUP\xxxxxxxxxxxxxxxxxx.BAK'. Operating system error 112(There is not enough space on the disk.)"
Is there enough space on the E: drive to hold the backup file?
Kristen |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 04/25/2006 : 01:36:26
|
does the text in red help?
quote:
Originally posted by sumitsahay
Hello Friends
I too got the same error, please help me to find out solution, my error is :
for Maintenance plan----
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'E:\Program Files\Microsoft SQL Server\MSSQL$xxxxxx\BACKUP\xxxxxxxxxx.BAK' failed, status = 112. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
Error log;
Internal I/O request 0x324FCA58: Op: Write, pBuffer: 0x089B0000, Size: 786432, Position: 6656, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x1A00, OffsetHigh: 0x0, m_buf: 0x089B0000, m_len: 786432, m_actualBytes: 0, m_errcode: 112, BackupFile: E:\Program Files\Microsoft SQL Server\MSSQL$xxxxx\BACKUP\xxxxxxxxxxxxxxxx.BAK
BackupMedium::ReportIoError: write failure on backup device 'E:\Program Files\Microsoft SQL Server\MSSQL$xxxxxxxx\BACKUP\xxxxxxxxxxxxxxxxxx.BAK'. Operating system error 112(There is not enough space on the disk.).
Regards,
Sumit
sahay
--------------------
keeping it simple... |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 04/25/2006 : 01:37:27
|
--------------------
keeping it simple... |
|
|
|
Topic |
|
Log Shipping -Shrinking Log and Data files
