Steps to create backup file of SQL server database


Staff member
You can follow below steps:
  • Go to Enterprise Manager and expand all SQL server databases.
  • Now click on particular database and right click on it.
  • Now you want to select “All Tasks” and click on “Backup Database”.
  • You have to select “Database-complete” to take complete backup.
  • Now click on “Add” button.
  • Now you will get the Name field, here you have to enter name of the backup file and click on “OK”.
Again you will get “OK” button you have to click on it to take backup.