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.co...
🌟 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/sq...
🌟 SQL Server Basics Tutorial: http://www.mytecbits.com/microsoft/sq...
🌟 My Website: http://www.mytecbits.com
🌟 SQL Server Basics Video Playlist: • SQL Server Basics