How to defrag a SQL 2005 DB for ECC 6.0?

[MPGraziano]

We noticed issues with our backups done thru 3rd party tool commvault. and the administrator for commvault recommended that a defrag of the db files may correct this issue

Can anyone recommend a quick way to do this?

or do I have to do an export / import with re-indexing? or otherwise?

Please Advise

thanks

maria

[markus_doehr2 · Accepted solution]

> We noticed issues with our backups done thru 3rd party tool commvault. and the administrator for commvault recommended that a defrag of the db files may correct this issue

Did you try to do a native SQL server backup on disk - and is that of the same (low) speed?

Markus

[MPGraziano · Accepted solution]

No, for a couple of reasons, not enough resources to do the backup , and it would propably take too long.

In fact , the issues of defrag is also noted from a job that is run thru a tool (SCOM) that indicates that the server is 82% fragmented

?

Maria

[Former Member · Accepted solution]

Hi Maria,

fragmentation is usually no problem at all for an SAP ERP system. Please [read|; what Beate wrote about it (and forget SCOM - just standard default alert something values...).

If you really want to get rid off fragmentation (at least for a few moments) you have to rebuild or reorganize your complete DB. Depending on the size that might take a while but could be done online. Please check the 'alter table ... reorganize/rebuild' statement in Books Online. In case you go for a rebuild also check the MAXDOP and ONLINE option. Maybe you can test this on system copy first (tons of TA-logs).

Sven

[former_member212643]

SQL Transaction Log is what takes most of the hard disk space (sometimes few hundreds of GBs!!). we need to shrink the DB so as to compress this log archive and recover good amount of space. The process is mentioned in this SAP Note 421644.

All the best.

Regards,

Raghu

[Former Member]

Hello,

If you are just trying to shrink the tlog database you don't need to reorg the database. Just back up the tlogs and run dbcc shrinkfile on the tlog files. Sometimes you need to run the backup twice to get it to shrink.

Regards,

Michael

[MPGraziano]

Ok Thanks, will have to give this a shot as well

Even though we have regular backups running and are supposed to clear the logs

maria