1. Home
  2. Point-Of-Sale Software
  3. MRMS 2.0 - LOG FILES

MRMS 2.0 - LOG FILES

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

RK

Reply to
RK
Loading thread data ...
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

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

Reply to
Afshin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.