The Database Recovery Advisor in SQL Server 2012

  • RSP

    SSCrazy

    Points: 2573

    Comments posted to this topic are about the item The Database Recovery Advisor in SQL Server 2012

  • Johan Bijnens

    SSC Guru

    Points: 134254

    Nice article, Robert. 😎

    Nice enhancement of the GUI. I didn't pay much attention to it, because I assemble my scripts using a script generation script 😉

    Johan


    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt ?

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me[/url] :alien: but most of the time this is me :hehe:

  • Resender

    SSCertifiable

    Points: 7285

    It was an interesting article to read, I agree that database recovery can be hard and this tool will be helpful.

    But I also get the impression that MS is dumbing down the processes needed to manage a database.

  • stevec 31012

    Valued Member

    Points: 74

    Of course, in order to recover this way, you have to ensure that the recovery model of a database is set to FULL, and you are taking regular Transaction Log backups throughout the day

    You dont need regular log backups in this case, transaction log backups are good if you lose that drive that has the ldf files (and providing your backups are on a different location)

    In your senario you can use last nights full database backup and the current live transaction log to restore to any point in time cover by that transaction log as long as the backup chain has not been broken.

  • rodyroon

    Valued Member

    Points: 70

    Repairing corrupt and damaged SQL Server database has never been so easy before. For excellent and accurate database recovery, use Kernel for SQL Recovery software that is not only easy to use but its interactive and user-friendly screens makes this tool a favorite among novice computer users as well. It is the most effective tool to deal with any corruption issues and retrieve MDF files along with their inaccessible data.

    For more please visit here....http://www.kerneldatarecovery.com/sql-recovery.html

    Thanks

    Rody Roon

  • quackhandle1975

    SSChampion

    Points: 10963

    Good and informative article.

    Thanks

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]
  • enriquemallon

    Ten Centuries

    Points: 1239

    Hi

    I want to share more efficient and authenticate way to recover SQL Server database. On using SQL database recovery software you can recover corrupt MDF file, NDF file with ease without running any T-SQL command. Read more:- http://www.sqlrepairtool.org

  • faustino.vitali

    SSC Journeyman

    Points: 93

    there is a lot of info on this link http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/[/url]

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

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