Re: Daily Maintence.

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

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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |