每次我从CodePlex下载推荐的版本时,我得到的只是一个AdventureWorks2008.mdf文件.我不仅无法从sql Server Management Studio附加文件,而且无法将文件直接复制/粘贴到数据库中.
我在几个地方读过我需要使用AdventureWorks2008.msi,但我找不到下载它的位置.
我只是想不通如何安装AdventureWorks2008
谢谢你的帮助
解决方法
您需要创建数据库并附加.mdf文件,该文件是说明中提到的“数据文件”. (.mdf =主数据文件,.ldf =日志文件,.ndf =辅助数据文件)
要附加文件,您需要确保仔细按照此处的步骤操作:http://social.technet.microsoft.com/wiki/contents/articles/3735.sql-server-samples-readme-en-us.aspx#Readme_for_Adventure_Works_Sample_Databases
2008R2的说明:
To install AdventureWorks2008R2 OLTP database
Download the AdventureWorks2008R2 Data File.
From File Download,click Save and browse to a location on your local
server.From sql Server Management Studio,execute the following code:
Case-insensitive Database
CREATE DATABASE AdventureWorks2008R2 ON (FILENAME = '{drive}:\{file path}\AdventureWorks2008R2_Data.mdf') FOR ATTACH_REBUILD_LOG;
As an alternative to step 3,you can attach the database using the sql
Server Management Studio user interface. For more detailed
information,see 07001.Note: You must remove the log file from the list of files to attach.
This will cause the operation to rebuild the log.
Aaron Bertrand的头痛保护技巧:
You should place the mdf file in your normal data folder – sql Server
will already have the proper permissions. You can get this path using
SELECT TOP(1)physical_name FROM master.sys.database_files;