Re: 100% uptime administration and optimization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris V. (tophe_news_at_hotmail.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 09:53:14 +0100

Without any meaning to replace a proper look into that matter (I concur with
precedent post about the work involved), some pists to look at :

- Hardware (do not expect 100% uptime on a simple workstation...)
- What are your exact needs (could a stand-by DB be acceptable.. and so on)
- Have a look to log shipping procedure.
- backup need to be thought in matter of restore (how long max to restore ?
is there any loss possible if something goes very wrong etc)

It looks to me that you have not yet the precise requirements about what you
are trying to achieve, that already would be a great step to design your
backup & DRP plan,

Chris
"Subnet MaskedMan" <Subnet MaskedMan@discussions.microsoft.com> wrote in
message news:A5723794-DF25-49AB-A002-1C3158E89B7D@microsoft.com...
> Hello all,
>
> If I have a very large database OLTP database with must always have a
> guarantee of 100% what would be the ideal backup/restore plan, and what
are
> some things that need to be done that you wouldn't do in an smaller DB
that
> doesn't need such a high availability?
>
> Should tables be more normalized or less, less group by's, unions,
sort
> by's?
> And other than dbcc checks what else needs to be done on a everyday
> consistent basis?
>
> Thanks, I have a very large db that will soon be going live and requires
> 101% uptime.
>
> thanks again
>

Relevant Pages

  • Re: New Group for Super 7 Bonus Draw
    ... Secondly you may be looking for backup here? ... wacky whacky jacky will see this message every time he posts here. ... the subject doesn't matter. ... nothing you say or do can justify your bad behavior and destructive ...
    (rec.gambling.lottery)
  • Re: need help retreiving files
    ... You should have backup copies of important data saved to removable ... troubleshoot anything, you don't try to fix anything, you don't try ... copy of it first and messing up things further won't really matter. ... Ontrack Easy Recovery Pro v6.10.07 ...
    (alt.comp.hardware.pc-homebuilt)
  • Re: Back up
    ... saying you should back up your data I am running Microsoft Windows Xp home ... Unfortunately no matter how careful you are problems do occur either by ... backup all data and programs onto either an external HD or to CDs and DVD ...
    (microsoft.public.windowsxp.newusers)
  • Re: Need volunteers for help on Opensource ports for HP-UX Freeware site
    ... media set without permission from HP is a violation of their copyright. ... also doesn't matter if the receiver of the copies has a license or not, ... because the license only says if he is allowed to _run_ the software. ... allowed to give the backup copies away, and if You sell the software or the ...
    (comp.sys.hp.hpux)