I use EMC Networker as following:

- Take full and differential backups with Legato to VTL

- Take transaction log backups to disk with SQL Server utilities

- Transfer transaction log backups from...

SAP is very restrictive regarding SQL Server configuration settings, administrative options etc.

Since a SAP database is usually large enough, they only recommend to update statistics after an upgrade takes place....

Perry,

I agree in general with your suggestions but you should take into account that the database hosts a SAP application. SAP has some restrictions in the way a database is...

The question is, have you run DBCC UPDATEUSAGE on the whole database since the upgrade?

--The upgrade took place 7 months ago and DBCC UPDATEUSAGE run

after it.

What makes you think...

There's not really enough detail in the original post to say whether this is reasonable or not.

I assume there is a good reason for rebuilding the table data completely? You...