Instead of restoring a database, alternatively, you can use scripts to create the AdventureWorks databases regardless of version. Additional information about using the scripts can be found on GitHub.
Once you've restored your sample database, using the following tutorials to get started with SQL Server:. Skip to main content.
This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Select OK to restore your database. Right-click on your server and select Manage.
Above image displays the location where Sample Database is installed. This is very important task otherwise your database will be created with empty tables. This method requires to create empty database initially and then after restoring it from backup.
Please pay attention to radio buttons and checkbox on the screen as it is very important to select the right options when restoring database. The following screen is most important, make sure to select options displayed in the screen or database will not be restored. If you want to install AdventureWorks database version , the methods works fine. A walkthrough that shows how to install the AdventureWorks database can be seen at the following Microsoft site:.
Walkthrough: Installing the AdventureWorks Database. The result is that "Microsoft Analysis Services" on localhost is connected to. The result is that the "Restore Database" screen is shown.
Specify the path and file name of the AdventureWorks cube that you want to restore. All of the cube-related information is then stored in the following directory:.
0コメント