SQL Server database backup

A database backup is a copy of the SQL Server data. A backup is used to restore and recover the data after a failure or during database migration. A database backup can be stored on a backup device such as a disk or a URL.

Types of backups

  1. Full backup: Complete backup of the database, including the data and the transaction logs at the time of backup.
  2. Differential backup: A differential backup records only the data that has changed since the last complete or differential(partial) backup.
  3. Transaction Log backup: Backup of transaction logs.

Pre-requisite

  • MSSQL Server
  • SQL Server Management Studio (SSMS)

Create a full database backup

  • Connect to an instance of MS SQL Server database engine.
  • In the Object Explorer expand Databases.
  • Select and right-click on your database (HASURA), and then select Tasks > Back Up....

Select backup

  • In the Backup type, select Full from the drop-down list.

Perform at least one full backup before performing a differential or transaction log backup.

Configure backup

  • In the Destination section, select Add.

Select destination

  • You can accept the default location or select the 3 dots ... to modify the destination. Select OK or Cancel as appropriate.

Create backup

  • Select OK to initiate the database backup process.
  • Close the dialog box once the backup is completed.
Did you find this page helpful?
Start with GraphQL on Hasura for Free
  • ArrowBuild apps and APIs 10x faster
  • ArrowBuilt-in authorization and caching
  • Arrow8x more performant than hand-rolled APIs
Promo
footer illustration
Brand logo
© 2024 Hasura Inc. All rights reserved
Github
Titter
Discord
Facebook
Instagram
Youtube
Linkedin