Backup Database using T-SQL Statements

Introduction

In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements.

We need to use BACKUP DATABASE statement to create full database backup, along with the name of Database and device to store the backup file.

Syntax

BACKUP DATABASE database_name 
TO device_name

Example

BACKUP DATABASE PracticalWorks
TO DISK = 'd:\PracticalWorks_DB.bak'

Conclusion

With a simple T-SQL Statement BACKUP DATABASE , we can backup the full database. I hope this tip was very informative. Please share your feedback in the comment section.