sql server - Create Database Snapshot for remote database on local machine -
i having subtle problem in creating database snapshot. connected remote database. want create snapshot on local machine. possible or allowed?
i typing query below
> create database samplesnapshot on ( name = 'sample', filename = > 'c:\samplefile' ) snapshot of sample; go
and getting exception
msg 262, level 14, state 1, line 1 create database permission denied in database 'master'.
i having following questions:
when specify path in query snapshot created on local machine or server machine? if local machine how create snapshot on server machine itself.
no. client/server means send instructions server. execute on server. means c:\ relative server, not client machine.
Comments
Post a Comment