Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-10-27 : 06:49:56
|
| Just after some general advice from you guys really, I have a maintenance plan that at current backups up two small databases and then one large database about 30 gig.after creation I notice that the job was failing so move the time of execution to a period where there is no network traffic which can interfere with the bakcup proccess.This proved successful for about two months Hoever now i'm starting to get the same error saying that it's terminating abnormallyBut after it finished upto 100% complete.I was wondering if its better to seperate this larger database out onto its own plan in order to stop this problemAny ideas.-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-10-28 : 05:07:22
|
| Hi Tara, It always comes back with the same error like below.Execute SQL Task Description: Executing the query "BACKUP DATABASE [CRM_MSCRM] TO DISK = N'\\BACKUP\DB01\CRM_MSCRM_backup_200910280400.bak' WITH NOFORMAT, NOINIT, NAME = N'CRM_MSCRM_backup_20091028040007', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "A nonrecoverable I/O error occurred on file "\\BACKUP... The package execution fa... The step failed.I find it strange as i've created a secondary job which backups up just the larger database, this runs at the same time as the maintenance jobs however this job never fails.Would I be better off seperating the database backups out into seperate jobs? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-10-29 : 10:25:31
|
| Thanks that will be extremely helpful |
|
|
|
|
|
|
Database Maintenance Plans