Database Reference
In-Depth Information
viewing the name in your machine; as shown in Figure 1-1, the name you see
in parentheses on your system will be the folder name where you may want to
save the database files.
4. If you are not able to find the folder location that maps to the SQL Server
instance, you can choose to save the files at any location on your system.
5. After choosing the file location, the setup wizard will bring the
AdventureWorks_Data.mdf and AdventureWorks_Log.ldf files to your specified
location. Click Finish to close the wizard after the successful installation of the
files.
Attaching the AdventureWorks Sample Database
Attach is the process used to associate the .mdf file to the database server so that you can start working
with the database objects and data associated with tables.
You need to access SQL Server Management Studio to attach the AdventureWorks2008 database. To
do so, follow these steps:
1. Make sure you know your SQL Server instance name through which your SQL
Server is running; in my case, it's SQL2012, as you saw in Figure 1-1 earlier.
You can check your instance name as described earlier.
2. Open SQL Server Management Studio from your installed SQL Server 2012
application, and in the Connect to Server dialog box, enter localhost\<your
server name > as the server name (see Figure 1-2). In some cases, you may see
localhost being replaced by just a dot (.) or real machine name. (You can view
the machine name from your computer properties.)
Figure 1-2. Connect to Server dialog
 
Search WWH ::




Custom Search