SQL Maintenence Plan

[Lee-Anne Waters via AccessMonster.com]

Hi,

would anyone know what would be the best maintenence plan to incorporate into my SQL Database. or even any links.
i have just upgraded from access to SQL and am not up to date with how to set up the best plan

thanks heaps
Lee-Anne

 

[Van T. Dinh]

There is no "standard" maintenance plan as it each database requires a
different maintenance back-up strategy. In my case (testing of manufactured
products in a 24-hour operation), I use the following:

* (For system databases): full back-up of master, model and msdb everyday -
retain for 7 days. These are very small so full back-up is the most
convenient way to go.

* Full back-up of my database every week - retained for 4 weeks.

* Daily differential back-up of my database everyday except for the full
back-up day -retain for 2 days.

* Incremental transaction log back-up every 4 hours - retained for 2 days.

* Integrity check every week. This is the one that fails often as the
database must be in single-user mode.

All of the above back-ups go to the Backup directory of SQL Server which is
backed up to tape also(full once a week, daily differential everyday).

Check your SQL Server B.O.L.
--
HTH
Van T. Dinh
MVP (Access)

Hi,

would anyone know what would be the best maintenence plan to incorporate

into my SQL Database. or even any links.