Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Database Size

I know this question has been asked before, but I still cannot find a solution. We've used SAP B1 for 10 months only and our db size is over 6.2GB! I've read SAP's documentation and I tried shrinking the database, but nothing happens. Here's what I do step by step:

in SQL 2005 Management Studio, I right click on the database, select "Tasks-Shrink Files" (or Shrink Database.. I've tried both). Then I choose either file type as "data" or "log files", leave "RElease Unused Space" and click OK. After few seconds the dialog box disappears and nothing changes.. Same size. I've also tried changing the shrink action to "Reorganize pages before releasing unused space", but the smallest amount I can shrink it to is the current size.

So at this point I need some advice as to what to do. SAP is getting slower and slower each day. Thank you for your help

Former Member replied

Unfortunately currently there are no archival options to reduce the

Database size in SAP Business One, as a lot of records contain legal

information and therefore cannot be removed/archived.

Below please find 2 possible workarounds

1- Shrinking the database and log file.

Kindly note that usually the log file is bigger that the database. For

more information regarding shrinking, please see SQL Server Enterprise

Manager. Help 'Keyword' - Shrink Database. For more information please,

refer to SAP Note number 548772 and 1002099.

2- Create a new Database and only copy the relevant data from the old

one.

In Terms of large DB (MDF's), in order to verify that the Database does

not hold "Unused space" and holds it in the MDF, you can run maintenance

plan on the database and choose the option to remove unused space from

the database.

If the MDF file is the same size after running the wizard then in terms

of System there isn't much left to do.

In terms of maintenance - it's very important to keep daily\weekly

maintenance jobs (SP_updatestats, maintenance jobs) on Databases,

especially when running large DB size. Note 783183.

In terms of performance - we usually stick to Microsoft's tips on

running and maintaining SQL Server (Using Raid, splitting MDF and LDF

between two physical Hard disks...)

Regards

Vikas

Edited by: Vikas Rastogi on Oct 10, 2008 10:37 PM

Edited by: Vikas Rastogi on Oct 10, 2008 10:38 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question