in

SQL Server Community Blogs

Voices of the SQL Server Community
All Tags » Recovery (RSS)

Browse by Tags

  • Know The Transaction Log – Part 4 - Restoring Data

    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 restore for a simple recovery model database...
    Posted to B Esakkiappan's SQL Thoughts (Weblog) by sureshbarathan on 04-22-2008

  • KNOW THE TRANSACTION LOG – PART- 3

    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 log file of the database. In this Part 3, I am...
    Posted to B Esakkiappan's SQL Thoughts (Weblog) by sureshbarathan on 04-22-2008

  • Data purity

    Reviewing DBCC CHECKDB syntax for SQL Server 2005, I found a [DATA_PURITY] option added to its syntax. This option enable the following checks on each column value of those datatypes: Unicode character - The data length should be a multiple of 2. Datetime - The days field should be between Jan 1 1753...
    Posted to My two cents (Weblog) by leo.pasta on 11-26-2007

  • Losing your Transaction log

    Technorati Tags: SQL Server , Recovery Some days ago, my boss got on my desk asking if I could take a look at one database that was not opening. That DB was in a virtual machine used for our sales presentations. For some reason, several files got corrupted in that VM, and between those was our beloved...
    Posted to My two cents (Weblog) by leo.pasta on 11-20-2007
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems