create database test_snap --快照名 on ( name = test, filename = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQL\MSSQL\DATA\test_snap.mdf'--快照要保存的位置 ) as snapshot of test