Selecting a SQL Server recovery model
Your SQL Server offers three recovery models for each database: full recovery, simple recovery and bulk-logged recovery. These determine how much data loss is acceptable in case of a failure, along with what types of backup and restore functions are allowed. Find out which option will suit you best when you are attempting to select a SQL Server recovery model.
Tips for scheduling and testing SQL Server backups
These tips for scheduling and testing SQL Server backups will help guide you on the path to a successful restore. Also, find out how to schedule backups in SQL Server via the SQL Server Agent and in SQL Server Express using Windows Task Scheduler.
Best practices for SQL Server backup maintenance
Removing backup history from the msdb database and reducing its size are just two of manybest practices for improving SQL Server performance with backup maintenance.
Restore basics: How to restore using T-SQL commands
SQL Server Enterprise Manager may be a quick and easy way to run backups and restores, but T-SQL commands offer much greater flexibility. Find out how to script your SQL Server backups or restores with T-SQL.
Restoring a database from another SQL Server