Skip to main content

Full Backup database from Management studio in SQL server

I want to write here some general activity for everyone who are worked with SQL Server, even they are database developer or DBA. I know everyone know for the database backup and they are performing it as well. Below are the whole demonstration of to do full database backup. I hope you already aware of the database backup types.

1. Right click on the database which need to backup. You can view on from the screen following,

2. Go on the Task--> Backup and go ahead with click on it which will also ask for type of the database backup. Screen will appear as like following

3. Then need to select the disk path or tape to save the database backup as following,

4. After selecting path click on OK to complete the database backup process.
You can also select database backup option like Append to existing backup or overwrite it, verify backup when finished etc.


  1. I find the method displayed for the data recovery very useful. It has solved my problem very effectively and now i feel much more relaxed than before.

  2. Nice Post.


    MLM Developers India

  3. hi.. really the Information u provided is really a informative one and you have post it in attractive ways

    Max3logic IT solution Pvt.Ltd

  4. Mlm Software in Noida

    ARIES TECH SOFT PVT LTD provides you with the best MLM software in Noida binary as wel as matrix form.MLM Software is very important and critical to your business success.

    MLM Software in Noida which is really a life line of any MLM company.
    For further information visit us at

    Thank You,Very Nice


Post a Comment