Easy Functional Steps
- Run the SQL backup recovery software from your computer's Start Menu.
- Click on Load to select the desired file.
- On the Open window, browse the file storage folder path. Select the file and click on Open.
- Now select the scanning mode and select the SQL Server version.
- Click on Multiple Backup Files Options and select unlimited files.
- Select the full database backup and click on Recover button.
- Software will automatically start scanning the selected file and will show live progress of the same with details of the database displayed.
Click on Close once the scanning has finished and reached 100%.
- Once the software has loaded your file, items can be previewed in a tree structure view on the right pane of software panel.
To preview contents of a single item, click on it.
When you are done previewing contents of your file, you can proceed with exporting the database.
- Click on the Export button given on top of the software in its Menu Bar.
- On the Export To/As screen you can view a number of options to choose from.
Choose "SQL Server Database" option to export your data as an SQL database file.
- Provide Database Credentials as:
Server Name (In which you will be exporting)
Database Name (The one you are exporting)
User Name
Password
- Select the desired components / items that you want to export; using checkboxes provided against each of them.
Lastly, choose what do you want to export of your database from recovered file: Only Schema & Schema plus Data. Click on Export/Save button on the bottom of the screen to proceed exporting.
- Now you will see an export progress screen where a live export reading will be shown of each and every database component and its items.
Once the export finishes, software will create a new database directly in the chosen SQL Server.
- Choose "SQL Server Compatible SQL Scripts" to export your database.
Select the items and components that you want to export to script file.
- Select the items and components that you want to export from file to script file.
Define the preference of export:
1. Schema Only
2. Schema and Data
3. Whsen done, click on Export/Save button to begin exporting database.
STEP 16:
- A Browse For Folder screen will open up, browse the desired destination path to store your SQL Script file. Click on Ok.
