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, 12705🔥, 1💬
Popular Posts:
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...