Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is meant by 'House Keeping' in context of a database?

One of my clients has mentioned the term 'Database House Keeping' in his tender specs. I am not sure about the term, please help.

like image 335
Eros Avatar asked Oct 20 '25 03:10

Eros


1 Answers

It should be:

  • Index rebuild or reorgansise
  • Statistics update
  • DBCC CHECKDB (check integrity etc) -etc

Other stuff:

  • Check backups on tape/offline
  • Check backups can be restored
  • Monitor size changes
  • etc

In this context, I guess:

  • Managing older data (I've worked with systems with defined archive processes)

The 1st and 2nd list should be done anyway, regardless of what some vendor says.

like image 56
gbn Avatar answered Oct 21 '25 20:10

gbn



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!