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 the database onto a single file, without interfering with production availability or backup schedule, etc. To restore, just run this