Documentation Center

Importing data from the SQL dumpfile

Import the sample Content Manager database dump to validate the configuration and for training purposes.

About this task

The backup data you import can come from the same version of SQL server or from a previous version.

Procedure

  1. In the SQL Server Management Studio window, under Databases, right-click on the database you created.
  2. Click Tasks > Restore > Database.
  3. In the General tab of the Restore Database window, select that you want to restore from a Device.
    1. Click the ellipsis button next to the Device field.
    2. Click Add in the resulting Specify Backup window.
    3. Locate and select the latest available dump provided on the installation CD in a subfolder of the \Database\Dump\ folder.
    4. Click OK.
    5. The Database field under Source is populated with the name of the database in the backup file.
    6. In the Database field under Destination, select the name of the database you created (e.g. ContentManager). This is the database that is to be populated with the data from the backup/dump file.
  4. In the Files tab of the Restore Database Window:
    1. For the Rows Data select the data file path of the database you created (e.g. C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\DATA\ContentManager.mdf).
    2. For the Log select the log file path of the database you created (e.g. C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\DATA\ContentManager_log.ldf).
  5. Under the Options tab, select Overwrite the existing database.
  6. Click OK. The database is restored.
  7. After restoring the database, use SQL Server Management Studio to:
    1. Open the Properties window,
    2. Go to the Files tab,
    3. Check and adapt (if necessary) the logical name.
      File typeLogical Name
      Rows DataSet Logical Name to <dbname> (e.g. ContentManager)
      LogSet Logical Name to <dbname>_Log (e.g. ContentManager_Log)
    4. Check the recovery model and verify that Full is selected for the Recovery model.