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, 16434🔥, 1💬
Popular Posts:
How to detect the collation coercibility associated to a given character string using the COERCIBILI...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...