Introduction

In this article, we will learn a simple tip to take multiple backup files of one Database. Sometime we may need more than one copy of a backup file in different file location and we can achieve that in two ways, either using T-SQL Query or using SSMS.

T-SQL Statement

1 - BACKUP DATABASE [PracticalWorks] TO

2 - DISK=N'D:\DBBackup\BackupCopy1.bak',

3 - DISK=N'D:\DBBackup\BackupCopy2.bak'

I have a database called PracticalWorks, and by writing Multiple DISK locations in the Backup T-SQL query, we can take multiple backup files of one Database.

#sql server #sql #ssms #t-sql