CREATE DATABASE my_backup_db ON ( NAME = my_db, FILENAME = 'c:\mybakup.bak' ) AS SNAPSHOT OF my_production_db
A delicious developer blog.
CREATE DATABASE my_backup_db ON ( NAME = my_db, FILENAME = 'c:\mybakup.bak' ) AS SNAPSHOT OF my_production_db