Failed Backup Error Message SQL 2000

I continually receive the following error when trying to backup the one
database.
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =
N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.B AK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
www.synecology.com
If you check the SQL server error log you should see a message just before
this one that should have some further detail on why it is failing. If you
run it through QA do you get additional error messages ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>I continually receive the following error when trying to backup the one
> database.
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =
> N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.B AK' WITH INIT ,
> NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
> --
> www.synecology.com
|||Here is the previous error message:
SPID 55
Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
m_actualBytes: 0, m_errcode: 112, BackupFile:
L:\SQLDatabaseBackups\Data_db_200501090201.BAK
There was a space issue, but that has been resolved.
"Jasper Smith" wrote:

> If you check the SQL server error log you should see a message just before
> this one that should have some further detail on why it is failing. If you
> run it through QA do you get additional error messages ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>
>
|||And you see the same errors when running it through Query Analyzer? Is it
possible to try writing the backup to a different drive just to see if that
has any effect?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...[vbcol=seagreen]
> Here is the previous error message:
> SPID 55
> Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 112, BackupFile:
> L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> There was a space issue, but that has been resolved.
> "Jasper Smith" wrote:
|||I just ran the backup after cleaning up the 2 drives that had space issues.
and received no errors.
Is it possible that the failed backup could change the database to single
user mode?
"Jasper Smith" wrote:

> And you see the same errors when running it through Query Analyzer? Is it
> possible to try writing the backup to a different drive just to see if that
> has any effect?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
>
>
|||A backup failure should have no effect on the recovery model of the
database. However, maintenance plans did in the past have a habit of leaving
databases in single user mode if you had the "Attempt to repair minor
problems" option selected although I believe this should be fixed by now in
one of the service packs
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:A03F1658-EDFF-4DE3-8653-65AAE6EEF38B@.microsoft.com...[vbcol=seagreen]
>I just ran the backup after cleaning up the 2 drives that had space issues.
> and received no errors.
> Is it possible that the failed backup could change the database to single
> user mode?
>
> "Jasper Smith" wrote: