Search
 
 
Contact Us:
US/Canada Toll Free:
(800) 582-5167

EMEA: +44 (0)1582 638800
Int'l: 1 (410) 715-4226


HIMSS 2012 iPad Giveaway Rules


Simplify database transaction log has maxed out available space on SQL Server

The Simplify database transactio log is not controlled by the Simplify Suite, rather by the SQL Server. However, these problems can be resolved by follow these steps:

SQL 2005 and 2008

  1. Open the Microsoft SQL Server Management Studio application.
  2. Right-click the Simplify database and select Properties
  3. Open the Options page
  4. In the middle you will see Recovery Model, change it to Simple and click OK.
  5. Try Shrinking the database from the Microsoft SQL Server Management Studio. Right-click the Simplify database, select Tasks, select Shrink. Execute the Shrink function.

SQL 2000

  1. Open the Enterprise Manager application for SQL 2000.
  2. Right-click the Simplify database and select Properties
  3. Open the Options page.
  4. In the middle you will see Recovery Model, change it to Simple and click OK.
  5. Try Shrinking the database from the Enterprise Manager. Right-click the Simplify database, select Taks, select Shrink. Execute the Shrink function.