This entry was posted in All Articles, SQL SERVER 2014, VIDEO and tagged Install AdventureWorks 2014, Install AdventureWorks2012, Install SQL Server 2014, Junaith Haja, SQL Server 2014 on Augby Junaith Haja. Please select the Source as a device, and click. option, a new window called Restore Database will open. Right-click on the Databases and select the Restore Database. TO ‘C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf’ To install the AdventureWorks Database in SQL Server, Go to the Object Explorer. Go to the following CodePlex download page: CodePlex 2. Install the sample AdventureWorks cube onto SQL Server 2012 Analysis Services Follow these steps: 1. Now the AdventureWorks database is attached. TO ‘C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf’, Remove the AdventureWorks2012Log.ldf file by clicking the Remove button. Right-click Databases and select Restore Database. Restore the database using the SQL Server Management Studio user interface. Open SQL Server Management Studio and connect to your SQL Server instance. It has changed the style completely with 2014, do watch the video to know about it.įROM disk= ‘C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak’ bak file attached and save it to the C: drive. Until 2012 Microsoft provided sample databases in format of mdf and ldf file downloads, a developer will download and attach the mdf and ldf file to install Adventure works 2012. Microsoft has launched Adventure Works 2014 database for its SQL Server 2014 version.