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.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
--
www.synecology.comIf 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.BAK' 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...
> >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.BAK' WITH INIT ,
> > NOUNLOAD
> > , NOSKIP , STATS = 10, NOFORMAT
> > --
> > www.synecology.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...
> 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...
>> >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.BAK' WITH INIT ,
>> > NOUNLOAD
>> > , NOSKIP , STATS = 10, NOFORMAT
>> > --
>> > www.synecology.com
>>|||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...
> > 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...
> >> >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.BAK' WITH INIT ,
> >> > NOUNLOAD
> >> > , NOSKIP , STATS = 10, NOFORMAT
> >> > --
> >> > www.synecology.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...
>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...
>> > 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...
>> >> >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.BAK' WITH INIT ,
>> >> > NOUNLOAD
>> >> > , NOSKIP , STATS = 10, NOFORMAT
>> >> > --
>> >> > www.synecology.com
>> >>
>> >>
>> >>
>>