How To Take Full Back Up Of A Database Using SQL Server Management Studio

Today, we are writing about how to take full backup of a database, using SQL server Management studio. Make sure you have database admin and backup rights to login and access the user.

The steps are given below to configure the same,

  • Open SSMS (SQL Server Management Studio) and connect the instance from where you want to back up the database.



  • After connecting an instance of SQL Server, expand the database and select database. Right click on the same and then click on backup under the task options.



  • Once you will click on the backup, it will take us to backup wizard and we need to add the destination path by clicking on add button. Add the path with .bak.
  • We can define the backup time also, from the backup options tab left side of backup wizard, currently we are selecting 0days to take immediate backup.

    For more information, click https://msdn.microsoft.com/en-IN/library/ms187510.aspx

    See below





  • Once you are all done, click OK. Backup will start and will save at the given path.