Adventureworks database download 2012 log file

For multidimensional and tabular models, see AdventureWorks for Analysis services. Feedback on this release : send to sqlserversamples microsoft. It is a sample database for data warehousing, and provides source data for the multi-dimensional and tabular analysis projects mentioned in this release. This release contains the full database files, scripts, and projects for AdventureWorks They are for use with SQL Server and later versions.

Skip to content. Star 6. Releases Tags. See the following image:. In the Restore Database window, select Device as a source and click on ellipse … :.

In the Locate backup devices window, select the backup media by clicking Add , and then in the newly opened window navigate to the directory where the database backup is downloaded and select the backup. Click OK :. If you want to change the physical location of the data file and log file, click on Files pane and change the target location for the data and log files. Note that it is best practice to keep data files and log files on separate drives:. Open up the "AdventureWorksDW Click "Edit" the "Connection string" to launch the "Connection Manager".

Log on to the server by entering your credentials and select the AdventureWorksDW database to connect to. Test the connection by clicking "Test Connection". Assuming that the connection is successful, the following screen will be shown:.

Using Microsoft Hands-On labs to get hands-on cloud experience for free. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data. How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data. Searching and finding a string value in all columns in a SQL Server table. In this article, I have explained from where you can download AdventureWorks sample database and congifure it to use in local SQL server database.

So, this is our first step to download complete sample database of AdventureWorks , there are many SQL server versions of the sample database. I will be downloading AdventureWorks