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:-
- Open SQL server management studio.
- Expand database tab > Select Your database which you want to backup.
- Right click on that database > Go to task > Click on backup
- New window will open > Select database > Backup type >Destination(where to backup).
- Click on OK.