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.

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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

WordPress.com.

Up ↑

%d bloggers like this: