Screenshot of SQL Server Backup

1 . SQL Server Backup manager window


 

2 . Select database for backup job


3 . Backup device for the job, you may specify two devices for a backup job.

 
 

4 . Verify backup after job.

 

5 . Compress and encrypt backup

 

6 . Email notify

 

7 . Delete expired backup after job.

 

 


8 . Restore database

 


9 . Transaction log shipping. (Copy database between servers)

 


10 . Schedule backup.

 

To see how to backup or restore SQL Server Database , please visit Walkthroughs