Insufficient DB Space

[raguraman_c]

Hi,

I have insufficient space in Transaction log, the harddisk parttition has only 5 MB freespace, In other partition i got 250 GB free space. How can I change the path of the DB? Any specific tcodes or can I do it at DB Level. I am running on SQL Server.

If I Try any tcode, it gives dump error. Completely stuck up. Pleas help.

Points Gauranteed.

--Ragu

Message was edited by:

Raguraman C

[Former Member]

Hi,

You must turn off SAP instance and run SQL Enterprise Manager.

Find your database SID name and detach it.

When database is detached, copy transaction log to 250GB partition and run Enterprise Manager again. Log on to the DB server and attach database. You will see small table with paths to every DB files, for example:

siddb.mdf c:\program files\sap\sid

siddb.ndf d:\sap\sid

siddb1.ldf e:\sap\log\sid

siddb2.ldf e:\sap\log\sid

Change siddb1.ldf and siddb2.ldf to your new partition drive letter and click attach database.

Regards,

Marcin Gajewski

[Former Member]

Just backup the transaction log. This will empty the log file to tape.

Then change your TL backup frequency to ensure the log never fills.