Partial Backup and Restore

Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.

Database Restore

How to Kill a Company in One Step or Save it in Three

The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.

TRUNCATE TABLE and ROLLBACK TRAN

Backing Up a SQL Server Database Directly Onto a Remote Server

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy

7 Preventable Backup Errors

The loss of a company's data is often enough to put the company out of business; and yet backup errors are generally avoidable with the application of common sense rather than deep technical knowledge. Grant digs into memories of his long experience of giving forum advice, to come up with the most easily preventable backup errors.

What’s in YOUR Recovery Plan?

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why.

ITX_SP_BAK

Creates a single sql install file for all stored procs in a database.

SP_BAK

Creates a separate file for each sp on your server's c: drive.

SQL Server Restore Tutorial

What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.