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

We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been running ...

Using compression with SSMS is just as easy. Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The ...

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

With Extended Support for SQL Server 2008 and SQL Server 2008 R2 ending in July 2019, to be followed six months later by the end of Extended Support for Windows Server 2008 and 2008 R2 in January 2020 ...

Backup Compression is also new in SQL Server 2008. Although the compression itself works well, the feature has too many limitations (including supporting only Enterprise Edition) to be effective in an ...