Backup Strategies briefly

• Combine different backup types to create a backup strategy.
• Do not backup tempdb.
• Unless you plan to change its contents, do not back up the model database.
• Use the Full Backup simple mode strategy only in development, read only, stage or system databases.
• Schedule the Log backup before the Full backup
• Use the Log & Full backup strategy in 8x5 databases where you can afford to lose up to one day of work.
• Consider the use of the Full & Log backup strategy in 8x5 databases, and non-volatile 24x7 databases.
• Use the Full, Differential and Log strategy in volatile 24x7 databases, when the value or your data requires very frequent log backups, and in nonpartitioned Data marts.
• Consider the use of a Full - File/Filegroup – Log Backup strategy in Very Large Databases (VLDB) or partitioned Data marts/Data warehouses.
• Schedule Backup Operations When Database Activity Is Low.
• Back up first to disk, whenever possible. Consider using a File Server to store the backups.
• When using a File server to store backups, consider using a private LAN trunk to avoid general network congestion.
• Do not use the same physical disk that hold the database files or Log files for backup purposes.