Database maintenace tasks 2

[ColinM]

Hi,
I have a database which will not be used at night, so should I run any procedures on it.
i.e.

DBCC CHECKDB
DBCC DBREINDEX (ALL TABLES)

Should these be run before or after the backup?
Is it possible to be alerted if there is a problem with these commands, if so how?

 

[tlbroadbent]

1- Yes, run maintenance off-hours.
2- Run before backup. There are at least two reasons for this.
If there is a problem you don't want to backup a bad database.
Reindex creates transactions. You want to backup to clear the transaction log.
3- Setup a job to run these commands with notification turned on.

The easiest way to do this in SQL 7 and above is to use the wizard to create a maintenance plan. Terry

http://members.home.net/tlbroadbent/index.htm

 

[ColinM]

Thanks Terry,
Out of curosity, how do people backup up their databases.

Do you use just one file and overwrite daily
(what happens if the power dies half-through??)
Or a rotating tabe backup?
or something else?

 

[tlbroadbent]

We have chosen to backup to a file that has the date as part of the name. We use native SQL backup. The backup files are copied to tape using ArcServe backup software. We maintain several months of tape backups. Terry

http://members.home.net/tlbroadbent/index.htm