Last time, we discussed the different backup types available in SQL Server. Now, let's take a quick look at some best practices when it comes to configuring those backups. Although there is no one set ...

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

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

eWeek content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More A backup and recovery strategy should address both data ...

One configures SQL Server for high availability (HA) in anticipation of some event that will cause a critical application to go offline unexpectedly—a software glitch that causes an app to freeze or a ...

Backup is a key component of any good data protection strategy. But does the advent of virtualisation mean traditional backup can be replaced by new data protection methods, such as replication, ...