CREATE DATABASE NewDatabase ON (NAME = 'Your Database Name', FILENAME = 'C:\Backups\NewDatabase.SNP') AS SNAPSHOT OF YourDatabaseName GO Select * from NewDatabase.dbo.test GO
SQL Server Tips & Tricks
CREATE DATABASE NewDatabase ON (NAME = 'Your Database Name', FILENAME = 'C:\Backups\NewDatabase.SNP') AS SNAPSHOT OF YourDatabaseName GO Select * from NewDatabase.dbo.test GO