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

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -