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
