SQL Server: How to backup a database

You can backup SQL database from backup tool or run below script to backup

USE Northwind;
GO  
BACKUP DATABASE Northwind
TO DISK = 'D:\SQLServerBackups\Northwind.bak'
   WITH FORMAT,
      MEDIANAME = 'D_SQLServerBackups',
      NAME = 'Full Backup of Northwind';
GO

VIDEO TUTORIALS