Is there a way to use a SQL 2005 Maintenance Plan to do a scheduled back up of the databases to a network share? The only way I can seem to make it work is to backup to the local C drive, and I'm ...

PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system 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 ...

As a DBA, establishing a reasonable backup schedule for your databases can be a challenging project. It requires you to balance two competing demands: the need to take image copy backups frequently ...

“SQL Object Level Recovery Native is a simple tool that strengthens backup options throughout the enterprise,” says Colin Millerchip, Red Gate’s product manager for backup products.

NCS allows you to take backups with LiteSpeed using native SQL Server syntax, so you don’t have to alter your current routines. I can’t tell you how much this sped up my implementation.

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