SQL Server Full Backups using T-SQL and SSMS

In this blog, covers the basics of full backups in SQL Server. Data is critical and data cannot be lost. It's a complete copy of the database that includes backing up users and permissions as well as part of the transaction log permissions.
 Using SSMS

 Right click on the database name
 Select Tasks > Backup

 Select "Full" as the backup type
 Select "Disk" as the destination
 Click on "Add..." to add a backup file and type “D:\backup\testing.bak"
 Click "OK" to create the backup

 Click OK

 Using T-SQL

 Right down below query in query window.


Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now