New answers tagged

0

You cannot create a snapshot of a moment other than the present state of the whole database. As Microsoft says: The database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation. It also states that Database snapshots always work on an entire database. Therefore you can't filter what data is ...


0

How precise in time does this snapshot have to be? To the hour? Second? You still didn't answer that in your first comment. So you are using the "Database Snapshot" technology. IMO, this will lead you into trouble in the long run. You add more and more overhead to your database for each snapshot you have. Having database snapshot existing for a longer time ...


Top 50 recent answers are included