How Can I Save The Repaired SQL Database In 4 Different Formats?

Stellar Repair for MS SQLsoftware provides multiple options to save a repaired database, including New Database, Live Database, or Other Formats (such as CSV, XLS, and HTML). To save the repaired SQL database, execute the following steps:

• 预览后修复数据库和我ts recoverable components, click on theSaveoption inFilemenu.

• ASave Databasedialog box appears with multiple saving options.
  • New Database: Select this option to save the data to a new SQL database.
  • Live Database: Select this option to save the data to your live (existing) database.
  • Other Formats: Select this option to save the data in an HTML, CSV, or XLS file format.

Now, let’s discuss in detail the steps to save the database using each saving option.

Steps to save the repaired SQL database in a New Database:

• Select theNew Databaseoption and clickNext.

• In the dialog box that appears, do the following:
  • Connect to your SQL Server using any of these options:
    • Windows Authentication: For Windows authentication, specify the name of your server instance.
    • SQL Server Authentication. For SQL Server Authentication, enter username and password of your server instance.
• Select default or a new location to save the repaired database.
• ClickNext.

• Now, select any of these save modes to save the repaired database:
  • Fast Saving: Use this for processing and saving multiple tables at the same time. It is ideal for large databases, as it helps save the repaired data quickly without downtime.
  • Standard Saving: This is the recommended saving mode. It saves the repaired data and indexes simultaneously.

• ClickSave. A dialog box showing the status of tables (Completed, Processing, and Pending) is displayed.

Note:To stop the saving process, click on theStop Allbutton. You will be presented with a ‘Stop’ dialog box with options –Stop Now(to immediately abort the saving process) andComplete Current Table (to save the tables under processing before aborting the saving process). To continue with the saving process, clickCancel.

• Click OK when the ‘Save Complete’ message box appears.

Steps to save the repaired SQL database in a Live Database:

• Select theLive Databaseoption and clickNext.

• Enter details to connect to the server, select an existing database to save the repaired data, and clickNext.

• ChooseFast SavingorAdvanced Savingoption to continue saving the repaired data.

• A screen showing progress of the saving process is displayed.

• A ‘Save Complete’ message box pops up on completion of the saving process.

You can view the repaired data by opening the live (existing) database in SSMS.

Steps to save the repaired SQL database in Other Formats (CSV, HTML, or XLS):

• Select theOther Formatsoption, choose CSV, HTML, or XLS file format, and then clickNext.

• ClickBrowseto select the Destination Path (the location where you want to save the repaired file), and then clickSave.

The destination folder containing the file in which the repaired data is stored will open.