When backing up your SQL Server database, you have the option of taking transaction log backups. These are quick, small backups containing a sequence of all your database’s changes. Transaction log backups are mightily useful for point-in-time recovery.
database
SQL Server Backup Permissions
Backup permissions: This post will take you through the list of backup permissions a user needs to have in order to be allowed to make the most basic backup operation.
We will also explain what are some of the most advanced options for backing up databases and how you can give these privileges as well to some of your most trusted users.
SQL backup – basic introduction

SQL Server Backup – introduction
What is a SQL Server backup?
Why should you create a SQL Server backup?
How do you create a SQL Server backup?
Learn SQL #2 : How is data stored in a database?
Backup the Transaction Log When the Database is Damaged

Database stuck in RESTORING state
Have you ever tried to restore your database, but while doing so the operation is stuck in RESTORING state?
If the following steps are similar to what you did, then you can find the answer at the end of this article:
SQL Server Backup and Restore
In order to understand the importance of SQL Server backup and restore, imagine a situation in which one of your colleagues creates a SQL statement without a WHERE clause and executes it. The result of this is all the data is wiped off.