SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping -Shrinking Log and Data files
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 12/29/2005 :  12:25:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
I've never had any problems running backup log during the reindex. What error are you getting?

Tara Kizer
aka tduggan
Go to Top of Page

dsweeney
Starting Member

3 Posts

Posted - 12/29/2005 :  12:48:55  Show Profile  Reply with Quote
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)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36949 Posts

Posted - 12/29/2005 :  12:58:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

sumitsahay
Starting Member

India
5 Posts

Posted - 04/25/2006 :  01:19:29  Show Profile  Send sumitsahay a Yahoo! Message  Reply with Quote
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
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 04/25/2006 :  01:35:12  Show Profile  Reply with Quote
"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
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 04/25/2006 :  01:36:26  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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...
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 04/25/2006 :  01:37:27  Show Profile  Send jen a Yahoo! Message  Reply with Quote



--------------------
keeping it simple...
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000