AdventureWorksDW2008下载地址和如何附加到数据库SQLServer2008
中，只求使用方案
------解决方案--------------------
下载地址
http://msftdbprodsamples.codeplex.com/releases/view/55926
默认安装在
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
然后附加就可以了
create database AdventureWorksDW2008
on primary(
name = data,
filename = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\xxx.mdf'
),
on log(
name = log,
filename = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\xxx.ldf'
)
或者
用语句进行恢复:
EXEC sp_attach_db @dbname = test ',
@filename1 = 'd:\mssql7\data\test_data.mdf ',
@filename2 = 'd:\mssql7\data\test_log.ldf '