Categories
Sql Server

How To Backup Your SQL Server Database

How To Backup Your SQL Server Database

To keep your database safe, we have to take backup of our databases.Their are several type of backup (Full,differential,Transaction log).

Full Backup:- A Full database backup creates a stand-alone image of the entire database. A  full database backup is self-dependent and may be restored to either the  same or a new database on the same or a different server. This provides plenty  of flexibility at the time when this backup has to be restored. A Full  backup may be restored without the need for any other kind of backup.

Differential Backup:- A differential backup backs up only modified extents since the last full  backup.

Transaction log Backup:- An SQL Server database consists of two components: data file(s) and  transaction log file(s). A transaction log captures the modifications made to  the database. A simple transaction may place several records in the transaction  log. Each of these records is known as a log record and is assigned a unique  identification number known as the log sequence number (LSN).

Tsql:-

backup database yourdatabasename to disk 'c:\backup' with init

Through Sql-Server management studio:-

  1. Open SQL server management studio.
  2. Expand database tab > Select Your database which you want to backup.
  3. Right click on that database > Go to task > Click on backup
  4. New window will open > Select database > Backup type >Destination(where to backup).
  5. Click on OK.