• I am Trying to Up load my Document,but I did not find any upload option so that I copy pasted Checklist what prepared.

    Check list moving Databases between the Servers.

    * DS Destination Server,

    * SS Source Server.

    S.NOTask

    1.Verify the SS and DS Servers OS versions, Version of DS must to be match or Must be higher level Version then SS

    2.Verify the SS and DS Servers SP Versions, Version of DS must to be match equal or Must be higher level Version then SS.

    3.Verify the SS and DS Servers SQL Server versions, Version of the DS must to be match equal

    4.Verify the SS and DS for SQL Server 2000 SP versions, SP Version of the DS must to be match or Higher then SS.

    5.Make and Verify a Networking shared drive which is accessible from both DS and SS and allocate sufficient space in Network Drive.

    6.Verify the Space in DS and Storage Space should higher then SS

    7.Move the master database Data file, Log file and Store in Network Drive.

    8.Move the master database Data file, Log file and Store in Network Drive.

    **9.Attach the Master database in SS

    **10.Attach the MSDB database in SS

    11.Move the alert ,Jobs, alert and Operator to SS

    **12.Move the DTS packages from DS to SS using DTS Export.

    13.Move all Scripts.

    14.Backup User Databases and Store in Network Drive,

    15.Restore UDB’s in to SS

    16.Verify the Logins

    ** 9 & 10. Moving master, msdb Database is some how Critical Job, It is better to move data files and Log files using Detach and Attach method.

    ** 12. Move the all DTS Package to DS, but make sure that the path must same with SS