October 29, 2007 at 7:43 am
i have been trying to download and install 'AdventureWorksDB' for SQL server 2005. the microsoft download center routed me to the below link on codeplex:
http://www.codeplex.com/MSFTDBProdSamples
When i downloaded the above said database from this link i couldnt install it as it was for SQL server 2008.
Can some one tell me from where i can download the correct version of the sample database?
I need this database as i can not run the tutorials for creating ETL packages.
thanks
Pankaj
October 29, 2007 at 7:59 am
On the above page in the top right corner click on "All Releases", and then on the next page in the same location click on "SQL Server 2005 SP2a"
A direct link is http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
Regards,
Andras
October 29, 2007 at 11:26 pm
I have downloaded and installed adventureworksDB for SQL server 2005 but still i cant see it in my databases in my management studio.
When i try to create a OLE DB connection manager, i cant see the adventurworksDB in the local host.
Can some one help me in resolving the issue?
October 29, 2007 at 11:54 pm
go to entrprs mgr, chk for the advtur db is in SUSPECT MODE. If so, then remove the un-wanted files from the server and move to the remote drive where the same can't be accessed by the users.
October 30, 2007 at 2:17 am
I think all the installer does is drop the files in SQL's data directory. Assuming default installation, you'll find them in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Go to management studio and attach the db (right click Databases, select attach, browse to the mdf, select it, then follow the dialog.)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 30, 2007 at 3:09 am
Gail is right about the installer for SQL Server 2005 not attaching the sample database. This information is also on the download page I included :
"These installers require you to manually attach the database after installation. See the Release Notes for details."
The release notes on that page also give you step-by-step information about how to attach the database.
if you install the sample database files to the C:\Program Files\Microsoft SQL Server\MSSQL.\MSSQL\Data\ path, then you can attach the sample database with:
exec sp_attach_db @dbname = N'AdventureWorks',
@filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf',
@filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'
it is nice to see that for SQL Server 2008 the installer will take care of the above.
Regards,
Andras
October 30, 2007 at 3:15 am
thanks guys...the issue is resolved...the database was not attached...thats it...now its working fine..
gud work guys..
April 14, 2008 at 12:28 pm
I've been looking, reading info and installing sample databases etc, etc for the last 4 hours.
MSDN sure puts out a lot of bogus information. All instructions I've tried, just don't work.
Except yours. thank you. Very much!
July 14, 2013 at 1:05 am
you just installed....you have to attach the database from database management studio. right click on database object in object explorer and click on attach..it will show browsing window then select mdf file of the database yu had downloaded...then checkout the database in your object explorer.
note: when you select the mdf file of the database it will read ldf file also.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply