Transaction log filling up memory space

• 10-17-2008 1:04 PM

  Manny Sanchez Joined on 10-17-2008 Posts 1

  Transaction log filling up memory space Reply Contact Has anyone come across this scenario:  Store1 has HQ server.  Store2 in Dr Philips has exceeded its hard disk memory. The CPU that serves as the server at Store2 appears to be storing transaction logs at: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Store2_Log It has maxed out the 74 GB on the CPU. recently the CPU popped up this message: "The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" when that happens the store is unable to enter any new customers and cannot log into the RMS Manager program.

  Tags: transaction log rms memory

• 11-07-2008 1:00 PM

  In reply to

  Dane Fieber Joined on 10-24-2008 Sarasota, FL Posts 1	Re: Transaction log filling up memory space Reply Contact BACKUP LOG [Your DataBase] WITH NO_LOGUSE [Your DataBase] GO DBCC SHRINKFILE ('Logical Log File Name', 20) --20 equals size of the log file after shrink and is in MB GO I would make sure this is done with a full backup otherwise you will not be able to roll back any transaction after you shrink the logs.

• 11-17-2008 5:44 PM

  In reply to

  gw Joined on 11-17-2008 Posts 4	Re: Transaction log filling up memory space Reply Contact  You should set up a maintenance plan on your SQL server to keep this log from getting too big.