Backing up a database (Model Manager)
1. Right-click the database you want to back up, and select Perform Task.. and then click Backup.
2. From the Task list, select Backup.
3. To start the backup immediately, select Now, and then click START.
To schedule the backup for a later date or time, select Later, select the Start Date and Start Time, and then click Schedule.
4. On the Truncate Log After Backup dialog, click Yes if you want to truncate the SQL Database log after backup, else click No.
5. After the backup is complete, the Executed Tasks section is updated with the backup details. You can click the 
button to download the .bak file to your computer.
button to download the .bak file to your computer.