SQL Server database related issues such as MDF and NDF corruption, analyzing transaction logs, encrypted databases, forgotten passwords can be resolved using SQL Server Recovery Manager.
Corrupted primary as well as secondary database files can be recovered and exported to SQL Server 2014 or lower versions and SQL Server Compatible SQL Scripts. Data is extracted using dual scan modes as per extent of corruption. Quick scan recovers data from minimal corrupted database files whereas Advance scan can be performed on files with higher intensity corruption. Recovered data can be saved with both 'Schema & Data'; or with 'Schema' only.
Log detection plays an important role in SQL Server database recovery, therefore the tool helps examining transaction logs as well. All existing operations including Insert, Update, Delete, etc. can be analyzed and the actual corruption reason can be detected. While uploading LDF file, the associated MDF is automatically detected and uploaded if saved at same location. Recovered data can be exported as SQL Server database, CSV file or SQL Server Compatible SQL Scripts.
Recover SQL BAK files and extract data from MDF as well as NDF files incorporated within the backup files. All integrated components including database tables, triggers, indexes, stored procedures, functions, rules, keys can be recovered with the tool. The recovered components can be saved as SQL Server database or SQL compatible scripts in the form of 'Schema' as well as both 'Schema and Data'.
Reset forgotten SQL database password is another feature assembled within the tool. Special character, alpha numeric, numeric as well as all other passwords can be removed and the database can be accessed thereafter without providing such credentials. Removes passwords from selective Username IDs and operates batch users at one instance of time. Encrypted passwords are displayed as 'Unknown' whereas 'Empty' value is assigned within the tool panel if no password is been allotted to the database.
Apart from above mentioned features, the software also offers to decrypt encrypted database by providing SQL Server as well as Windows login credentials. Once database gets decrypted in Live SQL environment, it can be exported to SQL Server database or SQL Server compatible scripts. Additionally, the components from healthy as well as corrupted MDF files such as tables, triggers, stored procedures can be viewed without installing SQL Server application.
Limitations:
Preview only
Comments not found