June 6, 2018 at 11:45 am
We are transitioning form one SQL Server 2008r2 Instance to another (that's on a different windows server). I need to duplicate everything from the old server to the new including Logins, jobs, etcl Whats the best way to do this without cloning the actual server itself?
Kindest Regards,
Just say No to Facebook!June 7, 2018 at 8:12 am
For the Logins, you could use sp_help_revlogin to script the logins from the source and create them on the destination. For the Sql Server jobs, you can script out all the jobs on the source using SSMS and create them on the destination. Of course, for the databases themselves, you can use Backup and Restore. I am sure you know 2008R2 is way out of support with MS unless you have extended. Any chance of upgrading the instance during the transition?
June 7, 2018 at 10:40 am
RVSC48 - Thursday, June 7, 2018 8:12 AMFor the Logins, you could use sp_help_revlogin to script the logins from the source and create them on the destination. For the Sql Server jobs, you can script out all the jobs on the source using SSMS and create them on the destination. Of course, for the databases themselves, you can use Backup and Restore. I am sure you know 2008R2 is way out of support with MS unless you have extended. Any chance of upgrading the instance during the transition?
We have to use 2008R2 as its the latest version of SQL Server that the program we uses supports. We will be upgrading their product version in 6-12 months and that upgrade will support the more recent SQL Server builds. We just have to manage in the mean time using 2008R2.
I knew about sp_help_revlogin for duplicating the logins and we are backing up and restoring the DB's . What I wasn't sure about was the other things specific to SQL Server i8nstacne form jobs to liked providers and so on.
Kindest Regards,
Just say No to Facebook!June 7, 2018 at 11:20 am
dbatools(Leverages powershell) has fantastic migration solution. FYI
https://dbatools.io/functions/start-dbamigration/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply