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.
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.
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.
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).
Thanks for this interesting SQL article.
cud anyone say me where the datas get stored after backup & where after restore