This is a very good white paper on this important topic

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx