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

Database backups and restores are key to developing a secure environment for users’ information. A trusted backup plan is a requirement for on-premise and cloud instances. SQL Server database backups ...

SQL Backup Pro 6 comes with a new backup compression mode and backup compression analyzer that the company claims can be used to analyze optimal compression levels. The company also said this version ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Soroosh Khodami discusses why we aren't ready ...

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

Redgate Software has announced that the latest version of SQL Backup Pro now includes automatic integration with Amazon Simple Storage Service (S3), making it easier for users to store their SQL ...

I have a server running SQL 2008. I am backing up the SQL databases using BackupAssist, which just uses the built in SQL backup tools to save the database and transaction logs as .bak files to a ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as ...