Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL SERVER 2005 sample databases Expand / Collapse
Author
Message
Posted Monday, October 29, 2007 7:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2008 3:34 AM
Points: 45, Visits: 109
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
Post #416021
Posted Monday, October 29, 2007 7:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
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
Post #416029
Posted Monday, October 29, 2007 11:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2008 3:34 AM
Points: 45, Visits: 109
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?
Post #416295
Posted Monday, October 29, 2007 11:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: 2 days ago @ 3:58 AM
Points: 2,622, Visits: 327
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.

Post #416299
Posted Tuesday, October 30, 2007 2:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 42,443, Visits: 35,498
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 2008, MVP
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

Post #416348
Posted Tuesday, October 30, 2007 3:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
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
Post #416370
Posted Tuesday, October 30, 2007 3:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 20, 2008 3:34 AM
Points: 45, Visits: 109
thanks guys...the issue is resolved...the database was not attached...thats it...now its working fine..

gud work guys..
Post #416374
Posted Monday, April 14, 2008 12:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 21, 2009 10:27 PM
Points: 8, Visits: 26
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!
Post #484589
Posted Sunday, July 14, 2013 1:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 14, 2013 12:54 AM
Points: 1, Visits: 0
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.
Post #1473350
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse