Installing AdventureWorks Sample Database in SQL Server:
Choosing, downloading and installing or restoring AdventureWorks Sample Database for SQL Server 2014 for learning SQL Server functionalities.
🌟 AdventureWorks Download URL: https://msftdbprodsamples.codeplex.com/releases/view/125550
🌟 Database Restoring Script:
USE master
RESTORE DATABASE AdventureWorks2014
FROM disk =
'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak'
WITH MOVE 'AdventureWorks2014_data' TO
'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf',
MOVE 'AdventureWorks2014_Log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf',
REPLACE
🌟 Detailed Article: http://www.mytecbits.com/microsoft/sql-server/installing-adventureworks-sample-database
🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sql-server/sql-server-basics-tutorial
🌟 My Website: http://www.mytecbits.com
🌟 SQL Server Basics Video Playlist: https://www.youtube.com/playlist?list=PLEA-BJFmprMbrycyfgNXiUFmHCxeCVUzR
