SQL Server Research Library

Powered by Bitpipe.com


Recovery models available in SQL Server include full-recovery, bulk-log recovery and simple recovery. In this podcast, SQL Server Backup and Recovery expert Greg Robidoux describes each of the three models. Robidoux, president of Edgewood Solutions, will guide you toward making the right recovery model choice for your SQL Server environment.

Once you've determined the type of information being stored in your transaction logs and decided the appropriate recovery model you'll need to choose a backup processing method. Based on the applications being run, backup options for your SQL Server recovery model are:

  • Full backups,
  • Transaction log backups
  • and/or differential backups.
Robidoux will explain each backup type and point you in the right direction to use either one or a combination of backups for your SQL Server.


Bitpipe Definitions: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Other

What's Popular at Bitpipe? Daily Top 50 Reports | Daily Top 100 Topics | Popular Report Topics

SQL Server Research Library Copyright © 1998-2014 Bitpipe, Inc. All Rights Reserved.

Designated trademarks and brands are the property of their respective owners.

Use of this web site constitutes acceptance of the Bitpipe Terms and Conditions and Privacy Policy.