SQL Server 2008 provides a feature, which, in my opinion, has been far overdue: backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool ...

Reston VA '” Continuing its streak of industry awards and achievements, AppAssure Software (www.appassure.com), a provider of innovative backup and disaster recovery software for Windows application ...

Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

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

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...