SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Back Up a Database Databases can be backed up in SQL Server 2008 using full, differential, transaction log, filegroup, file, or copy-only backups. The backup types available will depend on the recovery model used and whether the data is flagged as read-only data or not. User databases should be backed up on a regular basis.

Back Up System Databases The system databases include master, model, and MSDB. The system databases should be backed up either on a schedule or any time they are modified. Because the databases can be modified daily through new job or object creation, the best practice is to back up the system databases on a schedule.

Restoring a Database User databases can be restored while the SQL Server service is running ...