Difference between revisions of "Database Rael"
From Teknologisk videncenter
m (→Notater) |
m (→Opgaver) |
||
Line 1: | Line 1: | ||
=Opgaver= | =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== | ==Torsdag== | ||
*Installer en ESXi server(Følg denne [[Installation_af_ESXi_v.5|guide]]) | *Installer en ESXi server(Følg denne [[Installation_af_ESXi_v.5|guide]]) |
Revision as of 14:36, 23 May 2013
Opgaver
AdventureWorks Databasen
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.
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