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:
Post a Comment