For those legacy SQL Server 2008/R2 applications that remain critical, some form of high availability or disaster recovery protection will be required to preserve business continuity.

Managing System Performance SQL Server 2008 has a raft of new tools for improving and managing database performance.

SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices.

PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.