- Log in to remote desktop to SQL Server (win2.dc-servers.com)
 - Start Enterprise Manager
 - Expand SQL Server Group and Local Instance
 - Expand Databases Folder tab
 - Locate and right click the DB and select "Properties"
 - Click "Options"
 - Under "Recovery" the drop list labelled "Model" change from "Full" to "Simple"
 - To make sure DB is back on line ASAP click "Transaction Log" tab
 - In the bottom right hand corner of the screen in the "Maximum file growth " area increase the quota or change it to "Unrestricted file growth"
 - Click "OK"
 
- 1 Users Found This Useful
 
Related Articles
Powered by WHMCompleteSolution
