Re: Daily Maintence.

Dale E. Reed Jr. ( (no email) )
Fri, 10 Jul 1998 12:13:47 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: Adding charges."
Next message: Pat Augustine: "Terminate Cause"
Maybe in reply to: Thomas Massano: "Daily Maintence."
Next in thread: Jim Dunmyer: "Re: Daily Maintence."

Thomas Massano wrote:
>
> I have a brand new installation up and running. I have the Master and
> Emerald DB dump every night so I have a BU of it.
> What else should i be doing? Are there scripts I should be running, any
> maintenance?
> Looking for your suggestions.

I typically recommend running a "dbcc CheckDB(Emerald)" once a week
via SQLEM (scheduled Tasks). Don't schedule these to happen in the
normal time frame the dump is going on, though. :)

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Dale E. Reed Jr.: "Re: Adding charges."
Next message: Pat Augustine: "Terminate Cause"
Maybe in reply to: Thomas Massano: "Daily Maintence."
Next in thread: Jim Dunmyer: "Re: Daily Maintence."