Low Disk Space

[Former Member]

Dear Experts,

One of mine DEV server is running out of space in the SAP drive ( 😧 )

ECC 6.0 and SQL SERVER 2005

Total size Allocated : 270 GB

SIDData1 : 24 GB

SIDData2 : 23 GB

SIDData3 : 24 GB

SIDLOG1 : 170 GB

Now the message showing in Low Disk Space ( Remaining 5 MB is there ).

So Please tell me what sholud i do?

Kindly give me advice.

Thanks in Advance

Thomas.T

[Former Member]

Suggest you to close this thread if your initial query is answered.

Regards,

Nick Loy

[markus_doehr2]

... and what do you have in drive D?

Markus

[Former Member]

Dear Mark,

Thanks for your quick support,

In 😧 ( SAP USR path & Database files )

[markus_doehr2]

You can try to find out what is occupying the most space (aside from the database files).

Apart from that the only thing you can do is to add a data file on a location where there is enough space to grow - or add more space to 😧

Markus

[Former Member]

Dear expert,

The most space occupied from SIDLOG.( 170 GB ).

Shall i shrunk the Log through SQL server?

Please Advice me

[markus_doehr2]

> The most space occupied from SIDLOG.( 170 GB ).

Yes, you can do that (using SQL Server Management).

The question is: why is it so big? You do regular backups (truncate the log)?

Markus

[Former Member]

Dear mark,

I take backup in weekly basis.

In DB02 --> SIDLOG1 175,069 (Size ) N/A 2097152 (Limit ) 10 % D:\SIDLOG1\J03LOG1.ldf

From SQL Studio, Shrunk Log file-->

Currently Allocated : 175069.38 MB

Available Free space : 16017.72 MB (9%)

Now How to set Shrunk file and how much i can put Please Let me know.

or else I won't assign the Shrunk file then what will happened?

Regards

Thomas

Edited by: thomas_raja on Sep 3, 2011 5:17 PM

[Former Member]

Hi,

Suggest you to take a current log backup and then shrink file via 'dbcc shrinkfile' command.

http://support.microsoft.com/kb/907511

The target size recommendations are also in the KB article.

Regards,

Srikishan

[Former Member]

Dear All,

Thanks for your information

Regards

Thomas