Redmond Magazine

PowerShell-Based SQL Server Backups Revisited, Part 2

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

PowerShell Based SQL Server Backups Revisited, Part 1

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...
InfoWorld

Better SQL server backups

Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with ...
InfoWorld

Smooth and swift SQL Server backups

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...
GitHub

restore_from_backup_with_move.sql

Use this script to restore from a database backup while easily moving all files to specified folders per file type. The script must be run in SQLCMD mode. Don't forget to modify the SQLCMD variables ...
GitHub

backup_history_query.sql

WHEN (datediff(millisecond, msdb.dbo.backupset.backup_start_date, msdb.dbo.backupset.backup_finish_date) / 1000.00) < 60 THEN left('Duration: ' + convert(VARCHAR(20 ...
TechRepublic

Three recovery models for backing up your SQL Server

Backing up SQL Server is a standard practice, but knowing which recovery model to use can be confusing. Use these tips to get started with your backup strategy. By Ed Martin With SQL Server 2000, ...