Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Database Recovery Advisor in SQL Server 2012 Expand / Collapse
Author
Message
Posted Sunday, June 10, 2012 3:49 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 8:55 PM
Points: 172, Visits: 571
Comments posted to this topic are about the item The Database Recovery Advisor in SQL Server 2012


Post #1313623
Posted Monday, June 11, 2012 1:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, December 20, 2014 8:56 AM
Points: 6,748, Visits: 8,545
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


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1313697
Posted Monday, June 11, 2012 6:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:43 AM
Points: 358, Visits: 1,067
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
Posted Monday, June 11, 2012 3:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 12:43 PM
Points: 18, Visits: 91
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
Posted Friday, June 15, 2012 1:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 5, 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
Posted Thursday, August 2, 2012 2:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 7:12 AM
Points: 2,462, Visits: 1,067
Good and informative article.

Thanks

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1339015
Posted Monday, March 24, 2014 1:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 1:09 AM
Points: 33, Visits: 54
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
Post #1553887
Posted Wednesday, December 3, 2014 7:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 7:28 AM
Points: 1, Visits: 0
there is a lot of info on this link http://www.techrepublic.com/forums/questions/it-seems-our-sql-database-is-corrupted/
Post #1641098
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse