MRMS 2.0 - LOG FILES

Nov 30, 2008 1 Replies

Rate this thread:

RK 17 years ago

Hi Mates,

I am using MRMS 2.0 and my log files size is multiplying very fast.

Tried doing the database shrinking and making the recovery mode to simple.

Still the log files size is mulitplying.

Is there any fix for this from microsoft.

Thanks in Advance

Vote

Afshin 17 years ago

1) With both the original .MDF and .LDF files located where they supposed to be, run RMS Admin and select the database you want to shrink.

2) Issue this query to find the log device name: SELECT FILE_NAME(2). This will return the name of your log device (in our case, we called the database SS1 and the log device name is Store1_log).

3) Issue this query: DBCC SHRINKFILE (Store1_log, 1). If this does not shrink the file, proceed to the next step

4) Issue this query: BACKUP LOG SS2 WITH TRUNCATE_ONLY (Replace SS2 with the name of your database FOR EXAMPLE RMS_Store1)

5) Then run this query: DBCC SHRINKFILE (Store1_log, 1)

Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk

Retail Realm

= = = = = = = = = = = =

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required