Othello Support Centre - Caring for our Customers 24/7/365

Login / Register

User

Pass



Forget pass?

Search KnowledgeBase

 

KnowledgeBase

Main > OthelloServer.net - Dedicated Servers & VPS (Virtual Private Servers) > Un-Managed Dedicated Server Solutions
Minimize Text   Default    Enlarge Text
 

How do I change an SQL Server DB to Simple Backups


Print
Save to list
E-mail
Subscribe
Created 2009-03-12
Modified 2010-06-28
Views 665
Author Chris Burton
  1. Log in to remote desktop to SQL Server (win2.dc-servers.com)
  2. Start Enterprise Manager
  3. Expand SQL Server Group and Local Instance
  4. Expand Databases Folder tab
  5. Locate and right click the DB and select "Properties"
  6. Click "Options"
  7. Under "Recovery" the drop list labelled "Model" change from "Full" to "Simple"
  8. To make sure DB is back on line ASAP click "Transaction Log" tab
  9. 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"
  10. Click "OK"




Related Articles
I didnt get your welcome email - where has my signup email gone ?
If you cannot find the initial emails sent in your mail inbox, please check your “Spam” or Bulk mail folders for the email. Make sure you add...
How do I publish my site with FrontPage to a Windows Plesk Server?
Publishing your site with FrontPage Open FrontPage 2000 and from the File menu select "Open Web". Select the local folder containing your web...
How to enabled error log (Linux error_log)
1. Log on to control panel 2. In main menu bar at top under "Domain Settings" click "Domain Info" 3. If applicable select the relevant domain name...
 

 

Powered by: SupportTrio