want to migrate whole configured instance as it is with all databases and jobs and maintenanace plans ans all database mailing prfiles how can i do thata

  • want to migrate whole configured instance as it is with all databases and jobs and maintenanace plans ans all database mailing prfiles how can i do that

  • migrate to what?

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • want to transfer whole instance to a differrent server

  • The short answer is you can do that rather simply. Install SQL on the other server to the exact same level as the server you wish to migrate. This is the tricky part the level must be exactly the same. If you have SP2 on the source server then the destination server must have SP2. If you have a hot fix on the source server then the destination server must have the same hotfix. once you are sure the levels are the same place the destination server in single user mode. backup the source servers master DB. Restore the backup to the destination server. backup and restore msdb as well.

    you can now take the DB out of single user mode. Restore all other non system DB's that you have created. This is a rough dscription but should get you pointed in the right direction.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

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

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