This is a step-by-step tutorial on how to backup the Tail of the Transaction Log using the graphical interface of SSMS.
In order to find more information about the Tail of the Transaction Log, please read our article, which offers more details regarding this type of backup, here.
Omelchenko Alexander
Tail-Log Backups
In this article, we will offer information about tail-log backups, a feature that is available for SQL Server versions 2005 and newer. This is a topic which you should be aware of if your backup and restore process for your SQL Server databases is using either the FULL or Bulk-Logged recovery model.
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.
How To Configure Backup Compression
Now that we have previously discussed about backup compression, it is time we offer details about how to configure compression for your backups.
Just as a short reminder, backup compression is a powerful feature offered by SQL Server (versions 2008 and newer) that allows you to shrink the amount of storage space used by your backup files while at the same time increasing the speed of recovery which goes hand in hand with lower CPU usage when restoring the database from your backup.
Backup Compression
Backup Compression is a feature of SQL Server versions 2008 and later (2008, 2008 R2, 2012) which offers you more benefits without any cost to your data or its integrity.
In spite of \having been through a data compression process, the compressed backup actually has a few advantages over regular backups.
Backup a table in SQL Server – How to
Unfortunately, there is no standard or specific feature to backup a table in SQL Server, but there are workarounds.
This can be a very common request from clients, as they might want to backup specific tables from their databases, and as there is no feature in SQL Server that offers this functionality out of the box, then we need to create our own way.
Windows Azure SQL Database Backup – TIPS
Having the possibility to backup your SQL Server databases to Windows’s cloud platform is very convenient, easy, and takes a great weight off your organization’s shoulders but there are a few things that improve this process.
Just by adopting a few good practices in your work with Azure you can improve the entire flow of backing up and restoring your databases.
Backup SQL Server databases to Windows Azure
There is good news for SQL Server DBAs and also for other users who are interested in backing up their data to safe and reliable cloud storage.
Microsoft has announced a couple of days ago several new ways of backing up and recovering SQL Server databases to their online cloud-based storage platform and infrastructure system, Windows Azure.
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.