Skip to Content
0
Former Member
Jul 10, 2009 at 06:24 PM

Cannot shrink log file 2 (PRDLOG1) because all logical log files are in use

403 Views

Friends,

I am having 2 drives for MSSQL DB.

File system

G: SAPDATA 1,2 ,3 - size 1 TB (RAID 5)

H: PRDLOG1 - size 90 gb. (RAID 1)

When my PRD server is running all 90 gb of PRDLOG1 is full in H :drive & throws a n error in sap SNAP_NO_NEW_ENtry.

I understood i has no space to write log file & i created a new logfile in G: drive with name PRDLOG2 7 contuied with all the PRd activities with oyt any interruption.

after creating my file system as follows.

G: SAPDATA 1,2 ,3 & PRDLOG2 - size 1 TB (RAID 5)

H: PRDLOG1 - size 90 gb (RAID1)

as PRDLOG2 is on RAID5 performance is badly hitted with bottle necks.

******************************************************************************************************************************************

Now i have taken backup of full DB. & try shrink log PRDLOG1 & planned to move PRDLOG2 from G drive to H drive.

So my system will start working like before .

When i am trying t shrink file PRDLOG1using query dbcc shrinkfile(PRDLOG1, 50) it is running successful & i am getting following message.

Cannot shrink log file 2 (PRDLOG1) because all logical log files are in use.

1 rows affected.

if dbcc trows an error contact your systems administrator

how should i overcome this issue. as im basicaly an oracle guy i am finding hard to understand this messages.

Request to provide some support from any MS-SQL guys.

rgds,

rahul..