Importing data from the SQL dumpfile
Import the sample SDL LiveContent Architect database dump to validate the configuration and for training purposes.
Procedure
- In the SQL Server Management Studio window, under Databases, right-click on the database you created.
- Click Tasks > Restore > Database.
- 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
Note: If the SQL server 2008 or 2012 dump is not provided, you can use the SQL server 2005 dump.
- Click the ellipsis button next to the Device field.
- Click Add in the resulting Specify Backup window.
- Locate and select the backup file.
The Database field under Source is populated with the name of the database in the backup file.
- 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.
Note: Make sure to select this after selecting the source otherwise it can default to another database name.
- Click OK.
- Verify that the correct file is selected in the Specify Backup window, then click OK.
- In the Restore Database window, select Restore next to the database filename in the lower pane then click Options in the left pane.
- Under the Options tab, select Overwrite the existing database.
- Click OK.
The database is restored.
- After restoring the database, use SQL Server Management Studio to check the recovery model and verify that Full is selected for the Recovery model.