You are here:Home » SQL Server General » Full Backup database from Management studio in SQL server

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.