[Database][SQLServer] Backup - Full Database

Description

         Performing Backup - Full database in SQLServer .

How To.
1. Open SQLServer Management Studio
2. After you connect database , select database (highlight) that you want to backup.
3. Right click the database and select Tasks > Backup (see the picture below)

Right click on database

4. it will open a new form with many setting , here's the step :
      - Step-1 : look on the left corner , on page menu select "General"
      - Step-2 : Make sure you select right DB
      - Step-3 : Select backup type FULL
      - Step-4 : Give The sets of name (it will appear during restore database)
      - Step-5 : Set the expired to zero / 0 , it means "never expired"
      - Step-6 : Remove Current Save Path (by default the path is in current directory SQLServer).
      - Step-7 : Add new save path , don't forget add extention .BAK on the filename.
      - Step-8 : look again on the left corner , on page menu select "Options"

    for fast understanding you can see picture below

 Backup Option - General (SQLServer)

5. On page "Options" , look on the box picture below , the settings depend what you need.

    - Append to existing backup database , it usually use by the first time backup the database , if you have an existing database with same name, the data won't overwrite but will add.

    - Overwrite all exiting backup sets , it will overwrite all of data include all structure. the old data that overwrite will be lost.

   

 Backup Option - Options (SQLServer)

that's all , backup database - full on SQLServer