Importing data from the SQL dumpfile
Import the sample Content Manager 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 .
- In the General tab of the Restore Database window, select that you want to restore from a Device.
- In the Files tab of the Restore Database Window:
- For the Rows Data select the data file path of the database you created (e.g.
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ContentManager.mdf). - For the Log select the log file path of the database you created (e.g.
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ContentManager_log.ldf).
- For the Rows Data select the data file path of the database you created (e.g.
- 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: