I use bellow code to create a snapshot,but I have this error "Msg 5014, Level 16, State 3, Line 1
The file 'Exhibitor_Data' does not exist in database 'exhibitor'."
CREATE DATABASE ExhibitorSnapShot ON
( NAME = Exhibitor_Data,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\Exhibitor_Data_2013.ss')
AS SNAPSHOT OF exhibitor;
Could you help me , how can I do this?
I'll appreciate your help