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

  • Grant Fritchey (5/12/2010)


    You can backup & restore msdb between servers. Assuming the drives are the same, your Agent jobs should be ok. If the drives & whatnot are different, you'll need to go the scripting route in order to adjust the necessary scripts.

    system database collations can be an issue here, ensure they match (I.e. Master, model, msdb). It's almost certain you will still end up amending some jobs.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