Post reply

if Server got crashed

  • November 13, 2007 at 4:55 am

    #119388

    if server got crashed suddenly how can u get the whole databse back? what u ll do?

  • November 13, 2007 at 5:12 am

    #750585

    Hi,

    I assume that the drive fails.

    If you have to install all the environment (install sql server, restore the master, msdb eventually distribution), then you have at the end, restore the backups of production databases.

    If your data and log files are on another drive, then just attach them.

    Regards

    ahmed

  • November 13, 2007 at 5:15 am

    #750589

    There are High availability solutions available in SQL, use any one of these solution to handle such DR situations. These business critical solutions, i.e some of the data may not be critical even if they lost and some of the data may be high criticality etc. Refer the below link for the same for the HA solutions and try any one.

    http://www.microsoft.com/learning/syllabi/en-us/2788afinal.mspx

    Regards..Vidhya Sagar
    SQL-Articles

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

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