Sample Header Ad - 728x90

migration by cloning a Production SQL Server host into a Dev environment

0 votes
1 answer
196 views
We are doing some SQL Server migrations, various versions, by cloning (snapshot backups) the host servers to the new DC in a different domain. Work is still in planning stage, not yet implemented. For the DEV environment in the destination domain, we need to have Production data in the databases from the source instances. I am therefore thinking that we could clone the Production server from the source domain and rename the host in the destination Dev environment. The SQL server host name part of the instance name will also be renamed i.e. host_server_name\instance_name. Are there other considerations that I need to have in going down this route? Things I need to be aware of about moving from Prod to Dev? Logins/users from Prod will be dropped and test logins/users will be scripted in. Any thoughts will be appreciated please. Thank you.
Asked by PTL_SQL (427 rep)
Apr 14, 2021, 12:00 PM
Last activity: Jun 23, 2025, 01:04 AM