Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Database Snapshots in SQL Server 2005 Expand / Collapse
Author
Message
Posted Thursday, November 20, 2008 7:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:25 AM
Points: 1,262, Visits: 3,419
Do we have any possibilities to make snapshot just in particular objects not snapshot all DB!???

Example is if I want to snapshot 3-4 tables every 15 min, then these results goes to another table like Master table as collector of the data from these 3-4 tables!


Simple the snapshot every 15 min will send the data in Master table even if the these 3-4 tables has been updated or not!?



============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #605837
Posted Thursday, December 4, 2008 2:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 29, 2009 12:42 PM
Points: 1, Visits: 6
First of all, let me say that this is the most clear article about SS I've ever seen. Good job!!!.

But I still have a question: If I create a SS at 23:00 everyday, that means that every change in de source database will be stored in every SS? or when I create a new SS on the same database source, the existing SS stops registering changes?

Thank you very much

Albert
Post #613497
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse