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
What is an SQL backup?
What is the purpose of a SQL backup?
Why should you create an SQL backup and how?
SQL Server Backup – introduction
What is an SQL Server backup?
Why should you create an SQL Server backup?
How do you create a SQL Server backup?
Learn SQL #2 : How is data stored in a database?
Now that we know how the database system works, and how data is retrieved from the database, it would be time to understand how is data stored in a database.
Inside a database, data is stored into …
Backup the Transaction Log When the Database is Damaged
This post will address the issue of backing up the Transaction Log in the unfortunate eventuality when your SQL Server Database is damaged.
We will offer details regarding how you can do your Transaction Log backup with either T-SQL queries or by using the graphical interface of SSMS (SQL Server Management Studio) in a step-by-step example.
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, resulting in all of the data being destroyed.