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 : 04:06:56
|
| Help needed with Issue's related to side by side migration of SQL Server 7 to SQL Server 2005 |
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-10 : 04:16:01
|
| Migrated the jobs in the SQL Server 7.0 to SQL Server 2005 including the maintenance jobs using the SQL script..... but when i try to execute the job i get this error ::please help ....Sql Severity 16Sql Message ID 22029Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 00:46:02
|
| How did you move maintenance plans over? I didn't find way for that yet although works with direct upgrade. |
|
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-08-13 : 02:50:27
|
| I think maintenance plans can be created using the maintenance plan wizard in the new server(in my case SQL Server 2005), refering to the maintenace plan of ur old server (in my case SQL Server 7)...But the only doubt i whether the maintenance jobs really need to be migrated from SQL Serber 7.0 orwill it be taken care of itself by the new server .... as i know that whenever a plan is created a job is also created automatically corresponding to it ......if anyone knows better please clarify .....it will be a great help .... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 15:31:31
|
| That's the point, can't just copy over maintenance jobs. |
|
|
|
|
|
|
MIGRATION OF MSSQL SERVER 7 TO MSMSQL SERVER 2005