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 |
|
freesoul
Starting Member
35 Posts |
 Posted - 2007-08-10 : 09:23:52
|
| I am migrating the SQL server 7 to SQl server 2005 (side by side upgrade).... I copied all the jobs including the maintenance jobs .is that the right way ?do we need to copy the maintenance jobs as well ???or do we have to create the maintenance plan which will create the new jobs itself ????? please Guide ....... its urgent ....thanks in advance !!!!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 01:21:33
|
| Maintenance jobs will not work without plan, need recreate them in this case. |
 |
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-13 : 08:14:19
|
| I was told that the maintenance jobs are created automatically once u create a maintenance plan , so should i delete the maintenance jobs which i have copied from my earlier server....please suggest...many thanks. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 22:32:07
|
| Yes, delete those old jobs then recreate maintenance plan. |
|
|
|
|
|
|
Maintenance Plan and jobs