Execute the BACKUP DATABASE statement to create the full database backup, specifying:
The name of the database to back up.
The backup device where the full database backup is written.
The basic Transact-SQL syntax for a full database backup is:
BACKUP DATABASE databasename
TO backup_device [ ,...n ]
[ WITH with_options [ ,...o ] ] ;
For restore
RESTORE DATABASE databasename
FROM Restore_device [ ,...n ];
Example
BACKUP DATABASE MyDB TO DISK='C:/MyDBBackup.bak';
RESTORE DATABASE MyDB FROM DISK='C:/MyDBBackup.bak';