5. FAQs

1. What does the demo version of the software do?

Demo version of the software shows only repairs and displays the preview of the database. To save repaired database, you need to purchase and activate the software.

2. Why do I requireStellar Repair for MS SQL?

Sometimes due to virus infection, operating system malfunction, file system corruption or other similar reasons, the SQL database gets corrupted and the data in it becomes inaccessible.Stellar Repair for MS SQLhelps you rebuild the corrupt database and restore the data back.

The software is risk-free and repair inaccessible database components from the corrupt MDF file in three easy steps: Select, Repair and Save. SeeWorking with the Software, to know about the steps.

To know which components of SQL database you can recover by usingStellar Repair for MS SQL,refer to theKnowledge Base Article

3. What are the common SQL Database Corruption Errors, Causes and Resolutions?

Refer to theKnowledge Base Article

4.如何修复激活的错误吗Stellar Repair for MS SQL?

Refer to theKnowledge Base Article

5. Why is it necessary to perform repair process on the copy of database?

Stellar Repair for MS SQLwill not be able to repair if the database is attached to MS SQL Server.

6. Can we repair tables in a MDF file selectively?

Yes, you can recover single or multiple tables. Simply select desired tables in tree view and start repair process.

7. Software is not able to detect the Database version what should I do?

There is an option to choose the database version manually. When software fails to detect the version then select the database version manually. SeeSelect the Scan Mode and Repair MDF Filesfor more information.

To know more, refer to theKnowledge Base Article

8. How canStellar Repair for MS SQLhelp me search for the location of MDF file on the computer?

You can search for MDF file on the computer usingFindoption of the software. For more details, please referSelect MS SQL database (MDF File) topic of the help manual.

9. I want to locate an item in the database (MDF file). Is there any way I can do this using the software?

Yes, after repairing the MDF file, the software gives you option to search items in tree view. UseSearchoption to locate desired item in a table.

10. How to Recover Deleted Records usingStellar Repair for MS SQL?

Stellar Repair for MS SQLprovides you an option toIncludeDeleted Recordsin MS SQL database (MDF) repaired file. SeeInclude Deleted Recordsfor more details.

To know more, refer to theKnowledge Base Article

11. How Can I Save The Repaired SQL Database In Three Different Formats?

Stellar Repair for MS SQLsoftware allows you to save the repaired SQL database file inNew Database, Live Database or Other formatssuch as CSV, XLS or HTML format.

To save the repaired SQL database file in any one of the three file formats, ClickSavefromFileribbon.ASave Databasedialog box appears giving you the option to save inNew Database, Live Database or Other formatssuch as CSV, XLS or HTML format. Fill in the details and clickSave. SeePreview and Save MDF Filesfor more details.

To know more, refer to theKnowledge Base Article

12. Why is it taking longer than usual to save a table?

If it takes longer than usual to save a table, how would I recognize the issue?

At the time of the saving process, if the process stops at a specific percentage and is not increasing, check the saving percentage of that table after some time, if it is still not increasing, then follow the steps to check if the file is stuck or not in theMS SQL Server:

RunMS SQL Server.
In Object Explorer, connect to an instance of theSQL Server Database Engine.
Expand Databases Folder, find the recovered database inObject Explorer,and expand it.
Expand Tables Folder, by searching the name of the tables that are stuck in between the saving process, preview the records by using SQL statement “SELECT * FROM table_name;”。You have to execute this statement twice or thrice to see the records/rows counter.
If the records counter in the right-bottom of the screen isincreasing, that means the saving process is working appropriately and you don't have to do anything.
If the records counter in the right-bottom of the screen isnot increasing, that means the saving process is stuck.

13. I am trying to save the repaired database but the software is saving particular tables for quite some time. I am not sure if the software is doing anything in the background. How can I save the tables?

If the software is taking time to save the database or the specific percentage and is not increasing, that means the process is stuck.

If the process gets stuck, you have to stop theSaving Processfrom theSaving Tabledialog box. After stopping the process, by default, stuck tables are already selected in the left pane of the screen.

You have to save the stuck tables individually.

To save the tables follow the steps given below:

FromFilemenu, clickSave.
Save Databasewindow appears. FromSaving Option, selectLive Databaseradio button.
ClickNext.
AConnect to Serverwindow appears. EnterServer Name/Instance Name.
From the drop-down list, chooseExisting Database(previously recovered database).
ClickNext.
Select theSave Modeoption: Fast Saving / Standard Saving. ClickSaveto continue the process.
Save Completedialog box appears, with a message “File saved successfully”, indicating that the saving process is completed successfully.

To know more about the saving process, referPreview and Save MDF Files.

14. I am not satisfied with the repaired results. What can I do?

If in case you are not satisfied with the repaired results, we recommend getting your file repaired by certified professionals.

15. How can we view process log?

You can view log of the process at the bottom of the user interface. If this pane is not visible, you can enable it by selecting theLog Windowcheckbox inViewsection ofViewribbon.

16. Can we save process log?

Yes,Stellar Repair for MS SQLgives you option to save log report of the process.

To save log report:

FromViewribbon, selectSave Log.
InSave Asdialog box, select the location where you want to save the log report. ClickSave.

To know more, refer to theKnowledge Base Article

17. How to Customize Quick Access Toolbar Feature in the Software?

Refer to theKnowledge Base Article

18. How much timeStellar Repair for MS SQLwill take to scan and repair corrupt/damaged database?

The time taken in scanning and repairing database is totally dependent upon the size and number of records present in database file.

19. Is MS SQL application is required to be installed on the system for previewing database?

No, MS SQL application is not required to be installed for previewing the database.

20. How to fix connection error when trying to save therepairedSQL database in New or Live Database?

When you are trying to save repaired MS SQL Database in Live or New Database you might face a “Connection Error”。这可能是由于Stellar Repair for MS SQLsoftware and the server where the database is deployed are installedon two different machines.TheStellar Repair for MS SQLmust be installed on the same server machine where the database is deployed when you are trying to save the Database by using theNew or Live Database option.

21. How to Use Platinum Version ofStellar Repair for MS SQL?

Refer to theKnowledge Base Article

21. How to Recover SQL Database from SUSPECT Mode?

Refer to theKnowledge Base Article

22. How to create a New SQL Server Database to Save a Repaired Database File after Corruption?

Refer to theKnowledge Base Article

23.How many tables can be saved at the same time?

Stellar Repair for MS SQLsaveeight tablesat the same time. (The processing of the table depends upon the Processor and RAM of the system)

24. How many scanning modes are there and what is the difference between the both?

There aretwoscanning modes,Standard ScanandAdvanced Scan. Standard Scanis recommended for fast scanning procedure which is successful in most cases of corruption andAdvanced Scanextensively scans the corrupted files, it takes more time but works effectively when Standard scan is not working.

25. What is the difference between Fast Saving Mode and Standard Saving Mode?

Fast Saving modeis advisable for large databases. It saves the data first and then save indexes. There is a possibility that the administrator may have to reapply indexes after the repaired database is saved.

Standard Saving Modeis a conventional way of saving repaired databases.It saves the data and the indexes at the same time.

26. Can I repair the database using the existing saved scan information?

Yes,you can repair the database using the existing saved scan information.