Setting SQL Server Default Locations

How to set the default locations for backups, data files, and log files in SQL Server.

Backup Types

Statistical Sampling for Verifying Database Backups

A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.

Backup\ Restore completion Status.

Backup SQL Server to Amazon S3 with CloudBerry Backup

In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.

Backups

Database restore commands

Full backup Scenario

Backup or Restore progess

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.

Corruption Recovery Tips, Database Shrinkage Advice and More

Question: My backup strategy is a daily full backup at 1 a.m. and a log backup every hour. A DBCC CHECKDB also runs every day at 4 a.m. If I get to work at 8 a.m. and discover that the nighttime consistency checks found extensive corruption, how can I recover without losing a lot of data?