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