Maintenence plan fails to copy some DB's | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Maintenence plan fails to copy some DB’s

Hi,
I’m running a W2K Server with SQL 7.0 SP4.
I have a job which i run every night.
First it worked fine for all DB’s. Recently i recognized that some DB’s where not present in the Backup folder on the server.
I changed the backup location from the remote server share to a local drive but it didn’t help.
I then read on technet that it would be wise to exclude antivirus on the backup folder, so i tried that, but it didn’t help. The strange thing is that the SQL log file will say that the job was a success. See below
[11] Database scalaDB: Database Backup…
Destination: [E:SQLBackupprodDBprodDB_db_200404160300.BAK] ** Execution Time: 0 hrs, 0 mins, 35 secs ** End of maintenance plan ‘DB Maintenance Plan USER DB’ on Fri Apr 16 03:01:04 2004 SQLMAINT.EXE Process Exit Code: 0 (Success) If i do a backup to file manually it works fine.[:0]
I also run backup with Veitas BAckup Exec 9.1 SQL Agent and that works fine. Please help!
Kind Regards Micael
http://support.microsoft.com/default.aspx?scid=kb;en-us;288577 take help from this KBA to troubleshoot db maintenance plans. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi,
The problem is that i don’t get any fails in the report.
It’s says Success on the job, 5 out of 8 DB’s are even backup up fine.
In the job i simply have the backup option activated nothing else. Kind Regards Micael
Create another new plan for each database and see the result. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Already tried that aswell "Sucess"….
I’m currently running a backup of these DB’s manualy to the same disk without any problem.
These DB’s that fail are the largest. The largest is 1,8GB as a BAK file. Does Size matter?? They say so! Haha Kind Regards Micael
Well the size does matter if there are any network or hardware issues on that machine. Its better to divide large databases from other database when performing the backup task, may define individual plan for big database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I Have tried individual plan. Same thing….
The backup to file is on the same machine. I moved it from a remote machine when the problems started.
Could it be the RAID ctrl?? The DB’s are in a raid 1 set, the backup folder is on a raid 5 set.
Starnge if so since it works fine manually. If i right click the DB and choose all tasks, backup it works OK, just did it!!! // Micke Kind Regards Micael
Check event viewer and SQL error logs for any information the Hardware issue.
What was the error from the individual maint.plan log? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>