Post reply

Move databases between SQL 7 and SQL2000

  • March 31, 2006 at 8:04 am

    #112610

    Hi friends...

    I am moving a lot of databases from SQL7 SP4 To sql2000 SP4. I created a script to do this (with detaching, copying and attaching againt, transfering passwords, logins and so on) but i have a problem with the database maintenance plans. I tried exporting the jobs but is not same, so exist a possiblity to 'export' all the whole plans?

    Thanks for the information.

  • March 31, 2006 at 8:25 am

    #630144

    AFAIK there is no option to move the maintenance plan from one server to another.

     

  • March 31, 2006 at 8:50 am

    #630154

    Why cant you restore the MSDB database on SQL 2000 and see whether it works.  For detach and attaching MSDB database, you will need to go with seperate process like adding a Trace parameter in SQL Server Starup Parameters.  If you move any maintainance job to other server, it wont works, especially the optmization jobs.  You will get an error "SQLMAINT.EXE" failed. So drop those and re create freshly thru DB Maintanance wizards. 

    Thanks,

    Mubeen

  • March 31, 2006 at 8:53 am

    #630158

    Thanks for reply. Now, any advice for after moving the databases? I mean, re-run statistics, re-rebuild indexes, ect?

    Thanks again...

  • March 31, 2006 at 9:14 am

    #630169

    Yes, you need to check current server confiugration setting by using sp_configure and apply any changes to new server and then better you re-build indexes and then update statistics.  Also you need to fix permissions (Orphan users).

    Thanks,

    Mubeen

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply