Take Database backup in SQL Server

Introduction: 

In this article we will learn  how to take the backup of SQL server database manually through SQL command/query.

Description: Taking backup of database at regular interval is always recommended to secure data. Sometimes you need to take quick Sql server database backup. So you can use following single line SQL query to take Database backup.

Backup database [database name] to disk=’path where you want the file.bak’ 

e.g. In the query editor of the Sql Server type the following :

backup database MyDatabase to disk='d:\Mybak.bak' with stats=10

Note: If you want to copy the database over the network then you can also use UNC path. The syntax will be as:

 Backup database [database name] to disk=’\\servername\path.bak’