473,699 Members | 2,734 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 13388
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
7799
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 cannot be appended, but existing backup sets may still be usable. (Error 3266) BACKUP DATABASE is...
1
2112
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 called BACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring the database
1
1877
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? 2. Does the error log record any of the details above? For instance, if there is a table that the...
4
10966
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
3216
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 PID:491936(db2med.498656.0 53) Appid:none
0
1890
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 project: Unable to start debugging on the web server. Catastrophic failure error, and I've seen other...
1
9331
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 fine. But... The MSSQL Server "backup" file they sent me that I need to restore is in a format...
1
6402
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 ? Thanks
4
3687
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
8704
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9187
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9053
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8894
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6540
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4390
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3071
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
2
2360
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2015
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.