Backup and Restore of MS SQL Server database using EMS

1) Right click at the project name and select the Tasksà Backup database.

2)click next and next

3) now click at ADD ITEM.

Create a folder on d: of server and select this folder.

Next and then FINISH

Restoring Database in EMS:

1) right click at the Databse in EMs and select in tasks, Restore database

2)      select defaults and then in next screen select the backup file 

4) In this screen click at CLEAR and it will remove all the connections to DB and then click Finish. Database will be restored. Check by connecting again.

5) Each time you do a backup remember to delete the file you made last time. Or give any new name to new backup.