|
Just follow the following simple steps of SQL Server database recovery using SysTools SQL Recovery software:
{Step -1}
Open SysTools SQL Recovery Software: Go to Start menu > Programs > SysTools SQL Recovery > SysTools SQL Recovery. The initial software screen will appear. Following is the screenshot which shows how your initial screen would look like:
- Click on Browse button, to select the MDF file. Then software will display following screen:
- Then choose the corrupt or damaged MDF file and click on Open button.
- After this, software will show you the location path of selected MDF file then click on Recover button to start the recovery process.
- Preview the recovered content from the repaired MDF file. Software will show you all the recovered elements from the repaired MDF file like its tables, views, stored procedures etc as follows:
- After previewing the content of the repaired MDF file using demo version, you can Save the recovered file in .str format
- After installed licensed version of SQL Recovery you do not need to again scan your corrupt MDF file just Load the saved .str file created using demo.
- The below screen will appear after loading the saved .str file
Then choose the Saving Option.
- SQL Server Database : If users will choose SQL Server Database, then software willsave or import the repaired MDF file in existing SQL server database. At this users will need to provide all the database credentials such as: Server Name, Database Name, Username, Password. Then select the tables, views procedure to be saved from the left-bottom panel and finally click on Export/Save button.
- SQL Server Compatible SQL Scripts : If users will choose this option, then software will save all SQL scripts in a specific folder. At this users will need to select the tables, views procedure to be saved from the left-bottom pane and finally click on Export/Savebutton.
- After choosing the saving options export the recovered database.
- Export deleted record also
- Exporting the recovered database in SQL server database.
- Display all the table name and count after exporting into database.
- Export the recovered database in CSV format.
- Export as SQL server compatible SQL script, after the completion of the recovery process, software will prompt users regarding the completion process as follows:
You should click on Close button and then navigate the saving location for finding the recovered sql script file.
|
