January 13, 2004 at 10:29 pm
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.
January 14, 2004 at 7:41 am
Do you have enough space in the drive for your backup?
Check server application/system logs for related information during that time windows.
January 14, 2004 at 7:52 am
Another possibility is that the account that runs the SQL Server process has no write permissions on that directory.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply