i newbie sql server administration , config. apologies if appear confuse / mix terminologies here.
i trying find way take snapshot of current state of database - lock in sort of filegroup/data file - treating master data. track further dml/updates on data new filegroup /data file. dont intend change table definitions , data can change in intermediary state.
is possible achieve in sql server?
i trying find solution of creating master snapshot @ filesystem level , able restore master snapshot.. @ time.
thanks in advance!
Comments
Post a Comment