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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2009-11-17 : 16:18:29
|
| We have 2000 Version SQL Server Database server and mainly driven by the maintenance plans to take the backup and transaction logs.Occassionally it fails without any intervention of and once it got REFRESHED several times will be succeeded. However, despite failure it generates backups or transaction logs. I couldn't understand why it fails despite taking any backup, I have even checked the Error log File but there is no evidence as to what went wrong.But We do have 2005 Server and when maintenance plans fails it clearly says the concerned backup or transaction won't perform at all.Can anyone deduce this phenomenon explain to memany thanks to all participated and many time I got the answer from you experts. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2009-11-17 : 20:26:43
|
| Tara, I appreciate your answer but My organisation insisting on the MP's; but there should be a solution within the Maintenance plan. An expert like you, I would expect a better solution, I am requesting.Once again thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-17 : 22:17:42
|
| Have to agree with Tara. We don't allow MPs period. |
|
|
|
|
|
|
Maintenance Plans