SQL SERVER 2005 sample databases

  • 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

  • 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


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • 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?

  • 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.

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • thanks guys...the issue is resolved...the database was not attached...thats it...now its working fine..

    gud work guys..

  • 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!

  • 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