Knowledge Base Home  l  Web Hosting  l  Softwares  l  WHM  l 

The steps to set up the MSSQL 2000 data base Back UP
Category : Web Hosting

This article will show you how to create a SQL maintenance plan to backup all the MSSQL database(s) on your dedicated server.

With the creation of a SQL maintenance plan, your databases will be backed up daily.

Follow these steps to create a SQL backup plan for MSSQL 2000:

Enterprise Manager
1. From your dedicated server, open up SQL Server Enterprise Manager (Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager).

2. Login with Windows authentication.

Management
3. Expand the Local Windows database server and double click on 'Management.'

4. Verify that the SQL Server Agent is turned on (right click on SQL Server Agent and click on Start).

5. Right click on Database Maintenance Plans and click 'New Maintenance Plan...'

Wizard
6. Choose the All databases radio button

7. Click next on 'Update Data Optimization Information' and 'Database Integrity Check.'

Specify the Database Backup Plan

8. Make sure the 'Back up the database as part of the maintenance plan' and 'Verify the integrity…' box are checked. Leave the radio button marked on Disk.

9. Click on the 'Change…' that is at the bottom right.

Job Schedule
10. Under occurs, choose Daily, under Daily leave it at 1 day(s), under Daily Frequency choose Occurs once at 10PM (can be changed to what you want), leave the Duration at No end date. Click OK and click Next.

Specify Backup Disk Directory
11. Choose the location of where you want your databases backed up to (make sure to create a folder) or you can 'Use the default backup directory'. Mark the 'Remove files older than:' and set it to 1 Week(s). Leave the backup file extension as BAK.

Finish
12. Click next on 'Specify the Transaction Log Backup Plan', 'Reports to Generate', 'Maintenance Plan History', change the Plan name to DB backups and click on Finish.

This will create a SQL Maintenance plan to backup your MSSQL 2000 database(s).


Growing Business Circle™
Click here for more ....
      
     Category
 
Web Hosting  l   Softwares  l   WHM  l  
  Most Recent Articles

» Send the mail using the SMTP authentication through php

» This message is to inform you that the account xxxxxx has user id 0 (root privs)

» Warning: mail() [function.mail]: "sendmail_from" not set in php.ini or custom "From:" header missing in D:\INETPUB\VHOSTS

» call-time-pass-by-reference error after updating the php to php 5.4

» spamming through exim, Exim is down , /var drive is full

      Popular Articles

» Warning: mail() [function.mail]: "sendmail_from" not set in php.ini or custom "From:" header missing in D:\INETPUB\VHOSTS

» call-time-pass-by-reference error after updating the php to php 5.4

» spamming through exim, Exim is down , /var drive is full

» Free back up software for windows (Windows 2003 server, Windows Xp)

» How to create new email id under the HELM control panel – AdsinMedia Hosting

» How to configure the mail id in microsoft outlook express

» How to delete the mail from outgoing folder of Microsoft outlook

» SMTP error Codes

» How can I use the new server while I change the DNS server of a domain.

» Spamd spamassassin shutting down automatically





Copyright © 2014 Adsin Technologies. All rights reserved. Powered by business adsleaf