Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

copy entire instance to another instance on same server

What is the best efficient way to copy entire instance to another instance in a new upper SQL version, but still keep the older instance.

example: there is a 2008R2 instance with 11 databases. on the same sql server, we need to install a 2012 instance and make it exactly the same as 2008.
(same database/users/logins/permissions etc).

(we don't want to upgrade in-place from 2008 to 2012. for sometime, both will be running in parallel.)

thanks
SOLUTION
Avatar of Tony Giangreco
Tony Giangreco
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial