Server. My database is about 170mb now, and I really don't have any idea
what I need to be doing on a regular basis to keep it 'well-oiled'. What
are the common maintenance tasks in order to keep it running as quickly and
as efficiently as possible?
Any help or pointers to help would be great appreciated.
Thanks,
GlennThe place to start is to open up SQL Enterprise Manager. Select your server
and then choose the Tools | Database Maintenance Planner option. Then
follow the instruction on the Wizard screens.
Mike O.
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
quote:
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
quote:|||It will take a few hours, but please read the SQL Server 2000 Maintenance
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
and Operations Guide at
http://www.microsoft.com/technet/tr...ide/default.asp
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Glenn Carr" <glenn@.nospam-glenncarr.com> wrote in message
news:%23TWbJns2DHA.3436@.tk2msftngp13.phx.gbl...
quote:
> I'm new to SQL Server after moving an online database from Access to SQL
> Server. My database is about 170mb now, and I really don't have any idea
> what I need to be doing on a regular basis to keep it 'well-oiled'. What
> are the common maintenance tasks in order to keep it running as quickly
and
quote:
> as efficiently as possible?
> Any help or pointers to help would be great appreciated.
> Thanks,
> Glenn
>
No comments:
Post a Comment