SQL Sever Maintenence 2008R2 With SAP Business One

I'm using SAP Business One 8.8 on MS SQL Server 2008 R2. I am more familiar with MySQL and my company came from Quickbooks. I asked my SAP Partner and they told me there is no regular maintenence required on MSSQL with SAP. However, I feel like this is a wrong answer and that I should be doing things like rebuilding indexes, etc.

Can anyone give me some database maintenence pointers? We're backing up daily, but I feel like we should be addressing indexes, etc.

If there's anything you recommend, or resoruces/books worth checking out please let me know.

Thanks!
CandidochrisAsked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Hi,
Backup your data for recovery purposes. Rebuild and reorganize indexes - depending on data changes in database. Update statistics, check database(s) consistency - DBCC checks.
You can read about this and more in following articles:
Top 10 Best Practices for SQL Server Maintenance for SAP
SQL Server Reference Guide
SQL Server Database Maintenance Checklist
DBA Best Practices Tips
I'll suggest you great scripts for database maintenance tasks - you'll find stats update, index maintenance, datbase backups scripts:
SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.