MS SQL Server Copy a database With Script (SQL Server 2008) Run this on production: USE MASTER; BACKUP DATABASE [MyDatabase] TO DISK = 'C:tempMyDatabase1.bak' -- some writeable folder. WITH COPY_ONLY This one command makes a complete backup copy of