Re: database maintenance for companies that run 24/7
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/19/04
- Next message: Jacco Schalkwijk: "Re: torn page detection"
- Previous message: Jack Wachtler: "Re: Upgrade Enterprise Evautation Edition to Developer Edition"
- In reply to: Andrew J. Kelly: "Re: database maintenance for companies that run 24/7"
- Next in thread: Dan: "Re: database maintenance for companies that run 24/7"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Jacco Schalkwijk: "Re: torn page detection"
- Previous message: Jack Wachtler: "Re: Upgrade Enterprise Evautation Edition to Developer Edition"
- In reply to: Andrew J. Kelly: "Re: database maintenance for companies that run 24/7"
- Next in thread: Dan: "Re: database maintenance for companies that run 24/7"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|