Stellar Repair for MS SQL/4. Working with the Software/4.5. Preview and Save MDF Files

4.5. Preview and Save MDF Files

After you complete the repairing process successfully,Stellar Repair for MS SQLshows preview of corrupted database files. The left pane displays list of items (Tables, Views, Synonyms, Defaults, Data Types and more) in a tree like structure, upper right pane displays the contents of the item selected in the tree view and bottom pane shows message log. A sample screen is displayed below:

默认情况下,所有的树视图的复选框re selected. You can click on the item in the tree view to preview its content.

Note:The software performs a counting of records present in the database after repairing process is completed. The time taken in counting depends on the number of records present in the database. You can stop the counting of records to speed up repair process without affecting the repair results.

To save the repaired file to MS SQL database:

• After the repairing process gets completed, clickSaveoption fromFileribbon.

• Specify whether you want to save the repaired database inNew Database, Live Database or Other formatssuch as CSV, XLS or HTML format by selecting the appropriate radio button.

1. Saving Repaired Database as New Database

2. Saving Repaired Database as Live Database

3. Saving Repaired Database in Other formats

To save the repaired database as a completely New database, follow the steps mentioned below:

1. SelectNew Databaseradio button fromSaving optioninSave Databasedialog box.

2. ClickNext. AConnect to Serverdialog box appears.

3. EnterServer Name/Instance Name.

4. Choose the Authentication method from the drop down list to connect the server:

   1. If the authentication method selected is Windows Authentication, you need not enter any user name and password:

2. If the selected authentication method is SQL Server Authentication, enter the server user name and password:

5. Select the Location fromDefault SQLorNewfor saving the repaired MDF file.

   1. If you have selected the Location asNew, clickBrowseto select the folder where you want to save the repaired file.

6. ClickNext. Select theSave Modeoption and clickSaveto continue the process.

   1. If you want to save large database, selectFast Savingradio button.

2. If you want to save the data and indexes at the same time, selectStandard Savingradio button.

7. ClickSavebutton to save the repaired MS SQL Database file.

Note:If database file version is selected initially, In this caseDatabase Collationscreen appears while saving the repaired database file. Select appropriate database collation from the drop-down list and clickOKto continue the further saving process.

8. Saving Tablesdialog box appears that consists of four columns as follows:

1. Table Name: This column provides a list of Tables from the repaired file that you have sorted from previous screen for export.

2. Status: This column provides information about the table whether the save process isCompleted, Processing, Pending, Aborted.

3. Records: This column provides the total number of items processed from the source to the destination Table.

4. Percentage:This column provides information about the progress of the saving process in percentage.

Stellar Repair for MS SQLcan process up to eight tables at the same time. You can stop the saving process using the steps as follows:

1. To stop the saving tables process, click停止allbutton. A停止dialog box appears to confirm your action as given below:

1. If you want to save the tables that are currently being processed and then stop the saving process, clickComplete Current Table.

2. If you do not want to complete the saving of tables that are currently being processed and stop the saving process, click停止Now. If you immediately stop the process, only the partial data of the table that is currently being processed will be saved in the destination table.

3. To go back to theSaving Tablescreen and continue saving the tables, clickCancel.

9. A message is displayed after the process is completed successfully.

Note:After saving the repaired files if you do not find the expected result you can use the "Standard Save" option and resave the repaired files.

To save the repaired database as a completely Live Database, follow the steps mentioned below:

1. SelectLive Databaseradio button fromSaving optioninSave Databasedialog box.

2. ClickNext. AConnect to Serverdialog box appears.

3. EnterServer Name/Instance Name.

4. Choose the Authentication method from the drop down list to connect the server:

   1. If the authentication method selected is Windows Authentication, you need not enter any user name and password:

2. If the selected authentication method is SQL Server Authentication, enter the server user name and password:

5. SelectExisting Databasefrom drop down list.

Note:ClickRefreshButton, If any database is not listed in drop down list and is there inthe SQL Server.

6. ClickNext. Select theSave Modeoption and clickSaveto continue the process.

1. If you want to save large database, selectFast Savingradio button.

2. If you want to save the data and indexes at the same time, selectStandard Savingradio button.

Note:If database file version is selected initially, In this caseDatabase Collationscreen appears while saving the repaired database file. Select appropriate database collation from the drop-down list and clickOKto continue the further saving process.

7. Saving Tablesdialog box appears that consists of four columns as follows:

1. Table Name: This column provides a list of Tables from the repaired file that you have sorted from previous screen for export.

2. Status: This column provides information about the table whether the save process isCompleted, Processing, Pending, Aborted.

3. Records: This column provides the total number of items processed from the source to the destination Table.

4. Percentage:This column provides information about the progress of the saving process in percentage.

Stellar Repair for MS SQLcan process up to eight tables at the same time. You can stop the saving process using the steps as follows:

1. To stop the saving tables process, click停止allbutton. A停止dialog box appears to confirm your action as given below:

1. If you want to save the tables that are currently being processed and then stop the saving process, clickComplete Current Table.

2. If you do not want to complete the saving of tables that are currently being processed and stop the saving process, click停止Now. If you immediately stop the process, only the partial data of the table that is currently being processed will be saved in the destination table.

3. To go back to theSaving Tablescreen and continue saving the tables, clickCancel.

8. A message is displayed after the process is completed successfully.

Note:After saving the repaired files if you do not find the expected result you can use the "Standard Save" option and resave the repaired files.

To save the repaired file in Other Formats:

1. SelectOther formatsradio button fromSaving optioninSave Databasedialog box and Select the required file format.

3. Click下一个。ClickBrowseto select the desired folder where you want to save the repaired file and clickSavebutton.

Note:By default年代后打开目标文件夹aving repaired databasecheckbox is checked. If you do not want to open the folder you can uncheck the checkbox.

Note:If database file version is selected initially, In this caseDatabase Collationscreen appears while saving the repaired database file. Select appropriate database collation from the drop-down list and clickOKto save repaired database file.

4. The file will be saved in the desired format.

Note:Perform repair process on the copy of database and make sure MS SQL Server is running during repair process.

Related Links:

• How to Video:https://www.youtube.com/watch?v=yso4axqXxlM&feature=emb_title