Differential backup
in [Reports]
|
From: Djarnis on 11 Jan 2010 04:29 Hi All Quick question regarding differential backup. I plan to setup a solution with a monthly cycle, full backup ever first in the month and differential for the rest of the month. The data in the databases do not change that much, but i will of course have to monitor if the diff gets larger than the full backup. My question is, if anybody has experience with a cycle as large as a month, and anything to recommend against it. I'm mainly interested in if such a setup increases my risk of having broken backups. Best regards Jens
From: Uri Dimant on 11 Jan 2010 05:41 Hi Permit me to advise you to go for nightly FULL backup and every 15/30/60 minutes (up to you) performing a LOG backup In that case you will lose 0 data... "Djarnis" <djarnis(a)gmail.com> wrote in message news:fb343437-df87-4d6d-a075-daa483961eb3(a)d20g2000yqh.googlegroups.com... > Hi All > > Quick question regarding differential backup. > > I plan to setup a solution with a monthly cycle, full backup ever > first in the month and differential for the rest of the month. > > The data in the databases do not change that much, but i will of > course have to monitor if the diff gets larger than the full backup. > > My question is, if anybody has experience with a cycle as large as a > month, and anything to recommend against it. I'm mainly interested in > if such a setup increases my risk of having broken backups. > > Best regards Jens
From: Djarnis on 11 Jan 2010 06:38 On Jan 11, 11:41 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Hi > Permit me to advise you to go for nightly FULL backup and every 15/30/60 > minutes (up to you) performing a LOG backup > > In that case you will lose 0 data... Well, the data is mostly reporting data and we can afford to loose one day of data, the main problem at the moment is that we have some quite large databases (a total of close to 1 terabyte) and performing a full backup each night, moving them around and having storage for them is becoming a bit of a problem. Thats why i wanted to do differential backup (the monthly schedule matches how often we take a tape backup). At the moment we do full backups every night, copy them to a storage server, where we keep 4 full backups (today, yesterday, this month, previous month), if i move to differential i would guess i could get do restores on day level for two months back and even save some space (and a *lots* of network transfers and disk activity). Best regards Jens > "Djarnis" <djar...(a)gmail.com> wrote in message > > news:fb343437-df87-4d6d-a075-daa483961eb3(a)d20g2000yqh.googlegroups.com... > > > > > Hi All > > > Quick question regarding differential backup. > > > I plan to setup a solution with a monthly cycle, full backup ever > > first in the month and differential for the rest of the month. > > > The data in the databases do not change that much, but i will of > > course have to monitor if the diff gets larger than the full backup. > > > My question is, if anybody has experience with a cycle as large as a > > month, and anything to recommend against it. I'm mainly interested in > > if such a setup increases my risk of having broken backups. > > > Best regards Jens
From: Uri Dimant on 11 Jan 2010 06:59 Hi Well , is it SQL Server 2008, you can test compressing backups , (I reduced the size of 900 gb database to 470 gb). Another way is probably using a third party tools like red-gate or lite speed that have a great compressing ability Your approach is also good one. Test it and see how long does diff backup take...... "Djarnis" <djarnis(a)gmail.com> wrote in message news:f112a80b-9e2a-4cf3-b221-8d202a80c97c(a)k17g2000yqh.googlegroups.com... On Jan 11, 11:41 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Hi > Permit me to advise you to go for nightly FULL backup and every 15/30/60 > minutes (up to you) performing a LOG backup > > In that case you will lose 0 data... Well, the data is mostly reporting data and we can afford to loose one day of data, the main problem at the moment is that we have some quite large databases (a total of close to 1 terabyte) and performing a full backup each night, moving them around and having storage for them is becoming a bit of a problem. Thats why i wanted to do differential backup (the monthly schedule matches how often we take a tape backup). At the moment we do full backups every night, copy them to a storage server, where we keep 4 full backups (today, yesterday, this month, previous month), if i move to differential i would guess i could get do restores on day level for two months back and even save some space (and a *lots* of network transfers and disk activity). Best regards Jens > "Djarnis" <djar...(a)gmail.com> wrote in message > > news:fb343437-df87-4d6d-a075-daa483961eb3(a)d20g2000yqh.googlegroups.com... > > > > > Hi All > > > Quick question regarding differential backup. > > > I plan to setup a solution with a monthly cycle, full backup ever > > first in the month and differential for the rest of the month. > > > The data in the databases do not change that much, but i will of > > course have to monitor if the diff gets larger than the full backup. > > > My question is, if anybody has experience with a cycle as large as a > > month, and anything to recommend against it. I'm mainly interested in > > if such a setup increases my risk of having broken backups. > > > Best regards Jens
From: Djarnis on 12 Jan 2010 06:09 Just realized that i subscribed to the wrong group (reportingsvcs) with a sql server question, sorry about that. Best regards Jens On Jan 11, 10:29 am, Djarnis <djar...(a)gmail.com> wrote: > Hi All > > Quick question regarding differential backup. > > I plan to setup a solution with a monthly cycle, full backup ever > first in the month and differential for the rest of the month. > > The data in the databases do not change that much, but i will of > course have to monitor if the diff gets larger than the full backup. > > My question is, if anybody has experience with a cycle as large as a > month, and anything to recommend against it. I'm mainly interested in > if such a setup increases my risk of having broken backups. > > Best regards Jens
|
Next
|
Last
Pages: 1 2 Prev: Percentage Calculations Issue Next: OCR-B font are not anymore printed, displayed ...!? |