May 19, 2011 at 4:48 am
Is Database_Snapshot a backup of the database internally...
Why it is called a snapshot while backup is also the same thing?
May I know why snapshot technology comes into picture?
Thanks
May 19, 2011 at 4:59 am
It is not a backup. It's nothing close to a backup (which is why it's not called one)
http://msdn.microsoft.com/en-us/library/ms175158.aspx
http://msdn.microsoft.com/en-us/library/ms187054.aspx
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
May 19, 2011 at 6:11 am
Database snapshot is entirely different from backup.
When you take database backup, it will have all the data pages of the database.
When you create a snapshot, it's file size is 0 bytes. Nothing will be there in it.
When you make changes in the database, original page is saved in the snapshot.
As you make changes in the database, snapshot file keeps growing.
You can use snapshot to query mirror/standby databases.
May 19, 2011 at 6:45 am
Suresh B. (5/19/2011)
You can use snapshot to query mirror/standby databases.
Mirrored DBs only. Standby DBs are read-only already, and a snapshot cannot be taken of a DB in the recovering state (other than in DB mirroring)
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply