Shrink Database

[former_member187989]

Dear all,

Live database allocated size is 3422.44 MB,space available is 5.13 MB,

Back up database size is 2.66 GB,I noticed these details from database properties,

Database is 2 years live db.

Is this cause any performance problems in SAP B1 ?

Is size is Ok / need to shrink ?

If there is need to shrink database ?, What is procedure to do it ?

Thanks in advance.

Edited by: Jeyakanthan A on May 28, 2009 6:00 PM

[msundararaja_perumal · Accepted solution]

Hi,

I assume you are using MS SQL Server,

Kindly refer this note:[1224089|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&;note_numm=0001224089] for How to shrink a MSSQL Server 2005 / 2008 Database

Ensure that you take a full database back up before proceeding.

[Former Member]

Hi Sir,

We are using SAP B1 sql, sometimes we are getting SAP server down & unbale to process fast client server are taking long time to process simple updation.what is the solution . how can we get the speed.

[Former Member]

HI Jeyakanthan,

you can use the following query to shrink your database,

1. backup log "SBO-COMMON" with truncate_only; execute after writing this.

2. DBCC SHRINKFILE ("SBO-COMMON", 35) execute after writing this. 35 here is the size in mb , you can make it as 100.

Then you need to select the database, right click> tasks> shrink--> files... in the file type , select log and click on OK. In this way you can avoid the error message that you get, transaction log is full!!!!

Hope this helps..

Regards,

Joseph

[Former Member]

Hi

Take a look at AdministratorGuide_SQL that comes with your patch level or with software download .

It is under the folder Documentation >Setup .It tells you exactly how to shrink your database .

It is a regular process if your transaction log has increased significantly than your database size.

Thank you

Bishal

Edited by: Bishal Adhikari on May 28, 2009 6:22 AM