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 (47)
11/30/2008 5:07:01 AM
pos 14173 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 46

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 -

Retail Realm

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

"RK" <> wrote in message
> 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 

afshin (783)
11/30/2008 5:28:53 AM

Similar Artilces:

Rollup 2 #2
Can you see somewhere in CRM if you have installed Rollup 2 or not? I have been on Help---About MS CRM without seeing it. On Feb 19, 7:04=A0am, Martin <> wrote: > Can you see somewhere in CRM if you have installed Rollup 2 or not? > I have been on Help---About MS CRM without seeing it. Hi Martin, You'll have to go the MS site to find out what the version of CRM will be after the rollup is installed (I'm not sure if you're using 3.0 or 4.0). Then you can go to the about MS CRM menu to see if the version matches. Hope that helps, goo...

Hyperlink warning #2
Some computers with Office 2003 with a hyperlink embedded in an Excel workbook will not follow the link even to a local file on the hard drive without a warning message. I have followed the instructions on the link, trying both registry entries for Common Security and Excel Security. I have also tried the other suggestions. None work. I support an application used by clinicians and researchers which contains frequently used links to sound (.wav) files. This application is made unusable by the repeated warning messages. Any new answers plea...

The "Stationery and Fonts" section found under "Tools", "Options", "Mail Format" in Outlook 98 has the "Stationery Picker" button greyed out. This obviously prevents selecting the stationery to use as the default for email messages. Has anyone had this problem, or does someone know how to correct this problem? Thanks, David Preston Hello David. This problem usually occurs because of a permissions issue. If you're logging onto an Exchange server at work, chances are your admin has scaled you back. If it is at home or on a system...

Confidentiality Notice #2
How do i configure Exchange 2003 to add a Confidentiality Notice at the bottom of all outgoing emails?? Can this be done without using Visual Basic? Thanks, Greg ...

Access 2007 and MDE Files
I thought I posted this already, but don't see it. Seems like my post didn't get posted. I have an Access 2003 MDE front end that is linked to an Access 2003 MDB backend. Been in use for years, works fine. I was led to understand that Access 2007 couldn't run a MDE file. Reference this Microsoft KB article. My customer who uses this unknowingly gave access to the MDE file to a user who only has Access 2007 installed. To my/our surprise, the MDE ran in Access 2007. Can anybody explain that? At th...

XSD For XML File
Hrm, I don't think it's possible to create a schema for the following XML, just asking in hopes of some good suggestions for it: <menuBar> <menuBarItem> <menu> <menuItem /> <menuItem /> <menuItem> <menu> <menuItem /> </menu> </menuItem> </menu> </menuBarItem> </menuBar> Get the picture? I don't think it's possible because of the <menu> grandchild of the first <menu>...

jpeg files in excel
I bought a new computer and now when I click on a hyperlink to a jpg file it opens in MSIE. I prefer the way it worked on my old computer where the file was opened by Windows Picture and Fax Viewer. How can i change this? Thanks Andre Andre kind of Off Topic ? Ah well. If you are using XP, go to Explorer and select Tools | Folder Opions... | File Types tab | select the .JPG extension in the list of "Registered file types" and in the "Details for" section Change the file it is opened with. You should get a list of programs with the recommended p...

Vanishing emails #2
Hi When downloading messages from a mailbox hosted by my ISP, on occasions Outlook indicates that it is downloading 1 or more messages, but they vanish (do not end up in the inbox of Outlook). Any thoughts gratefully appreciated. Ed. rules moving them somewhere? junk mail filter or antivirus filter catching them before outlook gets them? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Outlook Tips: Outlook & Exchange Solutions Center: http://www.slipstick.c...

