A snapshot is a frozen copy of your actual database.
It can be used to provide users a read-only database state at a given point in time ( =create datetime of the snapshot ).
You can have multiple snapshots of the same database !
DBA can use a DB Snapshot as a potential restore point for upgrades in stead of having to go through the regular database backup full/diff/log combination.
Keep in mind a database snapshot may consume a vast number of GB, depending on the insert/update/delete volume of the database.
They are not to be a replacement for your regular backup schema !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me