Home Forums SQL Server 2005 Backups Backup whole instance, restore to a new server, with all the logins and permissions intact RE: Backup whole instance, restore to a new server, with all the logins and permissions intact

  • Hi,

    Script the logins from Master DB; Script the Jobs from MSDB;

    Move the databases using either Detach\Attach or Backup\Restore to the new instance

    Run the login script on Master

    Create the jobs back using the script

    If sny SSIS packages stored in MSDB, you may have to import them back.

    Thank you

    [font="Verdana"]Renuka__[/font]