Database Rael

From Teknologisk videncenter
Revision as of 14:36, 23 May 2013 by Rael (talk | contribs) (→‎Opgaver)
Jump to: navigation, search

Opgaver

AdventureWorks Databasen

Databasen kan downloades fra CodePlex: http://msftdbprodsamples.codeplex.com/releases/view/93587 , Hent: AdventureWorks2008_Database.zip
To attach an AdventureWorks database

  1. Unzip the database (mdf) file and log (ldf) file.
  2. From Microsoft SQL Server Management Studio, connect to a SQL Server instance.
  3. Right click Databases.
  4. Click Attach.
  5. Click the Add button.
  6. Locate the AdventureWorks database mdf file. For instance, AdventureWorks2012_Data.mdf.
  7. Click the OK button on the Locate Database Files dialog window.
  8. Click the OK button on the Attach Databases dialog window to attach the database.

Torsdag

  • Installer en ESXi server(Følg denne guide)
    • Installer en Windows Server 2008 og en Windows 7 maskine.
  • Installer og konfigurere SQL Server Instance
    • Følg practice på side 22
  • Installer AdcentureWorks Samble Database
    • Følg practice på side 25
  • Create Databases
    • Følge Pracice på side 44
  • Changing Database Recovery Model
    • Følge Pracice på side 52
  • Checking Database Integrity
    • Følge Pracice på side 56

Notater


Alt materiale ligger på \\mercstor\elev\kursus\Databaser find guide til hvordan du opretter forbindelse Her

Retrieved from "http://mars.merhot.dk/w/index.php?title=Database_Rael&oldid=25374"