Re: database maintenance for companies that run 24/7

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 10:52:05 -0400

They do what they have to based on their specific requirements. Almost no
one that is in a 24 x 7 will be doing any shrinking of files and it should
rarely be done anyway. If it's truly 24 x 7 then DBREINDEX may not be an
option and INDEDXDEFRAG might be the way to go. It is impossableto go into
enough detail of how to maintain a 24 x 7 operation in a newsgroup. If you
have this type of requirement and are asking these questions I would highly
recommend you hire a qualified consultant. 

-- 
Andrew J. Kelly  SQL MVP
"Dan" <ddonahue@archermalmo.com> wrote in message
news:%23T1z%23uaPEHA.252@TK2MSFTNGP10.phx.gbl...
> For a company like an airline that runs 24/7 and the database is always
> being accessed and they can't shut down, how do they do maintenance on
their
> databases? How do they do things like defrag or rebuild indexes or shrink
> files?
>
> Do they have two databases and they switch back and forth?
>
> Thanks,
>
> Dan
>
>

Relevant Pages

  • Re: Developers and prod servers
    ... Hi Dan, ... databases. ... >SQL Server MVP ... >> production servers, but prevent them from changing stored ...
    (microsoft.public.sqlserver.security)
  • RE: BizTalkMgmtDb is set to SUSPECT cant recover
    ... Hi Dan, I'd recommend restoring a backup of this database as the first ... recovering databases marked as suspect, ... BizTalkMgmtDb is set to SUSPECT cant recover ...
    (microsoft.public.biztalk.general)
  • Re: removing old logins
    ... "Hari Prasad" wrote: ... > drop the user associated to that login from all the databases and then drop ... > "Dan D." ...
    (microsoft.public.sqlserver.server)
  • Re: SPS and the ability to export and import data
    ... Hi Dan, it certainly does. ... There are many different ways such as backend ... databases with HR systems to Excel data retrieval services. ...
    (microsoft.public.sharepoint.portalserver)