The Database Recovery Advisor in SQL Server 2012

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Robert Pearl » The Database Recovery Advisor in SQL Server...

The Database Recovery Advisor in SQL Server 2012

Rate Topic

Display Mode

Topic Options

Author

Message

RSP

Posted Sunday, June 10, 2012 3:49 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:32 PM
Points: 172, Visits: 476

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

Post #1313623

ALZDBA

Posted Monday, June 11, 2012 1:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

Nice article, Robert. Cool

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

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

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

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

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1313697

Resender

Posted Monday, June 11, 2012 6:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 8:55 AM
Points: 289, Visits: 683

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.

Post #1313829

stevec 31012

Posted Monday, June 11, 2012 3:24 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 2:39 PM
Points: 16, Visits: 60

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.

Post #1314140

rodyroon

Posted Friday, June 15, 2012 1:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, July 05, 2012 12:33 AM
Points: 1, Visits: 2

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

Post #1316346

quackhandle1975

Posted Thursday, August 02, 2012 2:56 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:24 AM
Points: 1,610, Visits: 590

Good and informative article.

Thanks

qh

SQL 2K acts like a spoilt child - you need to coax it round with lollipops.

Post #1339015

« Prev Topic | Next Topic »

Permissions