March 31, 2019 at 7:15 pm
I am trying to find the terminology or a point in the right direction about an idea I had. I have a production server, and a new staging server. I know how to do backups and restores of databases. That’s easy. My question is, is there a way to do a whole copy of an entire sql server instance and put it on the staging server to allow it to have the same databases, same logins, same passwords for those logins, same users for the databases, and have the same jobs. I know the master, and msdb databases contain a lot of that information, but I didn’t think it was as simple as backing up and recovering that to the stage environment. Also, is there a name for this kind of work? Migration? Copy?
April 1, 2019 at 7:23 am
The best way to do this is to restore the user databases, generate scripts for the SQL Agent jobs and use sp_help_revlogin for the users and passwords. Don't try and restore the system databases to the new server.
Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply