Taking Database backup for every 4 hrs in SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Taking Database backup for every 4 hrs in...

Taking Database backup for every 4 hrs in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

vinayak.v

Posted Tuesday, December 28, 2010 10:14 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:35 PM
Points: 226, Visits: 156

hi..
i'm trying to retrieve the data from database using ssis package..
database name is employee which contains 48 tables and it is around 20GB of memory.. it is a production
database..

now what i want is to retrieve the data for each four hours..
i.e i want to execute the package for every 4 hrs..

now what i did is i have taken a database transfer task and from the
source i.e production database i want to transfer to my database
which works fine..

but what is the problem here is for every 4 hrs whole DB is replaced in my system
i've given overwrite TRUE..

Here user enter the data into database for every 4 hour is minimum 10 MB of data..
instead for replacing the whole database for every 4 hrs is there any
solution that what user enter data into database only that much amount of data should be append into my system.. is it possible

please help me..

Post #1040105

crazy4sql

Posted Tuesday, December 28, 2010 10:25 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:10 PM
Points: 876, Visits: 3,731

if both database are identical and you refreshing your database with live database by every 4 hrs then you can consider transactional replication.
Or
if you want your data also need to be updated on live database then peer-to-peer replication also there.

----------
Ashish

Post #1040110

vinayak.v

Posted Tuesday, December 28, 2010 10:43 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:35 PM
Points: 226, Visits: 156

Thanks for replying..
i dont know about the transactional replication..
i will try..

is there any link for the transactional replication..
so that i can find it ..

Post #1040114

crazy4sql

Posted Tuesday, December 28, 2010 11:45 PM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:10 PM
Points: 876, Visits: 3,731

http://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm

this is about 2000 but you will get basic idea about transactional replication.
Also if you search this website with your requirement then you will get plenty of useful information.

----------
Ashish

Post #1040123

vinayak.v

Posted Tuesday, December 28, 2010 11:50 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:35 PM
Points: 226, Visits: 156

thank you..
i'll try it..

Post #1040124

« Prev Topic | Next Topic »

Permissions