How To Configure Backup Compression

backup6Now 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.

Read more

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.

Read more

Windows Azure SQL Database Backup – TIPS

windows azure SqlBakHaving 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.

Read more

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.

Read more

SQL Server log file is too big – resolved!

If your SQL Server transaction log (LDF) file is too big – you are doing something wrong. As technet puts it:

Typically, truncation occurs automatically under the simple recovery model when database is backed up and under the full recovery model when the transaction log is backed up. However, truncation can be delayed by a number of factors. For more information, seeĀ Factors That Can Delay Log Truncation.

Read more