Microsoft SQL Server

Microsoft SQL Server

In Microsoft SQL server, Vembu Universal Explorer allows you to perform object, schema and table level recovery. To perform the recovery from the backup image, the backup should be mounted in the disk management.

  • Start the Vembu Explorer for SQL application.
  • Click Next after reading the brief introduction to Vembu Explorer for SQL.

  • In this window by default “Restore from backups in local disks” option is selected, click Next to proceed further.

  • Select the .mdf file respective to the SQL Database that you want to recover.
  • Once you select the .mdf file, the respective .ldf file will be selected automatically. Click Next.

Choose Restore Type

  • Export as a File
  • Restore to SQL server
  • Select the desired restore type - Export as a file (or) Restore to SQL server; By default “Export as a file option” is selected.

Export as a File

  • Select export as a file option and Click Next to proceed.
  • Once you select the Export as a file option, in the next step you will be asked to select the ‘What to export’. You can either export object's schema or export object's data.

What to Export

  • Export Object's Schema: This option will allow you to export the structure or schema of the selecting object.
  • Export Object's Data: This option will allow you to export the schema and data of the selecting object.

Export as Object's schema

  • Once you select the Export as Object schema option, in the next step of the wizard you will be asked to select an Export format.

Choose Export Format

  • In this step select one among below export formats:

Export as .sql File

  • Using .sql format you can export the query for schema or data of the object as a .sql file. This file can be opened in Microsoft SQL server management studio and you can run that query to generate the database objects.

Export as .xls File

  • Using .xls format you can export schema and data of objects. You can view the data available in .xls file and then you import that file into the database using import data option in the MS SQL Server Management Studio.

Export as .sql

Choose the Destination Location

  • At this step of the wizard, choose the location to export files in the given format.

Select Database objects to export

  • Once you select the destination location to export files, click Next to proceed.
  • The next step of the wizard is populated by database objects present in the given database file.
    • Select the database objects to export.
    • By using select all check-box you can select all the objects.
    • Type column of Datagrid will tell you the type of object whether its a table, view, stored procedure or user.
    • In the Object Name column, the name of tables, views, stored procedure, and users will be available.

Restore In Progress

  • In this step of the wizard, you can view the progress of the export process.

  • Click the Finish button after the export process is completed.
  • Once the export process is completed go to the Export location to access the files.

Go to Export Location

  • The exported file name will be in the format as below:

V_Database Name_Time Stamp During Export_Object Name.

If the exported format is .sql, then follow below steps to use that file:

  • Right-click the file and hit open. The file will be opened in the MS SQL server management studio and resemble the image displayed below.
  • You have to run the SQL query to view the exported Object schema or Object data.

Export as .xls

Choose the Destination Location

  • At this step of the wizard, choose the location to export files in the given format.

Select Database objects to export

  • Once you select the destination location to export files, Click Next to proceed.
  • The next step of  wizard is populated by database objects present in the given database file.
    • Select the database objects to export.
    • By using select all check-box you can select all the objects.
    • Type column of Datagrid will tell you the type of object whether its table, view, stored procedure or user.
    • In Object Name column the name of tables, views, stored procedure and users will be available.

Restore In Progress

  • In this step of the wizard, you can view the progress of the export process.

  • Click the Finish button, after the export process is finished.
  • Once the Export process is completed go to the Export location to access the files.

Go to Export Location

The exported file name will be in below format:

V_Database Name_Time Stamp During Export_Object Name.

If the exported format is .xls then, follow the below steps:

  • Go to MS SQL Server Management Studio.
  • Choose Database to Import Data in the .xls file. Right-click on the database.
  • Go to tasks and then Import Data option. MS SQL Server Import and Export wizard will open.

  • Press Next. The wizard navigates you to Choose a Data Source wizard.
  • In the Data Source field select Microsoft Excel.
  • In Excel file path browse the exported .xls file path, choose the path and hit next.

  • Now select server name, authentication and database to import the data in the Xls file.

  • Specify Table Copy and Query step, copy data from one or more tables choose this option and click Next.

  • In Select Source Tables and Views wizard, select the sheet from which you want to import data and proceed.

  • In Run Package wizard, check Run Immediately option and click Next.

  • Verify the provided details and click Finish.

  • You will get the wizard displayed below once you have imported your data.

  • Once done importing data, go to the database and verify imported data.

Export Object's Data

  • Once you select the Export as Object's Data option, in the next step of the wizard you will be asked to select an Export format.

Choose Export Format

In this step select one among below export formats:

Export as .sql File

  • Using .sql format you can export the query for schema or data of the object as a .sql file. This file can be opened in Microsoft SQL Server Management Studio and you can run that query to generate the database objects.

