Backup and user account

  • How can I assign an login id to an existing user who doesn't have user id before? If I want to migate a db to another server and I don't backup and restore master, msdb and model db, what will be the negative effect?

  • Not restoring master,model,msdb and tempdb database will not have any issues but make sure to migrate the logins,all the backup jobs.

Viewing 2 posts - 1 through 1 (of 1 total)

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