Meaning of Symbol (Icon) in Sent Folder #2
This may be a very simple-minded question, but I can’t seem to find reference to it anywhere. 1. There is a symbol in the Sent folder, in the “Sort by: Icon” column that looks like an opened envelope with a blue “I” in a circle. What does this icon mean? It seems to appear for some, but not all, mail I’ve sent to people within my organization (on the Outlook system and in the mailbox. In fact, sometimes it will appear for the same person at some times, but not at others. It never appears for people outside of our network. I also noticed that when it appears, the message includes a...

Help files not appearing
This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C4612C.51C00310 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have just moved over to Windows XP and the Excel help files don't = appear, when i request help. Any Idea's. JB ------=_NextPart_000_0038_01C4612C.51C00310 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Ty...

Recurring Task #2
Also, in the same file as the previous question, I cannot see the expand and/or collapse buttons. I have tried the "show outline symbols" command, but it doesn't work for me. Is there a setting I have changed? ...

Field-level Help Files
Has anyone implement this with their dexterity third-party applications? The Winhelp Functional Library mentions a field-level help capability but it seems that even GP does not implement this feature. I'm currently using version 8.0. Thanks. ...

Decimal point #2
I have a cell that reads 21.59 [for example] but when I click on it, the data entry field on the tool bar extends that number to 6 decimal places. How do I get Excel to read the number only as 21.59? Assuming that the two decimal place version is display only. I ask this because this data is going to populate a SQL database over which I have no control and I don't want my price data displaying on my website to 6 decimal places! Thanks David You'll have to correct the data or use a helper column a2 =3D 21.591234 b2 =3D round(a2,2) Then use B2 for the database. If you can ...

Integrate Microsoft CRM 1.2 with SAP
Hi All, Does anybody have any documentations or url related to Integration of Microsoft CRM 1.2 and SAP? Please reply. Thanks, Kardianto Cakra At present I believe that the CRM system can only be integrated with Great Plains 7.0/7.5 as well as the Office products. On some of the courses it does state a plan for SAP integration but I have not found any information to date. You will have to use a third party integration tool. Scribe Insight would work. "kardi" <> wrote in message news:OOOM3srJEHA.232@TK2MSFTNGP12.phx.gbl... > Hi All, > >...

Restoring backup money files
I have to restore my hard drive. When I opened MYmoney none of my data was there (oh god my checkbook is gone for the last sevreal years). I then attempted to restore the backup and somehow I did the no-no.....I somehow backup a blank money file with the same name as the existing file and apparently overwrote that file and lose the data that I think was originally backup file..Is all my original money date gone? there is two money backup files dated a few days ago attempted to use them and was told wrong path;overwrite proceted (its not) etc......HELP In, Fre...

File and folder permissions
Hello, I have little problem with file and folder permissions. Whatever I do or change permissions on files and folder when properties windows is closed and opened again old values commes back, even when I block heritage from "advanced" window. Is it normal that the "data" partition owner is SYSTEM? What are the best practices for partition on which shared files will be stored, no executable programs or databases. Server is running on W2K8 R2. Thanks for your answers. Mike Hi again, on other W2K8 server owners of drives are "trustedinstaller&...

Air Framing Nailer Kit 8-10 Gauge - 2"
Price:$250.99 Image: http:///image.php?id=B000UFSL5G Best deal: http:///index.php?id=B000UFSL5G Neiko Tools USA 8-10 Gauge 2"~ 3-1/2" Air Framing Nailer Kit * Large Piston For Increasing Power * Stong and Light Weight Die-Cast Body * Drivers Full-Head Nails from 2" to 3-1/2" Long * Includes: Goggles, Oil, Wrenches and Instruction * Max Capacity: 40 pcs * 72-120 psi * Air Inlet: 1/4" NPT * 21 Degree Angle ...

adding columns in 2-d array
I have a 2-d array named TEST. Is there a way of adding the contents of a specific column of that array; e.g., a formula along the lines of: =SUM(TEST(1st column)) without using absolute cell references? Thanks. Try =SUM(INDEX(TEST,,1)) -- Regards, Peo Sjoblom "ACLrecon" <> wrote in message >I have a 2-d array named TEST. Is there a way of adding the contents > of a specific column of that array; e.g., a formula along the lines > of: > > =SUM(TEST(1st column...

stationary #2
Can I design and save my own stationary? If so How? Elaine, Stationary is simply an HTML file. Design it how you like it in your favorite HTML editor. Then in Outlook: Tools > Options > Mail format > Stationary picker > New. HTH, -- Scott Fellman Microsoft -- When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. -- This posting is provided "AS IS" with no warranties, and confers no rights. -- Get Secure! - =======================================================...

MS RMS Database Structure #2
Can someone give me or guide me on how to obtain the RMS database table structure and how they are linked? My customer has the RMS software and would like to run some of his own reports. Thanks, Ben MS-SQL Server Query Analyzer (Store OP Admin) is difficult to get Table list as Enterprise Manager (EM). Thus, Create these procedures; Show and Showtables CREATE PROCEDURE SHOW @T_NAME VARCHAR(100) AS SELECT CONVERT(CHAR, COLUMN_NAME) AS NAME, CONVERT(CHAR, DATA_TYPE) AS DATA_TYPE, ISNULL(CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION) AS SIZE, IS_NULLABLE AS NULL_ FROM INFORMATION_SCHEMA.CO...

How to put the same thing in two different cell'c? #2
Hello, what should i write into cell if I want to see result in another cell. For example: data are in cells: A1, A2, A3 formula is in cell B1: A1+A2/A3 What should I put more, only in B1, if I want to see result in D1 (normaly D1 is empty). I can make only modification in B1. I want to put in B1 two, three, four formulas simultaniously and in B1 i want to see first of them and the rest i would like to see for example in D1, D2 ..... Can anybody help me Thanks a lot Please send me email: Artur ...

rms 1.2 vs 2.0 #2
i'm considering upgrading from RMS v 1.2 to v 2.0 running 5 store locations with HQ. i have a trial version of Store Ops 2.0 that i've been testing to see what differences there are and really can not see where much has changed. i do not know what changed in HQ since i do not have that trial. can anyone fill me in on what improvements were made between the 2 versions? obviously i can not obtain support for v 1.2 any long which is a concern but aside from that is there value in upgrading, especially in these challenging financial times? thanks, jim Brad, You're right ...

Word file too large to open
I have a document that is 566mb and will not open in Word. Is there a way to compress it or something else that will open it? Thanks! You could try if OpenOffice Writer ( could open it. Sometimes that product is better at opening corrupted or too large documents than Word is. If that doesn't work, is your document a docx file (Word 2007 version)? If so, you could change the extension from docx to zip and go into the archive. Maybe you can remove some graphics or stuff in the hope the document will become smaller and then try to open it. It sh...

Email returned as #5.5.0 smtp;553 Recipient rejected
When we send email to certain domains it gets bounced back with the following message: Your message did not reach some or all of the intended recipients. Subject: Subject Sent: 3/14/2005 4:16 PM The following recipient(s) could not be reached: on 3/14/2005 4:16 PM There was a SMTP communication problem with the recipient's email server. Please contact your system administrator. < #5.5.0 smtp;553 <> - Recipient Rejected! SMTP server has delivery restrictions in place...

Need 2 axis on a chart
I have a chart with 4 values evry month. The largest value goes to 370. One item is a percentage between 99.9 and 100. I would like this to be the fourth item and referenced to the right side axis, which would number from 99.9 to 100. When I assign it to the secondary axis, it jumps to the middle of the month and hides the second value. Can I get this set up to reference the right side axis? In a column chart, the columns on a given axis are centered over the category. Hence the single column on the secondary axis obscured the center column on the primary. You can add dummy serie...