microsoft visual studio 2008 enu product family chart

Under Recovery Completion State, select Leave database operational.Under Subset, select Torn Page Repair – Online.Confirm that Automatic Selection is selected.

On the Source tab, use the Restore By Tree view to find and select the database.Perform an Online Torn Page Repair Restore of the database as follows:.(Optional) Perform a Database Consistency Check (DBCC CheckDB) on the database to locate any additional damaged pages beyond the one already reported.Change to Full Recovery Model, if the database is using the Simple Recovery Model.Note: Do NOT take the database offline before you start this procedure. This will allow you to bring a database which is slightly damaged back into service quickly. In addition to torn page detection and isolation, SQL 2005 also introduces the ability to perform a Restore in which only those data pages which are damaged are overwritten. At any point in time, the current list of known damaged pages can be found in the table of system database. Microsoft SQL Server 2000, 2005, 2008, and 2012 have the ability to detect when the data in the database has been damaged, and isolate the damage at the data page level. Restoring Microsoft SQL Server Databases › Perform an Online Torn Page Restore Using Microsoft SQL Server 2000, 2005, 2008, or 2012 Enterprise, Data Center, or Developer Editions Perform an Online Torn Page Restore Using Microsoft SQL Server 2000, 2005, 2008, or 2012 Enterprise, Data Center, or Developer Editions

Microsoft visual studio 2008 enu product family chart