General Consultant Discussion

 View Only
  • 1.  SQL Server recovery. Long story short, I have a SQ

    Posted 02-21-2018 05:59
    SQL Server recovery. Long story short, I have a SQL Server MDF and LDF that I need to recover a couple stored procedures from. The original SQL Server that they were on is gone and they won't seem to attach to any servers that I have access to. I've found a couple 3rd party recovery tools that seem to be able to do what I need.(DataNumen and Stellar Phoenix) Has anybody used any of these tools or does anyone have any alternate ideas for recovering this information?


  • 2.  RE: SQL Server recovery. Long story short, I have a SQ

    Posted 02-21-2018 06:05
    I don't have any experience with those tools, but I would download SQL Server 2017 Developer edition locally (https://www.microsoft.com/en-us/sql-server/sql-server-downloads) and then attempt to attach the databases there. Since it's the latest release, it should be able to accept any older database.


  • 3.  RE: SQL Server recovery. Long story short, I have a SQ

    Posted 02-21-2018 06:14
    Thanks @SteveIwanowski, I'll give that a shot. I am using the latest SQL Management Studio but I haven't installed that SQL Server yet.