I have a cliet with a SQL Server 2003, they only use the server as a database server. We are trying to run a software that will backup the whole server and then upload it to the web. The software runs perfectly on their domain server but in the SQL server it creates huge incremental files due to the Maintenance Plan that is ran every night. The main problem here is that they have an index fragmentation of over 40% every day so they have to rebuild the indexes and rebuilding the indexes cause sectors on the system to change and therefore the software backs up the whole drive instead of just the files that have changed. My question is: Is it normal for a sql server to have a high fragmentation percentage every day? how can I decrease that? Is it necessary to rebuild the indexes every day? How can i tune that up? The fragmentation is not high on all the tables and even if we run the script in the morning (before people work on them) to determine the fragmentation percentage, the fragmentation percentage is high.
Thank you in advance!