SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DATABASE SNAPSHOTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
200 Posts

Posted - 11/09/2013 :  01:14:29  Show Profile  Reply with Quote
Hai.

if i add a new table to my original database, will that be added to the snapshot of that database or not?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

sgondesi
Posting Yak Master

India
200 Posts

Posted - 11/09/2013 :  01:29:42  Show Profile  Reply with Quote
I have tried this, then it did not get appended to the snapshot.
But in a you tube video, it was told that, "when we make updations to the source database, then sql server performs copy on write process and updates the snapshot database immediately."

So please help me out in understanding the actual things happening behind.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
200 Posts

Posted - 11/20/2013 :  12:49:20  Show Profile  Reply with Quote
I have read about this and got clear understanding of it.

database snapshot is a symbol of integrity.
Normally after creation of a snapshot, if any new object is added to that database,then that one is not added to the snapshot which is created earlier.
The snapshot which is created earlier will remain same from the time of creation.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
200 Posts

Posted - 11/20/2013 :  12:56:14  Show Profile  Reply with Quote
What happens actually with the creation of database snapshot is,
assume that the size of the database is some 12MB.
Now when the snapshot is created, the number of pages that are involved in database for storing data will be counted.

The same number of pages will be allocated for the snapshot. But the original data will not be moved to these data pages of snapshot.
The data will be copied from pages of original database to those of snapshot database only when these data pages of original database gets modified. This is what means "Copy On Write" process.


--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000