Friday, 11 November 2016

How to take Full Back up of a Database Using SQL Server Management Studio.docx

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 accessed user.
Below are the steps 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 instance of SQL server, expand Database and select database and right click on the same then click on backup under the task options.
  • Once you will click on the backup, it will take us backup wizard, we need to add destination path by clicking on add button. And add 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 check technet link:
See below:
  • Once all done click on ok, backup will get start and will save at the given path.

Thanks ☺

1 comment:

  1. Hi,
    Greate article with ease explanation for taking backup of single database. Well i have written a stored procedure which takes backup of full database in SQL Server. Hope you and your reader find it usefull here's the link