1. Computing

Discuss in my forum

In the event of a database failure, you have the most flexibility restoring databases using the full recovery model. In addition to preserving data modifications stored in the transaction log, the full recovery model allows you to restore a database to a specific point in time. For example, if an erroneous modification corrupted your data at 2:36AM on Monday, you could use SQL Serverís point-in-time restore to roll your database back to 2:35AM, wiping out the effects of the error.

Read more about SQL Server Recovery Models.
Comments
November 12, 2009 at 4:28 am
(1) Colin Dolly says:

Great Tips once my sql database has been corrupted that time i have used SQL Recovery software named as Stellar Phoenix SQL Recovery Software its great software to repair and recover your corrupted sql database.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
  1. About.com
  2. Computing
  3. Databases

©2014 About.com. All rights reserved.