Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines. The Azure ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

I've been scratching my head about this for quite some time and can't quite figure it out. I have a share on Server1 (Windows 2008 R2) and Server2 (Windows 2012 R2) that I use to store SQL backups ...

One of the great new features of SQL Server 2008 is called Transparent Data Encryption. Data encryption was introduced into the Database Engine in SQL Server 2005, so why is 2008 so much better? Yes, ...

Pity the poor modern DBA, now that SQL Server gets attacked by some of the same scripts that PCs do. Pity the poor modern DBA who has to keep building Microsoft SQL Servers because some idiot vice ...

There’s some good news for IT managers deploying Windows Server 2008: Backup and Restore has been reworked in this edition to leverage the Volume Shadow Copy Service (VSS) and block-level transfers ...

I was looking a Red-Gate's SQL Backup program and was rather interested in the encryption options that the PRO version offered. It claims up to 256 bit encryption, but I was wondering how "secure" ...

What are the most common SQL VSS writer issues users encounter when backing up SQL databases with VSS-based backup software? The VSS writer error that seems to cause ...