Page History
...
Refer to the Microsoft Technet article Backup (Transact-SQL) for an overview of backup operations in SQL Server. All databases include a configured recovery model, which dictates the type of backup and restore operations that are available. In all cases, perform a full backup of any database that has never experienced a backup. In the simple recovery model, perform regular, full backups on an ongoing basis while using the full or bulk-logged recovery model. In addition, add regular log and differential backups to the full backup schedule.
| Excerpt |
|---|
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |