Monday, March 19, 2012

Differential SQL backups ? is this possible?

Hello, I am looking to backup one of our MS Sql databases offsite..
and because our databases are so large, and we do not want to consume
lots of bandwidth everynight during backups.. I was wondering:
Is it possible to backup only changes for a db?
thanks!
Lee
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Replication-...ict229803.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=795309
Have a look at transaction log and differential backups in BOL.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment