• i have to migrate from Sql 2005 to Sql 2005..(Only 2 databases)

    1) I will take a backup of two databases & then copy the backup file to new serevr

    2) I will restore them to the new server.

    3) Will Migrate Login using Login & Password Script.

    4) Will schedule all maintenecae jobs which was existing on old server.

    5) Will ask developer to point all application to the New database & will confirm it works.

    Else what i have to do ???

    Do i need to Change compatibility mode???

    Please reply soon.. i need to impelment this in 1 hour :w00t:

    ************************************
    Every Dog has a Tail !!!!! :-D