Nov 08
Backup and Recovery (SQL Server)

Over the course of several years I have refined the backup and recovery strategies for SQL Server to give me the best cost and recovery model that achieves full recovery in the event of a disaster for SharePoint 2010 and SQL Server 2008R2 environment.

  • SQL server
    • Use full or simple recovery
      • Full is the safest since it backups the last transaction
      • The problem is that it requires a lot of storage
    • Always use Full for content DB and any other high need DB
      • Don't use full for search for example, use simple
    • You will want to divide your data volumes and separate out the data volumes and any other service components of this for recovery.
      • Data volume, log volume,

Comments

There are no comments for this post.

 ‭(Hidden)‬ Blog Tools