After looking about the backups in SQL Server it is time to know about the Restore and Recovery in SQL Server. SQL Server supports three levels of Restoring data. They are 1. Complete Database Restore : This is the basic restore strategy. A complete database...
This is third article in the KNOW THE TRANSACTION LOG series. In Part 1 I explained about the Transaction Log File and its behaviour. In Part 2 I explained about the Recovery Models available in SQL Server 2005 which affects the behaviour of Transaction...
Having SQL Server as a Database Solution to your enterprise applications, you may have a little chance of losing your valuable data, due to some failures, as SQL Server 2005 is having a lot of features for High-Availability and Disaster Recoverability...