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

Maintaining a 2nd DB y Expand / Collapse
Author
Message
Posted Friday, June 07, 2013 8:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:52 AM
Points: 52, Visits: 214
Hi all,

We keep an offsite copy of a live DB. We currently refresh thus;

1) Back up the ENTIRE live DB,
2) Copy .bak file(group) to Offsite server;
3) Restore (With replace)

However, only 2% approx of the data has changed, so we are throwing a lot of un-needed data across narrow bandwidth. Also space on that offsite server is very restricted.

So I'd like to change step 1 to;

1) Backup ONLY those tables updated on Server1.DB1 since Server1.DB2 was created;

What is the best workflow to do this in SS2K, bearing in mind FK's, and the live DB is already a log-shipping primary being backed up every 15 minutes?

Thanks,

JB
Post #1461122
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse