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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-08-16 : 10:17:35
|
| Hi,I moved maintennace plans and related jobs to new sever for sharepoint databases on sql server. I changed connection string to new server in maintenance plan. When I try to start the job manually i.e. update statistics on all user database job failed after some time may be on some database. Job run as sa owner. Maintenance plans are also failing after migration. Any help?Thanks |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-16 : 10:42:48
|
| Any error details?- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulCurrently be a DBA in worldwide hotel reservation. Experienced in top leading banking environment. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-08-16 : 14:49:17
|
| How exactly did you move the maintenance plans? |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-08-17 : 00:22:09
|
| in bids, opened as existing package, changed connection string to new server, saved as copy to new server. |
|
|
|
|
|
|
Jobs failed