.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to get a mdf file back from sql files recovered from SQL Recovery Toolbox?

Posted By:      Posted Date: October 10, 2010    Points: 0   Category :Sql Server


I had a corrupted mdf file so I purchsed SQL Recovery Toolbox to fix it. When it repaired the file, it spat out a number of sql files and an install.bat file. Because the file was a sql 2008 express file, i'm supposed to now use sqlcmd.exe to fix it. Apparently to get it back to a mdf file, I need to create a blank database and somehow use sqlcmd.exe to import the sql files into the new mdf file.

I use a security program which installs sql express 2008 during the install. I don't know how to use MS Sql. The security program I use has it's own batch file to attach or detatch the two mdf and ldf file to it. I emailed the SQL Recovery Toolbox tech support for instructions on how to created a new mdf db and import the repaired sql files but they basically said that they have an agreement with MS and cannot tell me how to do it.

Can someone please let me know what to do or where to look for assistance? I am stuck at the moment and don't know what else to do.

Any help greatly appreciated, cheers.  

View Complete Post

More Related Resource Links

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Toolbox: Save Coding Time, Manage Compressed Files, and More


Save Coding Time, Manage Compressed Files, and More

Scott Mitchell

MSDN Magazine January 2007

Toolbox: Synchronize Files, Rich Textboxes, and More


Compare files and folders, create demo and support videos, add rich textboxes in your web apps, and more.

Scott Mitchell

MSDN Magazine November 2006

Code Name WinFS: Revolutionary File Storage System Lets Users Search and Manage Files Based on Conte


One of the monumental problems organizations face today is aggregating information that's stored in disparate formats. Knowledge workers have long wanted to be able to search for content independent of format. The next version of the Windows operating system, code-named "Longhorn," boasts a new storage subsystem that makes that task easier. That subsystem, code-named "WinFS," allows the user to perform searches based on the metadata of the stored item, regardless of what type of file it is or which application created it. This article covers the basic architecture of WinFS and explains how to use the WinFS managed API.

Richard Grimes

MSDN Magazine January 2004

Reg File Upload control to upload files from document library


In Field Upload control if we click browse button it allow us to search file in our hard disk but now as per my requirement as soon as user clicks ‘Browse’ button it should point to the document libraries and their files in site.Let me know how could i achieve this?

Thanks & Regards,


How to return back back to code behind file after cascading dropdown calling

Hi, I have a cascading dropdown. After the dropdown is populated(it is in another file)  i would like to return back to the original form where the control is placed. is there anyway of doing it

why only one file is grew two times by 10 % after all files are filld

hi, i have one data file group DATA,With 8 files associated with this.... two files in each four disk drive. i am setting the initial size of each file 1mb and auto grow by 10 % unrestricted. till 75 gb it works fine data in all the files are evenly distributed but once it reaches to 75 GB only one of those files is increasing two times rest of the files remains same... like (75*1.1)*1.1 others are 75 GB.. i expect it should increase first file by 10 % fill it and then pick second file expand by 10 % and fill and so on..  what could be the reason?? can any one help me on this??/

Can't save SQL Server Management Studio sql file back into Sharepoint Document Library

I created an sql query file in SQL Server Management Studio and saved it onto my hard drive.  I then moved that file into a Sharepoint Document Library so others on my team could use that query.I opened the file from within sharepoint, it launched SSMS.I made a change to the file and pressed save.here is the error message that comes up."The operation could not be completed.  The process cannot access the file because it is being used by another process"Am I doing something wrong?

Changing File Permissions of Disconnected MDF/LDF Files

I am a university professor and have over a hundred student project databases using the developer edition of SQL 2005 and 2008 on a portable hard drive.  All are disconnected from any server.  I need to move these to a new hard drive but no file system tool I can find will let me copy the .mdf or .ldf files.  Each of these files has a single user with permissions and the user is a long alpha/numeric string that seems to have been generated by SQL.  I can copy these files if I select each file individually and give full control permissions to my current login.  On some files I need to first take ownership.  I just don't want to have to go in and do this manually for 200+ files scattered all over the drive. I really need some sort of batch approach (including something that can be launched from within VB which I can use to navigate my drive's folder structure looking for .mdf/.ldf files) to let me change the permissions on these files.  As I said, I have a LOT of them and they are scattered around a deep folder structure organized by semester, course, project team, and sometimes project version.  Further, the files accompany other files such as VB projects, report projects, SSIS projects, etc.  I have access to Windows Vista and Windows 7 for doing this.

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

RBS Maintainer not cleanup files in file system (SharePoint 2010)

