locked
hai RRS feed

  • Question

  •  1) If our databases crashed how do we restore it and plz pendown the steps involved in the process?

      2) what are the performance issues we face in  real time?

    Tuesday, March 5, 2013 6:18 AM

Answers

All replies

  • Hello,

    1) See TechNet Restore a Database Backup (SQL Server Management Studio) and Restore a Database to a New Location (SQL Server) for step-by-step instructions.

    2) I don't know, which performance issues you are facing currently?

    And may could you please use a different subject then always "hai"; it's not helpful.


    Olaf Helper

    Blog Xing

    • Marked as answer by Eileen Zhao Thursday, March 14, 2013 8:49 AM
    Tuesday, March 5, 2013 7:16 AM
  • haiah
    Tuesday, July 28, 2020 3:43 PM
  • in a full database restore, there are 3 phases

    a) allocation of space for the file (this should be fast, there is no initialization depending on the version?)

    b) copy the data file pages

    c) replay the logs

    In the second phase, you will see disk read from the source, and disk write to the destination

    in the third phase, there is no IO from the backup source.

    When you backed up the database, there was page information for each data and log file.

    One thing to watch for in the backup is a lot of pages in the log file.

    If the log pages is huge, the restore would have to replay all of this


    jchang

    Tuesday, July 28, 2020 3:59 PM