Post reply

Resotre Page - SQL 2005

  • March 15, 2010 at 2:19 pm

    #142066

    Hi..

    How can we restore the corrupted page alone from the backup in sql server 2005 version? kindly provide me the steps and tell me how we can recover the page without any data lose from this problem.

    Thanks in advance.

  • March 15, 2010 at 3:20 pm

    #1134104

    Database must be in full or bulk-logged recovery model and there must be log backups covering the period from the full backup that you're using up to present.

    There's a good coverage of how to do this in Books Online

    http://msdn.microsoft.com/en-us/library/ms175168%28SQL.90%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply