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
- 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\MSSQL14.SQL2017\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\MSSQL14.SQL2017\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: