Re: database maintenance for companies that run 24/7

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

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 11:02:01 -0400

Good points. I was thinking more along the lines of applying security
fixes, windows update, etc. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Andrew J. Kelly" <sqlmvpnoooospam@shadhawk.com> wrote in message
news:#Qh#aDbPEHA.4036@TK2MSFTNGP12.phx.gbl...
> 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.

Relevant Pages

  • Re: double figure of day and month
    ... > Aaron Bertrand ... > SQL Server MVP ... > "Andrew" wrote in message ... >> I am going to use the date as my filename. ...
    (microsoft.public.inetserver.asp.general)
  • Re: double figure of day and month
    ... Aaron Bertrand ... SQL Server MVP ... "Andrew" wrote in message ... > I am going to use the date as my filename. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Error number: 0x80072F76 - WIndows Updates.
    ... Otherwise follow the Windows Update Checklist: ... My security settings should be OK to allow this to ... > setting for normal browsing i.e. will only run signed ActiveX controls ... > Andrew D Murray ...
    (microsoft.public.windowsupdate)
  • Re: datetime problem
    ... parameter statement. ... How many language tables do you have? ... >> Aaron Bertrand ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Find the first available integer.
    ... by being in simple recovery model). ... using a real server with a real disk system, and if you insert a reasonable ... Aaron Bertrand ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)