Revision as of 13:36, 23 May 2013

Opgaver

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

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

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

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

@@ Line 1: / Line 1: @@
 =Opgaver=
+==AdventureWorks Databasen==
+Databasen kan downloades fra CodePlex: http://msftdbprodsamples.codeplex.com/releases/view/93587 , Hent: '''AdventureWorks2008_Database.zip'''<br/>
+'''To attach an AdventureWorks database'''
+#Unzip the database (mdf) file and log (ldf) file.
+#From Microsoft SQL Server Management Studio, connect to a SQL Server instance.
+#Right click Databases.
+#Click Attach.
+#Click the Add button.
+#Locate the AdventureWorks database mdf file. For instance, AdventureWorks2012_Data.mdf.
+#Click the OK button on the Locate Database Files dialog window.
+#Click the OK button on the Attach Databases dialog window to attach the database.
 ==Torsdag==
 *Installer en ESXi server(Følg denne [[Installation_af_ESXi_v.5|guide]])