473,574 Members | 3,133 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Server Backup Failure

nt
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the T-SQL is:

BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'

Note that "local_back up" is a file sitting on the same physical drive
as the database itself, and has > 80 GB free. It is not a RAID device.

The database that I am backing up is 1.6 GB. Oddly, the backup of
another database to the same file was successful; it was ~900 MB.

Even more strangely, I also back these databases up to a network
drive, which has been running successfully for a number of weeks now
(longer than the local backup), and continues to work without any
trouble. The resultant backup file is much larger than the one sitting
on the local drive (6.8 GB on the network drive vs ~4 GB locally) This
network drive has less space (~50 GB) and is configured as RAID 0. It
is a Linux box, using Samba to present the drive to the Windows
network.

Any ideas?? I am completely stumped. Obviously, Microsoft
documentation has been particularly unhelpful.

The excerpt below is taken from the SQL server error log, covering a
couple of attempts.

Any help would be greatly appreciated!!!

Nick Tompson.

2004-07-06 09:56:01.99 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:02.01 spid54 Internal I/O request 0x02672360: Op:
Write, pBuffer: 0x02890000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x02890000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:02.01 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'
2004-07-06 09:56:17.08 spid54 Starting up database
'GPRS_Dimension ing_Archive'.
2004-07-06 09:56:33.11 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:33.11 spid54 Internal I/O request 0x02674360: Op:
Write, pBuffer: 0x028A0000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x028A0000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:33.11 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'
Jul 20 '05 #1
2 13381
nt******@excite .com (nt) wrote in message news:<ba******* *************** ****@posting.go ogle.com>...
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the T-SQL is:

BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'

Note that "local_back up" is a file sitting on the same physical drive
as the database itself, and has > 80 GB free. It is not a RAID device.

The database that I am backing up is 1.6 GB. Oddly, the backup of
another database to the same file was successful; it was ~900 MB.

Even more strangely, I also back these databases up to a network
drive, which has been running successfully for a number of weeks now
(longer than the local backup), and continues to work without any
trouble. The resultant backup file is much larger than the one sitting
on the local drive (6.8 GB on the network drive vs ~4 GB locally) This
network drive has less space (~50 GB) and is configured as RAID 0. It
is a Linux box, using Samba to present the drive to the Windows
network.

Any ideas?? I am completely stumped. Obviously, Microsoft
documentation has been particularly unhelpful.

The excerpt below is taken from the SQL server error log, covering a
couple of attempts.

Any help would be greatly appreciated!!!

Nick Tompson.

2004-07-06 09:56:01.99 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:02.01 spid54 Internal I/O request 0x02672360: Op:
Write, pBuffer: 0x02890000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x02890000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:02.01 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'
2004-07-06 09:56:17.08 spid54 Starting up database
'GPRS_Dimension ing_Archive'.
2004-07-06 09:56:33.11 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:33.11 spid54 Internal I/O request 0x02674360: Op:
Write, pBuffer: 0x028A0000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x028A0000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:33.11 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'


This is a guess, but what is the filesystem of the drive you're
backing up to? You mention that the current backup file is 4GB, and
that's the file size limit on FAT32, so if the backup would result in
a larger file, then it will fail. You also didn't mention your
operating system - if it's Windows 98, then you're stuck with that
limit; if it's Windows 2000, then you can convert your filesystem to
NTFS (which is recommended anyway).

Simon
Jul 20 '05 #2
nt
sq*@hayes.ch (Simon Hayes) wrote in message news:<60******* *************** ****@posting.go ogle.com>...
nt******@excite .com (nt) wrote in message news:<ba******* *************** ****@posting.go ogle.com>...
I am having a problem with a regular backup of an SQL Server (MSDE
2000) database to a local drive. I initiate the backup once a week, by
issuing the required T-SQL, via ADO. In this case, the T-SQL is:

BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'

Note that "local_back up" is a file sitting on the same physical drive
as the database itself, and has > 80 GB free. It is not a RAID device.

The database that I am backing up is 1.6 GB. Oddly, the backup of
another database to the same file was successful; it was ~900 MB.

Even more strangely, I also back these databases up to a network
drive, which has been running successfully for a number of weeks now
(longer than the local backup), and continues to work without any
trouble. The resultant backup file is much larger than the one sitting
on the local drive (6.8 GB on the network drive vs ~4 GB locally) This
network drive has less space (~50 GB) and is configured as RAID 0. It
is a Linux box, using Samba to present the drive to the Windows
network.

Any ideas?? I am completely stumped. Obviously, Microsoft
documentation has been particularly unhelpful.

