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.