Companion Content for Training Kit (Exam 70-462): Administering Microsoft® SQL Server® 2012 Databases

Download the sample databases

To complete the practices in this training kit, you need to download two sample databases.

  1. Click the following links:

    Download the sample AdventureWorks2012 database

    Download the sample AdventureWorksDW2012 database

  2. For each database, the File Download dialog box opens.

  3. Click Save.

    The Save As dialog box opens.

  4. Choose a location where you want to store this sample database (.mdf file).

    IMPORTANT While you can save the .mdf file wherever you like, the practices in this Training Kit require that you use the C:\AdventureWorks2012 directory and C:\AdventureWorksDW2012 directory to store the databases. The examples in this book also assume this location for the databases.

Attach the sample databases

  1. Start SQL Server Management Studio (SSMS).
  2. Connect to your SQL Server 2012 instance.
  3. For each database:

  4. In Object Explorer, right-click the Databases node beneath your SQL Server 2012 instance and then choose Attach.
  5. Beneath Databases To Attach, click Add.
  6. In the Local Database Files dialog, scroll to the downloaded .mdf file that you saved locally, select it, and then click OK.

    IMPORTANT When using this method to attach, SSMS will by default also search for the .ldf file (which isn't included), causing the attach-process to fail. You must manually remove the .ldf file before clicking OK as discussed in the next step.

  7. Beneath the database details list, select the Log file (filename ending with .ldf) and then click Remove.
  8. Click OK.

Problems attaching sample databases

If you have problems attaching a sample database, you can find complete instructions for attaching databases here.

Support issues

Companion content is hosted for Microsoft Press by O'Reilly Media, distributor of Microsoft Press books. If you need assistance, please contact mspinput@microsoft.com or O'Reilly Customer Service.

Errata

The errata list is a list of errors and their corrections that were found after the product was released. Errors are submitted by our customers and are approved or disproved by the author or editor. They solely represent the opinion of the customer. View or submit errata.

Take our survey

Your feedback will help us make our books as informative, insightful, and useful as they can be. Click here to take the survey.

Book information

For more information about this book, visit this book's details.