October 3, 2005 at 8:31 am
Hi
Please can you help. I am new to SQL Server. I have installed SQL Server 2000 Service pk 4 on a 2 node cluster with attached SAN disks. I have been running user database backups via maintenance plan successfully. They are now failing intermittently. I have tried running backups to local disk and SAN disk thinking the problems could relate to connectivity. The problem is happening in both areas.
I have also ran the maintainance plan via query analyzer again the same behaviour happens, sometimes if fails, sometimes it works. If I run a backup manually from the command line it works every time.
With the maintenance plan backups .BAK files are usually corrupt or sometimes do not even create. The maintanance plan history for some reason tells me the backups are successful when they are not.
Error log - Complains of operating system error=32 (error not found).
The event log error below
3041: BACKUP fails to complete the command BACKUP DATABASE [usdd004a] TO DISK=N'Z:\MSSQL$GSDQ008A\BACKUP\usdd004a\usdd004a\
usdd004a_db_200510031151.BAK' WITH INIT, NOUNLOAD, NOSKIP, STATS=10, NOFORMAT
Any help appreciated
regards
jp
October 4, 2005 at 11:58 am
Are you using VERIFY ? If you are, try turning VERIFY off in youe maintenance plan. If the failures stop, you are being bitten by an MDAC "bug" - which there is a 'hot fix' for.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 5, 2005 at 1:47 am
thanks Rudy
I have tried the maintanance plan without dbverify option.
I'm seeing some wierd behaviour.
Within Enterprise Manager viewing job and maintanance history the backup looks successful. However there is no backup file in the BACKUP directory.
The error log and event log do report the backup error. And gives me the same error as reported above? 3041:
Looking this up on microsoft support site error 3041 is a
A filemark error in the backup device could not be read.
I have got our engineers to check SAN disks etc. They tell me it looks OK
Problem is that the problem is intermittent sometimes it works, some times it doesn't.
Do you think this is a bug? Does any one have any experience of this sort of behaviour?
thanks
JP
October 6, 2005 at 11:01 am
The only other advice I have is to update your MDAC ... I believe the latest version is something like 2.8 SP2 ... this will require a reboot of the server though ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply