arrow_upward

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to Backup MSSQL Database From SQL Server Management Studio?
#1
In order to take a backup MSSQL database, please follow the below steps:
Step-1: Connect to MSSQL Management studio.
Step-2: Once you are connected to Microsoft SQL Server Database Engine, at the left-hand side in Object Explorer pane, click the SQL server name to expand the server tree.
Step-3: Expand Databases and right-click on the database, select Tasks and click Backup. This will open up Backup-database window.
Step-4: In the Backup type list box select Full, for Backup component, click Database.
Step-5: Enter the name for the backup set or accept the suggested default backup set name.
Step-6: Enter Description of the backup set (optional).
Step-7: Choose the type of backup destination to Disk and click Add. Now select the destination where you want to store the database.
Step-8: Once you select the backup destination, click Ok.

Step-9: Make sure that your chosen backup destination is listed in destination box and click Ok.

Step-10: Navigate to backup destination and verify the backup file.

That’s it.
You can also refer to this URL.


Messages In This Thread


person_pin_circle Users browsing this thread: 1 Guest(s)
Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - Hyper Expert - Shadow Hosting - Bladenode - Hostlease - RackNerd - ReadyDedis - Limitless Hosting