Backup and Restore in SQL Server – SQL Server Tutorial

Backup and Restore in SQL Server :

Backup in SQL Server:-

To take backup of the database

  • Select the database
  • Right click
  • Select task
  • Select backup.
  • Select the database : MYDB
  • Backup :  Full, Differential, Transaction log.
  • Full → complete backup
  • Deferential means backup since backup. Since last backup what new objects are copied in backup.
  • Transaction log  : only transactions are copied backup copy.
  • Backup component : database
  • Backup set will  expire:  After :2 days.

Restoring the Database in SQL Server  :-

To restore the database:

  • Select database 
  •  Right click
  • Restore database option
  • To database : DB15
  • form device  → Path
  • Goto option → change the filename (or) path.

Leave a Reply

Your email address will not be published. Required fields are marked *