Database Snapshots in SQL Server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Arvinder Singh... » Database Snapshots in SQL Server 2005

22 posts, Page 3 of 3

«««1 2 3

Database Snapshots in SQL Server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Dugi

Posted Thursday, November 20, 2008 7:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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

Albert Porra

Posted Thursday, December 04, 2008 2:43 AM

Forum 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 »

22 posts, Page 3 of 3

«««1 2 3

Permissions