|
|
 |
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 - Open the Microsoft SQL Server Management Studio application.
- Right-click the Simplify database and select Properties
- Open the Options page
- In the middle you will see Recovery Model, change it to Simple and click OK.
- 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 - Open the Enterprise Manager application for SQL 2000.
- Right-click the Simplify database and select Properties
- Open the Options page.
- In the middle you will see Recovery Model, change it to Simple and click OK.
- Try Shrinking the database from the Enterprise Manager. Right-click the Simplify database, select Taks, select Shrink. Execute the Shrink function.
|
|
|
|
|