A SQL Server Keeper: Data Extraction Tool

April 9, 2011

We think Microsoft SQL Server is just about perfect. Well, most of the time. When our favorite database has the hiccups, life can become pretty darned exciting.

“Server Database Extract Tool to Extract SQL Server Database Proficiently” introduces a potentially handy resource to aid in times of trouble. Should you find yourself with a damaged SQL server and thus an inaccessible database, SysTools SQL Recovery is worth a try.

What’s the tool do? Our quick look revealed that we can deals with such corruption issues as:

The file *.mdf is missing and needs to restore
Server can’t find the requested database table
Table corrupt object id wrong
The delete statement conflicted with the reference constraint the conflict occurred in database
The conflict occurred in database msdb table dbo.sysmaintplan_subplans column ‘job_id’
Error 3403 and Severity 22 during recovery initialization.

For compatibility information, check the SysTools SQL Recovery Web site at http://www.sqlserverdatabaserecovery.com/.

The vendor specializes in recovering critical business data from SQL Server 2000, 2005, and 2008. We have successfully recovered SQL data from all servers, operating systems and databases, including relational database servers, web servers (Apache and Microsoft IIS), business application servers, snap servers, NAS, SAN and document management systems, and content management systems.

The pricing model is $129 and $229 for a personal and business license, respectively. There is also a demo version available for download, so it’s worth a look.

Sarah Rogers, April 9, 2011

Freebie

Written by Stephen E. Arnold · Filed Under Database, Microsoft, News, Technology, Text processing

Comments

2 Responses to “A SQL Server Keeper: Data Extraction Tool”

SQL Server CE, tips for usage and issue of corruption « D.T. & Assoc. IT Blog on April 24th, 2011 12:08 pm

[…] A SQL Server Keeper: Data Extraction Tool (arnoldit.com) […]
Peter on April 27th, 2011 10:04 am

I have struggled with this problem in my work and I have tried TM Field Finder form TargetMind.com it’s really cool and light software which helps to search for anything in SQL Server schema and data.

Search the site
Subscribe to Beyond Search
Feature archive
News archive

Stephen E. Arnold monitors search, content processing, text mining and related topics from his high-tech nerve center in rural Kentucky. He tries to winnow the goose feathers from the giblets. He works with colleagues worldwide to make this Web log useful to those who want to go "beyond search". Contact him at sa [at] arnoldit.com. His Web site with additional information about search is arnoldit.com.