SQL Server Guru Paul Randal has a great article titled Top Tips for Effective Database Maintenance. The article is targeted toward “involuntary” or “accidental” DBA’s. I know that we’ve got plenty of those in the Dynamics GP world because I’ve met a bunch of you. Even if you’re a seasoned DBA, there may be a tip or two in hear that you’ve forgotten about.
If you oversee the database aspects of Dynamics GP in any way, you owe it to yourself and your users to read this article.