Tag Archives: database

Why Transaction Log backups are important

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. Continue reading Why Transaction Log backups are important

SQL Server Backup Permissions

backup permissionsBackup 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.

Continue reading SQL Server Backup Permissions

Backup the Transaction Log When the Database is Damaged

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. Continue reading Backup the Transaction Log When the Database is Damaged