One simple way is backup by using T-SQL
Create a Full Database Backup using Transact- SQL or T-SQL to restore the database from .BAK file
- Type the BACKUP DATABASE statement which creates Full Database Backup using following specifications:
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK'
- Name of Database to backup
- Place where to write the Full Database backup
- The Syntax for full DB-backup is: