AdventureWorks Database - Download Microsoft SQL Server 2008 R2 Sample Databases

After the RTM release of Microsoft SQL Server 2008 R2, the new data platform of Microsoft, related product releases are following each other.
Microsoft has released sample databases for Microsoft SQL Server 2008 R2 for SQL Server administrators, t-sql developers, BI developers and IT professionals.
You can free download SQL Server 2008 R2 sample databases including AdventureWorks database download from CodePlex.
Please note that with new releases for SQL Server sample databases, these download links might change. But you will find the new sample database download link on the same URL.

The total size of sample databases installer download is about 80 MB (84280K).

Using sample databases on Microsoft SQL Server 2008 R2 will be very useful when you want to work with new enhancements and new improvements on Microsoft SQL Server 2008 R2.
Adventure Works Cycles is a fictitious multinational manufacturing company. The data of Adventure Works Cycles are kept on AdventureWorks sample databases.
The Adventure Works Cycles company manufactures bicycles parts and sells bicycles. You can find detailed official information on Adventure Works Cycles Business Scenarios at MSDN

SQL Server 2008 R2 Sample Databases

When you download AdventureWorks sample databases from CodePlex and start the installer following sample databases will be created and installed on the SQL Server database instance.

Sample Database names (Sample SQL Server databases for SQL Server 2008 R2):
AdventureWorks
AdventureWorks2008R2
AdventureWorksDW
AdventureWorksDW2008R2
AdventureWorksLT
AdventureWorksLT2008R2

By the way, if you are working with Microsoft SQL Server 2008, please read Download AdventureWorks Sample Database for Microsoft SQL Server 2008 for SQL2008 sample databases.

SQL Server professionals can free download AdventureWorks SQL Server 2008 R2 sample databases from Open Source Community CodePlex Microsoft SQL Server Database Product Samples Sample Databases download site.

The previous sample database download is an executable file named AdventureWorks2008R2_SR1.exe. After sample databases download is completed, setup can be started by running the executable installer.
The setup process will be completed within 5 minutes in case no error occurs.

Please note that the previous sample database download executable file was named as AdventureWorks2008R2_RTM.exe.

After you complete sample database download, double click on the executable file which will run the sample database installation wizard.
You can follow the following steps in order to install sample databases including AdventureWorks on Microsoft SQL Server 2008 R2.