Collections:
AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
How to download and install the scaled-down database AdventureWorksLT in SQL Server?
✍: FYIcenter.com
If you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first:
1. Go to the SQL Server 2005 Samples and Sample Databases download page.
2. Go to the x86 section in the Instructions section, Click "AdventureWorksLT.msi -- 2,251 KB" to download the sample file. Save the download file to c:\temp.
3. Double click on the downloaded file: c:\temp\AdventureWorksLT.msi. The installation setup window shows up. Follow the instructions to finish the installation.
When the installation is done, two physical database files are installed in the data directory: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data:
AdventureWorksLT_Data.mdf 5,120 KB AdventureWorksLT_Log.ldf 2,048 KB
⇒ Attaching AdventureWorksLT Physical Files to the Server in SQL Server
⇐ Downloading and Installing SQL Server Sample Scripts in SQL Server
2019-08-04, 12654🔥, 1💬
Popular Posts:
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...