On 64 bit operating system, the default backup folder will be like C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\.Place the backup file ( AdventureWorks2014.bak) under the default SQL Server 2014 backup folder.
This database will be helpful for those who are new and learning relational database management systems (RDBMS).Įvery new version of SQL Server has a corresponding version of sample database. The scenarios included in the sample database are manufacturing, product management, sales, purchasing, contact management and human resources. This sample database and the data is developed for a fictional bicycle company called Adventure Works Cycles. It is meant for standard online transaction processing scenarios. The AdventureWorks database is a sample database initially introduced by Microsoft for beginners to learn SQL Server with the sample data and database objects like the tables, indexes, triggers, stored procedures, functions, etc. Currently, AdventureWorks sample database is available in CodePlex as open source. For this purpose, Microsoft has introduced the AdventureWorks Sample Database. It will be very helpful to have a sample database while learning SQL Server. For training purpose, we need a database with some sample data. Now the SQL Server and the management studio are ready for using.