Prev: Percentage Calculations Issue
Next: OCR-B font are not anymore printed, displayed ...!?
From: Djarnis on 12 Jan 2010 06:21
Hi Uri

Thanks for the answer. We are using a mixture of sql server 2000 &
2005 and I'm a bit uncomfortable using third party backup solutions
(probably because i never tried it).

I will setup a test for one or two of the databases and see how it
goes.

Best regards Jens

On Jan 11, 12:59 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote:
> 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" <djar...(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

First  |  Prev  | 
Pages: 1 2
Prev: Percentage Calculations Issue
Next: OCR-B font are not anymore printed, displayed ...!?