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

When the creation and configuration of a Recovery Services vault is complete, discovering databases and configuring backup is a two-step process. During the backup configuration, if the SQL VM and its ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ruth Linehan explains how migrating ...

In the production version of SQL Server, I think it is common to configure periodic backups using maintenance plans. While it is possible to specify a shared folder as the destination for the BACKUP ...

One of the very mundane, but extremely valuable tasks that any DBA must perform is the backup and restore of databases. In this post, we’ll look at a sample script that can backup databases on a given ...

Because a compressed backup is smaller than an uncompressed backup of the same data, compressing a backup typically requires less device I/O and therefore usually increases backup speed significantly.

I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 seconds each time, but it is long enough that ...