I just started a new job, and I'm reviewing the database maintenance plan. I've got quite a bit of experience writing SQL, but not much experience with DB administration. My last job was at a large company, and they didn't let regular people touch that sort of stuff.
We are locked into SQL Server 2000 (it's embedded in some quite old software and we can't upgrade yet). The current maintenance plan (Full Recovery model) does the following:
Every hour from 6am - 11pm:
backup log Accounting to Accounting_Logs with noinit
Every night at 1am, this happens:
backup Log Accounting WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE (Accounting, TRUNCATEONLY)
backup database Accounting_ReadOnly to Accounting with init
Then at 3am:
- all the indexes are rebuilt
Is this a decent plan? Will this give us good backups that are easy to recover? I know I'm asking for a lot, but any thought/comments/suggestions would be appreciated.
Please let me know if you need more information. Thanks!