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-09-16 : 05:06:57
|
| Just a quick question and some advice really.I currently have two sql instances which backup the main databases overnight but at the same time of 9pm - the backups are saved to the same drive but in seperate folders.However one of the two instances overnight jobs is constantly failing, my question is because they are starting at the same time would this affect anything despite them being two seperate windows and sql servers.--------------------------SQL Server MCP & MCTS |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-16 : 05:50:56
|
| What error do you get on the failed job? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-16 : 05:53:51
|
| No, what does SQL Agent give you as an error message? What do the error logs themselves (under SQL Agent) tell you about the failure (Is there an error code etc)? |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-09-16 : 06:32:51
|
Thanks guys for the answers, i'll do some more investigation into the error messsagesjust thought i'd ask the question to double check, as I was also under the impression that running two jobs at the same time didn't cause any undue affect on each other.Thanks for you time though  --------------------------SQL Server MCP & MCTS |
|
|
|
|
|
|
SQL Agent Job Time