The excerpt below is taken from the SQL server error log, covering a
couple of attempts.

Any help would be greatly appreciated!!!

Nick Tompson.

2004-07-06 09:56:01.99 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:02.01 spid54 Internal I/O request 0x02672360: Op:
Write, pBuffer: 0x02890000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x02890000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:02.01 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'
2004-07-06 09:56:17.08 spid54 Starting up database
'GPRS_Dimension ing_Archive'.
2004-07-06 09:56:33.11 spid54 BackupMedium::R eportIoError: write
failure on backup device 'C:\Front End\Local Backup\DB_Backu p.bak'.
Operating system error 112(error not found).
2004-07-06 09:56:33.11 spid54 Internal I/O request 0x02674360: Op:
Write, pBuffer: 0x028A0000, Size: 65536, Position: 4294914560, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFF3200, OffsetHigh:
0x0, m_buf: 0x028A0000, m_len: 65536, m_actualBytes: 0, m_errcode:
112, BackupFile: C:\Front End\Local Backup\DB_Backu p.bak
2004-07-06 09:56:33.11 backup BACKUP failed to complete the command
BACKUP DATABASE GPRS_Dimensioni ng_Archive TO local_backup WITH
RETAINDAYS=21, NAME='GDA_20040 706'


This is a guess, but what is the filesystem of the drive you're
backing up to? You mention that the current backup file is 4GB, and
that's the file size limit on FAT32, so if the backup would result in
a larger file, then it will fail. You also didn't mention your
operating system - if it's Windows 98, then you're stuck with that
limit; if it's Windows 2000, then you can convert your filesystem to
NTFS (which is recommended anyway).

Simon


Thanks! You were exactly right. The machine is brand new (P4, Windows
XP). It didn't even occur to me that the file system wouldn't be NTFS.
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
7792
by: tim groulx | last post by:
I have recently started receiving failures on a differential backup that previously succeeded. Nothing has changed with the structure of the db. Here is the message, any ideas are welcomed. Thanks. Executed as user: fsafood-net\bisqlservice. The backup data in 'E:\SQL_Backups\Biz_Sales\Biz_Sales_Diff.bak' is incorrectly formatted. Backups...
1
2106
by: John Rajendran | last post by:
Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the differential BACKUP of the Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to take only the differential BACKUP of the Transaction log...
1
1875
by: Stephanie | last post by:
I have not been able to find any details about backup failures for MSSQL 2000. I am researching the following: 1. when a backup fails at a certain point during the process does the backup: A. stop there having recorded some details? B. quit without backing up any of the data it already processed? C. skip the data it cannot read and move on?...
4
10958
by: Le | last post by:
Our HP representatives are telling us that backing/restoring our MS SQL Servers with "HP Data Protector (HPDP)" is better and safer than using MS Sql's backup/restore process. I have strong hesitations, because MS Sql's processes gives us a great deal of flexability. Has anyone have any experience wsith "HP Data Protector (HPDP)"?
1
3214
by: cat | last post by:
Hi, One of our database delta backup keep failing for about 2 weeks. Is there anyone has the same experience, when DB2 do the delta backup, will it lock recovery history file and how you monitor it? ( db2 get snaphsot for lock ...) Two outstanding err message looks like following 2004-05-10-22.12.33.069471 Instance:ckbinst Node:053...
0
1884
by: joef | last post by:
I'm running VS on my PC (W2K) connected to a remote IIS server (W2K) SP4 that is not a domain controller. I've got the ASPNET and IWAM accounts in the "Impersonate a client after authentication" user rights on the server. I'm in the local admins and debuggers groups. When trying to debug, I'm getting the: Error while trying to run...
1
9326
by: wolphie | last post by:
The IT shop I work in installed MS-SQL Server last week for the sole purpose of converting a large MS-SQL Server database to a format that Informix (our main database engine) can read. MSSQL Server installed perfectly, I can view/manipulate the little "Northwind" sample database, back it up to a file, restore it (Microsoft Tape Format) just...
1
6394
by: David Greenberg | last post by:
Hi My DB backup and transaction backup of a database keep on failing with the following error: Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: Write on 'E:\SqlServer\testdb_db_200604221313.BAK' failed, status = 112. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally. Any idea what it really means...
4
3680
by: fniles | last post by:
I have created a backup maintenance plan in SQL Server 2005. Is there any way to run/execute this SQL Server backup maintenance plan from VB.NET ? Thank you.
0
7841
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7760
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7858
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6511
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5335
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3774
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3793
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2273
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1099
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.