Database snapshot update I m a new in SQL. I have one question where if we update, i mean add or delete data at source database, is that the data will be update in database snapshot also. Please enlighten me.
No, that's what snapshots are for: a static copy of the database at a specific instant. If you update the base database, the updated data pages are moved from the base database's data files to the the snapshots data files, with a "copy on write" operation, so that the snapshot always contains the same version of the data as when it was created.