Documentation Center

Importing data from the SQL dumpfile

Import the sample SDL LiveContent Architect database dump to validate the configuration and for training purposes.

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 Restore Database window, select that you want to restore from a Device then select the latest available dump provided on the installation CD in:
    • for SQL server 2008: \Database\Dump\SQLServer2008
    • for SQL server 2012: \Database\Dump\SQLServer2012
    1. Click the ellipsis button next to the Device field.
    2. Click Add in the resulting Specify Backup window.
    3. Locate and select the backup file.
      The Database field under Source is populated with the name of the database in the backup file.
    4. In the Database field under Destination, select the name of the database you created. This is the database that is to be populated with the data from the backup/dump file.
    5. Click OK.
    6. Verify that the correct file is selected in the Specify Backup window, then click OK.
  4. In the Restore Database window, select Restore next to the database filename in the lower pane then click Options in the left pane.
  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 check the recovery model and verify that Full is selected for the Recovery model.