January 27, 2014 at 5:42 am
Hi Team,
How to make a snapshot always sync with current database.
Please suggest
Rgds
Minnu
January 27, 2014 at 5:58 am
Snapshots are point-in-time views of the database, they're a static view of the database as of the time the snapshot was created.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2014 at 3:32 am
Hi Team,
I've created a snapshot for reporting purpose, is there any possible way to keep the snapshot upto date with the database,
Please suggest...
January 29, 2014 at 3:57 am
As I mentioned above, snapshots are point in time (static) as of the time they are created. They are not and can not be kept in sync with their source database, the entire point of a snapshot is that it's a static, unchanging view of the source database as of the time the snapshot was created.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply