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
BACKUP DATABASE PracticalWorks 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.