Export as .xls File

  • Using .xls format you can export schema and data of objects. You can view the data available in .xls file and then you import that file into database using import data option in the MS SQL Server Management Studio.

Export as .sql

Choose the Destination Location

  • At this step of the wizard, choose the location to export files in the given format.

Select Database objects to export

  • Once you select the destination location to export files, Click Next to proceed.
  • The next step of  wizard is populated by database objects present in the given database file.
    • Select the database objects to export.
    • By using select all check-box you can select all the objects.
    • Type column of Datagrid will tell you the type of object whether its a table, view, stored procedure or user.
    • In the Object Name column, the name of tables, views, stored procedure, and users will be available.

Restore In Progress

  • In this step of the wizard, you can view the progress of the export process.

  • Click the Finish button once the export process is finished. Go to the Export location to access the files.

Go to Export Location

The exported file name will be in below format:

V_Database Name_Time Stamp During Export_Object Name

If the exported format is .sql, then follow below steps to use that file:

  • Right-click over the file and hit Open. The file will be opened in the MS SQL server management studio and will resemble the image displayed below.
  • You have to run the SQL query to view the exported Object schema or Object data.

Export as .xls

Choose the Destination Location

At this step of the wizard, choose the location to export files in the given format.

Select Database objects to export

  • Once you select the destination location to export files, click Next to proceed.
  • The next step of  wizard is populated by database objects present in the given database file.
    • Select the database objects to export.
    • By using select all check-box you can select all the objects.
    • Type column of Datagrid will tell you the type of object whether it’s table, view, stored procedure or user.
    • In Object Name column the name of tables, views, stored procedure, and users will be available.

Restore In Progress

  • In this step of the wizard, you can view the progress of the export process.

  • Click the Finish button once the export process is finished. Open the Export location to access the files.

Go to Export Location

The exported file name will be in below format:

V_Database Name_Time Stamp During Export_Object Name.

If the exported format is .xls then, follow the below steps:

  • Go to MS SQL Server Management Studio.
  • Choose Database to Import Data in the .xls file. Right Click on the database.
  • Go to Tasks and then select the Import Data option. MS SQL Server Import and Export wizard will open.

  • Click Next. The wizard navigates you to Choose a Data Source wizard.
  • In the Data Source field select Microsoft Excel.
  • In Excel file path browse the exported .xls file path, choose the path and click Next.

  • Select the server name, authentication, and database to import the data in the Xls file.

  • Specify Table Copy and Query step, copy data from one or more tables choose this option and click Next.

  • In the Select Source Tables and Views wizard, select the sheet from which you want to import data and proceed.

  • In Run Package wizard, check Run Immediately option and click Next.

  • Verify the provided details and click Finish.

  • You will get the wizard as displayed below after importing data.

  • Once done importing data, go to the database and verify imported data.

Restore to SQL server

Restore directly to the target SQL server can be performed by selecting this option. If you select Restore to SQL Server, the application wizard leads you to below process:

Specify object copy method

  • At this step of the wizard, choose whether you need to restore schema or schema along with data of objects to the target database and proceed by selecting Next.

Choose the Destination Database

At this step of wizard

    • In the 'instance' field choose SQL Server instance of the target database in which you are going to restore objects.
    • In the 'authentication' field choose the authentication for SQL Server, by default it is windows authentication. If you choose SQL Server Authentication then provide Username and password in respective fields.  
    • In the 'target database' field select the target database to restore the database objects.
    • If the ‘Display system database’ check-box is checked, then system databases are available in the target database box.
    • In the 'target database' box, there is an option “Choose different Database”. If you select it, a new text-box asking a new database name will be visible. Provide database name in that text-box.
    • Once the restore process completes, you can find the newly created database in the SQL server with the provided name with restored objects stored in it.

Database objects to Restore

  • At this step of the wizard, the Datagrid in the wizard is populated with the database objects available in a given database.
  • Select the required objects to restore from the database to the production environment.

Rename Objects

  • At this step of the wizard, the Datagrid available in the wizard is populated with the selected objects from the previous step.
  • Two columns will be available in Datagrid, where the original name column shows the actual name of the object, whereas, in the new name column, you can provide desired names for objects with which you want to restore.
  • By default, the original names will be the name for objects.

Restore In Progress

  • Here you can view the progress of the restore process.

  • Click Finish to close the wizard, once restore completes successfully.

Post completion of Restore

  • Go to MS SQL Server Management Studio.
  • Connect to the instance to which you selected the restore process.
  • Go to the target database where you can view restored objects(Refer below).