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

image-1.jpg
 
 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

image-2.jpg
 
 Click OK

image-3.jpg
 
 Using T-SQL
 

 Right down below query in query window.

image-4.jpg
 
X

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

Start Learning Now