Backup best practices — a shortcut

We already know that backups are important for securing your databases from data loss. 
We also have an article about best practices regarding backups, but the article is quite detailed and if you want to take a shortcut and take care of the essentials, then you’ve found it here.

Read more

Backup best practices – a shortlist

backup best practices
If you’re here, then there’s a high chance you already know the importance of a good backup and what they mean to a serious business.
Taking care of database backups is an important and very sensitive job.
This is why we tried to make a shortlist of some backup best practices that you should be aware of when you’re either doing backups or you’re trying to restore them, in order to be covered for any of the common and slightly uncommon situations involving backups.

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:
sql-server-logo

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