why Adventureworks database is empty for me?

Question

Post reply

why Adventureworks database is empty for me?

mark.haward

SSC Veteran

Points: 205
More actions
October 21, 2008 at 1:58 pm

#200161

Hi
I have installed the OLTP.msi file of Adventureworks database for SqlServer 2008
it is installed and is added to the list of databases
but when I use a simple SELECT statement, it returns no records for any of its tables
and actually its tables have no records in them
How can I solve this problem.
Thank you

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jerry Hung SSChampion Points: 12968 More actions · Answer 1

I remembered having this problem on x64 machines, but never bothered to figure it out

However, today, I installed (from CodePlex) on my SQL 2008 RTM box

SQL2008.AdventureWorks_OLTP_DB_v2008.x86.msi

and chose the "Restore DB for me" option

Just double checked in AdventureWorks DB, 182MB in size

and tons of data

Maybe try again?

Or manually restore the .BAK file if you can find one, or use the scripts-based installs (1 script + a bunch of CSV files)

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 2

Did you get errors or anything? I had a heck of a time installing the 2008 version of AdventureWorks until I had file streaming installed & configured.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jerry Hung SSChampion Points: 12968 More actions · Answer 3

I didn't configure FILESTREAM

but I did have to install Full-Text Search before I can restore AdventureWorks OLTP (the installer would tell you why it didn't install, I hope)

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

mark.haward SSC Veteran Points: 205 More actions · Answer 4

Thank you so much Jerry for reply.

I did what you had guided and I also used the "Restore..." option

as it is shown in the picture, it is installed but the Tables are still empty.

actually I gonna learn this and most of the examples on BOL and other books have used this database. :ermm:

thanks again.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 5

I'm not sure if it matters or not, but when I downloaded the 2008 version of AdventureWorks, it installed on all the machines where I've installed it so far as AdventureWorks2008. The fact that you're still seeing AdventureWorks suggests you might have the wrong version. Maybe that's the issue?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

mark.haward SSC Veteran Points: 205 More actions · Answer 6

thanks, but i installed the 2008 version 🙁

can any of you guys, please attach a Full backup of your Adventureworks database ( 2008 version)

so I can restore it on my machine

🙂

thank you

Jerry Hung SSChampion Points: 12968 More actions · Answer 7

My AdventureWorks2008.mdf is 184MB, don't think it's that easy to upload

You should still try to figure out why it was restored as empty

or try a different installer (or the non-installer scripts like SQL2008.AdventureWorks_All_DB_Scripts.x86.msi)

or try uninstall-and-reinstall?

http://www.codeplex.com/MSFTDBProdSamples

SQL Server 2008 samples (note the x86 and x64 versions)

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

I'd recommend you just download it again. I've pulled it from Codeplex twice and had no issues, although I did have to get iFTS and Filestream working.