QB Pro 2009 Transaction log size

QuickBooks Discussion board - Discussions about the popular financial software by Intuit 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date QB Pro 2009 Transaction log size Ken Wampach 05-09-2009  Re: QB Pro 2009 Transaction log size Haskel LaPort 05-09-2009  Re: QB Pro 2009 Transaction log size Ken Wampach 05-09-2009  Re: QB Pro 2009 Transaction log size Laura 05-09-2009  Re: QB Pro 2009 Transaction log size Ken Wampach 05-09-2009  Re: QB Pro 2009 Transaction log size Laura 05-09-2009  Re: QB Pro 2009 Transaction log size Ken Wampach 05-09-2009  Re: QB Pro 2009 Transaction log size Haskel LaPort 05-09-2009  Re: QB Pro 2009 Transaction log size Haskel LaPort 05-09-2009
Posted by Ken Wampach on May 9, 2009, 3:19 am Please log in for more thread options We recently purchased and installed QuickBooks Pro 2009. We have been using QuickBooks Pro 2006. The computer runs Windows XP SP3 with all critical updates. QuickBooks Pro 2009 is run in single user mode. The QuickBooks Pro 2009 is updated to R7. With 2006, when we did a backup, the .TLG file (Transaction Log) file was cleared. We have been doing regular backups with 2009, with full verify enabled. The Company file is about 100MB and the .TLG is up to about 32 MB and seems to keep growing. I believe we are doing exactly what is recommended in KB ID 1000691 which addresses: "The .TLG files do not get smaller after running a manual backup" Has anyone else seen or heard of this? Does anyone know of something else that might prevent the refreshing of the .TLG files? Is there a work around? -- Ken Wampach - FirstNameATLastNameDOTorg Posted by Haskel LaPort on May 9, 2009, 9:51 am Please log in for more thread options > We recently purchased and installed QuickBooks Pro 2009. We have been > using QuickBooks Pro 2006. > > The computer runs Windows XP SP3 with all critical updates. QuickBooks Pro > 2009 is run in single user mode. The QuickBooks Pro 2009 is updated to R7. > > With 2006, when we did a backup, the .TLG file (Transaction Log) file was > cleared. > > We have been doing regular backups with 2009, with full verify enabled. > The Company file is about 100MB and the .TLG is up to about 32 MB and > seems to keep growing. > > I believe we are doing exactly what is recommended in KB ID 1000691 which > addresses: "The .TLG files do not get smaller after running a manual > backup" > > Has anyone else seen or heard of this? > > Does anyone know of something else that might prevent the refreshing of > the .TLG files? > > Is there a work around? > -- > Ken Wampach - FirstNameATLastNameDOTorg The next time you perform a back up do it with full verify on. QB will delete the .TLG file and start fresh and create a tiny little new file when you begin to enter new transactions. > Posted by Ken Wampach on May 9, 2009, 3:05 pm Please log in for more thread options > >> We recently purchased and installed QuickBooks Pro 2009. We >> have been using QuickBooks Pro 2006. >> >> The computer runs Windows XP SP3 with all critical updates. >> QuickBooks Pro 2009 is run in single user mode. The >> QuickBooks Pro 2009 is updated to R7. >> >> With 2006, when we did a backup, the .TLG file (Transaction >> Log) file was cleared. >> >> We have been doing regular backups with 2009, with full >> verify enabled. The Company file is about 100MB and the .TLG >> is up to about 32 MB and seems to keep growing. >> >> I believe we are doing exactly what is recommended in KB ID >> 1000691 which addresses: "The .TLG files do not get smaller >> after running a manual backup" >> >> Has anyone else seen or heard of this? >> >> Does anyone know of something else that might prevent the >> refreshing of the .TLG files? >> >> Is there a work around? >> -- >> Ken Wampach - FirstNameATLastNameDOTorg > > > The next time you perform a back up do it with full verify on. > QB will delete the .TLG file and start fresh and create a tiny > little new file when you begin to enter new transactions. > > >> > As stated originally, full verify is always on when doing backups Is there anything else to look for.? Is there a log somewhere to check? Posted by Laura on May 9, 2009, 3:45 pm Please log in for more thread options > >> >>> We recently purchased and installed QuickBooks Pro 2009. We have been >>> using QuickBooks Pro 2006. >>> >>> The computer runs Windows XP SP3 with all critical updates. QuickBooks >>> Pro 2009 is run in single user mode. The QuickBooks Pro 2009 is updated >>> to R7. >>> >>> With 2006, when we did a backup, the .TLG file (Transaction Log) file >>> was cleared. >>> >>> We have been doing regular backups with 2009, with full verify enabled. >>> The Company file is about 100MB and the .TLG is up to about 32 MB and >>> seems to keep growing. >>> >>> I believe we are doing exactly what is recommended in KB ID 1000691 >>> which addresses: "The .TLG files do not get smaller after running a >>> manual backup" >>> >>> Has anyone else seen or heard of this? >>> >>> Does anyone know of something else that might prevent the refreshing of >>> the .TLG files? >>> >>> Is there a work around? >>> -- >>> Ken Wampach - FirstNameATLastNameDOTorg >> >> >> The next time you perform a back up do it with full verify on. QB will >> delete the .TLG file and start fresh and create a tiny little new file >> when you begin to enter new transactions. >> >> >>> >> > As stated originally, full verify is always on when doing backups > Is there anything else to look for.? > Is there a log somewhere to check? Try creating a portable company file and then restore it over the original file. I tried on one of my files and it reduced the tlg file significantly. > Posted by Ken Wampach on May 9, 2009, 4:13 pm Please log in for more thread options >> >>> >>>> We recently purchased and installed QuickBooks Pro 2009. We >>>> have been using QuickBooks Pro 2006. >>>> >>>> The computer runs Windows XP SP3 with all critical updates. >>>> QuickBooks Pro 2009 is run in single user mode. The >>>> QuickBooks Pro 2009 is updated to R7. >>>> >>>> With 2006, when we did a backup, the .TLG file (Transaction >>>> Log) file was cleared. >>>> >>>> We have been doing regular backups with 2009, with full >>>> verify enabled. The Company file is about 100MB and the >>>> .TLG is up to about 32 MB and seems to keep growing. >>>> >>>> I believe we are doing exactly what is recommended in KB ID >>>> 1000691 which addresses: "The .TLG files do not get smaller >>>> after running a manual backup" >>>> >>>> Has anyone else seen or heard of this? >>>> >>>> Does anyone know of something else that might prevent the >>>> refreshing of the .TLG files? >>>> >>>> Is there a work around? >>>> -- >>>> Ken Wampach - FirstNameATLastNameDOTorg >>> >>> >>> The next time you perform a back up do it with full verify >>> on. QB will delete the .TLG file and start fresh and create >>> a tiny little new file when you begin to enter new >>> transactions. >>> >>> >>>> >>> >> As stated originally, full verify is always on when doing >> backups >> Is there anything else to look for.? >> Is there a log somewhere to check? > > Try creating a portable company file and then restore it over > the original file. I tried on one of my files and it reduced > the tlg file significantly. > Just to be sure I am not assuming something that is not true - Can I conclude from your proposed work around that you have seen the same issue I am experiencing which is that, at least in some cases, a verified backup by QB PRO 2009 will not reduce the .TLG file to near 0, like it did in QB PRO 2006 and like the KB article says it should? Similar Threads Posted transaction reports November 25, 2007, 12:20 pm How do I record a pass-thru transaction? August 31, 2006, 4:32 pm how do I add customers to a memorized transaction June 8, 2007, 10:05 am Memorized Transaction Report August 4, 2008, 9:26 pm Overpaid Vendor Transaction December 9, 2008, 7:09 pm Memorized Transaction/Auto Fill August 8, 2006, 2:02 pm Match 1 downloaded transaction to 2 in the register August 23, 2006, 2:26 pm Vendor center name disappears after transaction June 10, 2008, 5:26 pm Font Size in QB 2007 November 23, 2006, 1:41 am Maximum File Size January 4, 2008, 11:19 am