Error 22029

I am geting the following error entry when backing up the
default user database (there are no other instances of SQL
Server on this server).
This is the entry from the database maintenance log:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
[Microsoft][ODBC SQL Server Driver][SQL Server]Write
on 'W:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\mworld_db_200401132033.BAK' failed,
status = 2. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.
This is the entry from the SQL Server logs:
Internal I/O request 0x45E6EE68: Op: Write, pBuffer:
0x19000000, Size: 983040, Position: 2747668992, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xA3C61A00,
OffsetHigh: 0x0, m_buf: 0x19000000, m_len: 983040,
m_actualBytes: 0, m_errcode: 2, BackupFile: W:\Program
Files\Microsoft SQL
Server\MSSQL\BACKUP\mworld_db_200401132033.BAK
Checking ServRAID Manager on this IBM server indicates all
controllers, arrays, and drives are working properly.
Any ideas would be helpful.
Thank you.Somebody from MS can make a better sense of the error codes, but have you
run a DBCC CHECKDB on this database, to see if it reports any corruption?
Have a look in the MSKB to see if there are any articles on this error.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"jdhawk" <anonymous@.discussions.microsoft.com> wrote in message
news:053401c3da56$a6908e80$a601280a@.phx.gbl...
I am geting the following error entry when backing up the
default user database (there are no other instances of SQL
Server on this server).
This is the entry from the database maintenance log:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
[Microsoft][ODBC SQL Server Driver][SQL Server]Write
on 'W:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\mworld_db_200401132033.BAK' failed,
status = 2. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
DATABASE is terminating abnormally.
This is the entry from the SQL Server logs:
Internal I/O request 0x45E6EE68: Op: Write, pBuffer:
0x19000000, Size: 983040, Position: 2747668992, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xA3C61A00,
OffsetHigh: 0x0, m_buf: 0x19000000, m_len: 983040,
m_actualBytes: 0, m_errcode: 2, BackupFile: W:\Program
Files\Microsoft SQL
Server\MSSQL\BACKUP\mworld_db_200401132033.BAK
Checking ServRAID Manager on this IBM server indicates all
controllers, arrays, and drives are working properly.
Any ideas would be helpful.
Thank you.|||I expect this could also be a network error...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"jdhawk" <anonymous@.discussions.microsoft.com> wrote in message
news:053401c3da56$a6908e80$a601280a@.phx.gbl...
> I am geting the following error entry when backing up the
> default user database (there are no other instances of SQL
> Server on this server).
> This is the entry from the database maintenance log:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Write
> on 'W:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\mworld_db_200401132033.BAK' failed,
> status = 2. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP
> DATABASE is terminating abnormally.
> This is the entry from the SQL Server logs:
> Internal I/O request 0x45E6EE68: Op: Write, pBuffer:
> 0x19000000, Size: 983040, Position: 2747668992, UMS:
> Internal: 0x103, InternalHigh: 0x0, Offset: 0xA3C61A00,
> OffsetHigh: 0x0, m_buf: 0x19000000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 2, BackupFile: W:\Program
> Files\Microsoft SQL
> Server\MSSQL\BACKUP\mworld_db_200401132033.BAK
> Checking ServRAID Manager on this IBM server indicates all
> controllers, arrays, and drives are working properly.
> Any ideas would be helpful.
> Thank you.
>