Backup Database using T-SQL Statements


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.

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


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.

One thought on “Backup Database using T-SQL Statements

Add yours

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with

Up ↑

%d bloggers like this: