Server Duplication 1

[YL5956]

Hello all,

I'm interesting in cloning SQL Server from our production server to a test server. This would include all database, store procedures, permissions etc. What is the easiest most efficient way to accomplish this? Thanks.

 

[tlbroadbent]

Assuming you have installed SQL Server on the 2nd Server, use one of the following procedures.[ol][li]Restore backups from the 1st server OR
[li]Stop SQL server on the 1st Server OR
Detach the databases (see sp_detach_db in SQL BOL)
Copy the MDF and LDF files to the 2nd server
Attach the databases on the 2nd server. (see sp_attach_db)[/ol]It is common to have mismatches between logins and users when moving databases from one server to another. You can easily fix that problem with sp_change_users_login.

Check this article for more info.

Fixing broken logins and transferring passwords

http://www.swynk.com/friends/boyle/fixingbrokenlogins.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.