How to Do a Basic Backup in SQL Server 2005

Backing up a SQL Server 2005 Database is easy now.

Steps

  1. Image titled Do a Basic Backup in SQL Server 2005 Step 1
    1
    Open Microsoft Sql Server Management Studio.
  2. Image titled Do a Basic Backup in SQL Server 2005 Step 2
    2
    Choose the database in object explorer to backup and right click.
  3. Image titled Do a Basic Backup in SQL Server 2005 Step 3
    3
    Choose Tasks->Backups.
  4. Image titled Do a Basic Backup in SQL Server 2005 Step 4
    4
    Remove old backup file if any in destination.
  5. Image titled Do a Basic Backup in SQL Server 2005 Step 5
    5
    Add new backup file name by pressing, Add button.
  6. Image titled Do a Basic Backup in SQL Server 2005 Step 6
    6
    In Select Backup Destination Window chose file Name radio button and click on folder selection box. Or you can type a valid pathname and a filename with .bak extension Eg:
    • DBSEP2008.Bak
  7. Image titled Do a Basic Backup in SQL Server 2005 Step 7
    7
    Press OK.
  8. Image titled Do a Basic Backup in SQL Server 2005 Step 8
    8
    Now copy this backup file to some other computer or media for more safety.

Article Info

Categories: Software