Restore in order?

  • Hi there, lets say I have a couple of user databases and of course the system databases. Now if I wanted to restore all the databases to a new installation of sql server, do I need to restore the user databases and then the system databases? Also, does it matter if I restore the master and msdb databases in a particular order? Thank you.

  • I would just restore the user databases and will fix the logins and depends on scheduled tasks i will restore the msdb

    Shas3

  • I guess we would have to start with single user mode to restore master.

    .

  • True, master,msdb and model first.

    Next user db.

    Franco


    Franco

  • Thanks everyone.

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

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