1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

The simple recovery model is just that: simple. In this approach, SQL Server maintains only a minimal amount of information in the transaction log. SQL Server truncates the transaction log each time the database reaches a transaction checkpoint, leaving no log entries for disaster recovery purposes.

In databases using the simple recovery model, you may restore full or differential backups only.

Read more about the simple recovery model and other options in SQL Server Recovery Models.
Comments
October 3, 2008 at 7:15 am
(1) zlatan24 says:

I heard about not bad application-sql server recovery, this tool can process huge databases, their file size can reach 16 TB, recovery Toolbox for SQL Server supports data extraction via the local area network, you can save recovered data as SQL scripts, it is also possible to split data into files of any size, this tool can save extracted information directly to the SQL server. It allow to recovery SQL Server faster, is compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista.

February 10, 2009 at 5:14 am
(2) mutu26 says:

There is a not bad tool which is able works with sql files,as is known tool is free-sql server recovery tool,program repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts, it is also possible to split data into files of any size,compatible with all supported versions of Microsoft Windows, such as Windows 98, Windows Me, Windows NT 4.0, Windows 2000, Windows XP, Windows XP SP2, Windows 2003 Server, Windows Vista,tool supports the following database formats: Microsoft SQL Server 7.0, 2000, 2005,also can repair .mdf files of Microsoft SQL Server 2005, repair mdf file of Microsoft SQL Server 2005 (64-bit).

December 19, 2009 at 7:34 am
(3) hagel IT-Service Hamburg says:

Thanks for this interesting SQL article.

November 10, 2010 at 11:18 pm
(4) debashisdebata says:

cud anyone say me where the datas get stored after backup & where after restore

August 23, 2012 at 6:54 am
(5) Ellios Robert says:

Thanks Mike for sharing this useful model. I successfully recover my damaged SQL server database with the help of this tool: SQL Server Recovery Software

Regards
Ellios

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.