SQL Server Full Backups using T-SQL and SSMS

In this blog, covers the basics of full backups in SQL Server.

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.