The Database Recovery Advisor in SQL Server 2012

Question

The Database Recovery Advisor in SQL Server 2012

RSP

SSCrazy

Points: 2614
More actions
June 10, 2012 at 3:49 pm

#257577

Comments posted to this topic are about the item The Database Recovery Advisor in SQL Server 2012
June 23, 2021 at 7:29 am

This was removed by the editor as SPAM

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

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

Johan Bijnens SSC Guru Points: 135255 More actions · Answer 1

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

Learn to play, play to learn !

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 but most of the time this is me

Resender SSCertifiable Points: 7443 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

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: 11055 More actions · Answer 5

Good and informative article.

Thanks

qh

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

enriquemallon Ten Centuries Points: 1239 More actions · Answer 6

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 More actions · Answer 7

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