How to create a Full Backup in SQL server

The full backups in SQL server are the complete backup of a database. Generally, in the SQL server, if backups are into consideration, then it comes to the point of full backups. Since it is a full backup for the entire database, there is a large amount of space required if the database consists of a lot more data and transactions. The three major types of backups are full, differential, and transaction log. While taking full backups, even some portion of the transaction logs is created. 

T-SQL Command to take transaction log backup:

BACKUP DATABASE [SQL_TEST] TO DISK = N'C:\SQLArena\LOG\SQL_TEST.bak'
STATS = 10

Steps to follow in SQL Server Management Studio graphic user interface:

1.  Right-click on the “database” name
2.  Click the option “Tasks”
3.  A new window pops with a drop-down to select “Full”
4.  Select the “Full” option with a specific disk under the option “Back up to”
5.  Click “OK” to take the full backup

The screenshot for the same is mentioned below:


0 comments: