- 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