What is SQL Server AdventureWorks?

AdventureWorks Database is a Microsoft product sample for an online transaction processing (OLTP) database. AdventureWorks Database is also used in code examples found in SQL Server documentation and books. There are also versions for SQL Azure and SQL Server 2005.

What is AdventureWorks?

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from github site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005. The Microsoft team keeps updating the sample database as they release new versions.

What is the use of AdventureWorks database?

About the AdventureWorks database The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.

How do I install an AdventureWorks database?

Instructions for downloading and installing the AdventureWorks Database:

Right-click Databases and select Restore Database…
On the General page, use the Source section to specify the source and location of the backup sets to restore.
Select Device.
Click the browse (…)
Click Add.

How do I add Adventureworks to SQL Server 2014?

Open SQL Server (I am using SQL Server 2014) and right click on “Restore Database”. Select the device and click on the ellipses icon to select the backup media. Click on Add button and select the backup file (Downloaded and extracted earlier in the above steps). After selecting the database, click on “OK” button.

What is OLTP example?

An OLTP system is an accessible data processing system in today’s enterprises. Some examples of OLTP systems include order entry, retail sales, and financial transaction systems. OLTP is often integrated into service-oriented architecture (SOA) and Web services.

How do I add AdventureWorks to SQL?

MSSQLSERVER\MSSQL\Backup . Open SQL Server Management Studio (SSMS) and connect to your SQL Server. Right-click Databases in Object Explorer > Restore Database… to launch the Restore Database wizard. Select Device and then select the ellipses (…) to choose a device.

How to install adventureworks?

Download “Adventure Works” sample database from CodePlex at Adventure Works for SQL Server 2012 by select AdventureWorks2012 Data File.

Place the downloaded file (the MDF file) to your database folder.

Open SQL Server Management Studio as Administrator.

Connect to the SQL Server and click on New Query.

How do I restart Microsoft SQL Server?

In SQL Server Configuration Manager, in the left pane, click SQL Server Services. In the results pane, right-click SQL Server Browser, or SQL Server Agent (MSSQLServer) or SQL Server Agent ( ) for a named instance, and then click Start, Stop, Pause, Resume, or Restart.

How to add adventureworks database?

Download AdvetureWorks Database 2012.

Copy AdventureWorksDW2012_Data.mdf to your default database directory (normally\\Program Files\\Microsoft SQL Server\\MSSQL11.MSSQLSERVER\\MSSQL\\DATA) or other location as designated by your database administrator.

Open SQL Server Management Studio.

Connect to the database engine.

How to backup SQL Server?

Step 1. Open SSMS and connect to the SQL Server.

Step 2. Expand Databases and select the required database.

Step 3. Right click on the database >> Tasks >> Backup.

Step 4. In Back Up Database window,select the Backup Type as Full and under Destination,select Back up to : Disk.

Step 5. Select the Remove button.