Here's my environment:   Server #1: SQL Server 2008 R2 Express, RBS enabled Server #2: SharePoint Foundation 2010, RBS installed I setup RBS according to this http://technet.microsoft.com/en-us/library/ee663474.aspx successfully. And I can see the files are storing in NTFS file system instead of database. And then I'm configuring RBS Maintainer according to http://technet.microsoft.com/en-us/library/ff943566.aspx . But it doesn't seem working as expected. I deleted the file from SharePoint Document Library and emptied recycle bin, even in site collection recycle bin. And even I delete the whole site collection. The RBS Maintainer doesn't delete the files in file system. I've updated the following rbs config on my content database for test: exec mssqlrbs.rbs_sp_set_config_value 'garbage_collection_time_window', 'time 00:00:00'; exec mssqlrbs.rbs_sp_set_config_value 'delete_scan_period ', 'time 00:00:00'; exec mssqlrbs.rbs_sp_set_config_value 'orphan_scan_period', 'time 00:00:00'; Maintainer output after I deleted the file, emptied end user recycle bin and site collection recycle bin : C:\Program Files\Microsoft SQL Remote Blob Storage 10.50\Maintainer>"C:\Program Files\Microsoft SQL Remote Blob Storage 10.50\Maintainer\Microsoft.Data.SqlRemot eBlobs.Maintainer.exe" -Connect

Shredded File Recovery? Usn Journal can help?

Hello guys, i recently lost 2 very important folders with irreplaceable files when i moved them to a newly formatted partition and ran G Data's file shredder on the folders i had just drag-dropped them from, for some reason after the file shredding, the folders on the newly formatted partition went from having 11gigs of files to 0kbs i.e GONE, I've tried numerous Data Recovery 3rd party programs (Active@ UNDELETE 7 Enterprise & EASEUS Data Recovery Wizard Pro 4.3.6 ) but the files recovered we're encrypted badly and then tried system Restore and no luck there neither.

I have been told that if the file system uses a "journal ," the journal can store significant amount of information about a file and that information could be used to rebuild/recover the file or its contents after it has been shredded. so my question is,

1. Can MS Journal help with the recovery? if yes

2. Is NTFS a journal using file system?

3. If it is, where is the journal?

4. How can i recover these files?

I'm using Windows Xp Pro SP2

Thank you for taking your time to read my post!

Help will be highly appreciated.  Thank you!

How to merge sheets from multiple excel files into one .xls file?


 I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.

 How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?

 Thanks in advance.

How to back up SQL 2005 with TLog files


We are using SQL 2005 (SP3) and I have catered a maintenance plan that back ups the database.
I read several articles about the back up of SQL 2005 which confused me and raised few questions in my mind. I am not very familiar with SQL 2005 , so feeling uncomfortable what I am doing for taking the back up of the database.

Every hour our database is pulling data from another server which generates reports and charts for the management. Data volume is fairly huge and must have to have very well planed maintenance in case of disaster we can recover maximum data. Maximum one hour's data loss is appreciated.

Now what I'm doing -
1. Taking backup of our DB once in a day at 12:00AM and
2. Backing up TLog file every hour.

Database back up type if full (Recovery Model: Full). Instead of creating separate backup files, I'm appending the existing file (If Backup File Exist: Append).
For the TLog backup system I'm doing the same - not creating any separate backup file for hourly backup, appending the existing file.

Now my confusions are:
Am I taking the backup correctly, or doing anything wrong (company will be in big risk without any perfect backup plan)

From different articles I found that people suggeste

WPF- Back/Forward navigation UI not working when Html web files are displayed in Frame Control


I am integrating (web) html files in my WPF application using Frame (say Source=http://www.microsoft.com)

I set the JournalOwnership="OwnsJournal" and


The navigation UI is visible and disabled initially when the page loads up (which is fine), but when I click on links the Back/Forward button is not enabled.  Interestingly the context menu shows Back/Forward and I can navigate that way. Do you have pointers?


Thanks for your help.

how to make a back up file(.bak) of database


I need to make a back up file(.bak) from my database (.mdf)

I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't. What am I doing wrong.. Please help.

Back up SQL 2008 Express files


Hi All,

I'm running Visual Studio 2008 Express that comes with SQL 2008 Express.

I have developed a web site with a SQL 2008 Express database. I need to upload the database as a .bak backup file to the server that can host the web site.

How do I create that backup of the database ? There seem to be no tools that come with SQL Express to back it up. 

Free applications like SQLBackupandFTP only seem to back up the system databases - not hose created in projects. 

I downloaded SQL Express SP2 but that doesn't seem to have made any difference either !?

I think I need a script file - using T-SQL but I'm not a SQL programmer so any help would be appreciated !


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend