SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installing Sample 2008 Databases - SQL School Videos


Installing Sample 2008 Databases - SQL School Videos

Author
Message
Brian Knight
Brian Knight
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: Moderators
Points: 8847 Visits: 235
Comments posted to this topic are about the item Installing Sample 2008 Databases - SQL School Videos

Brian Knight
Free SQL Server Training Webinars
David Reed-223505
David Reed-223505
SSC Eights!
SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)

Group: General Forum Members
Points: 932 Visits: 380
Brian, I'm glad y'all are doing this!! However, the details (specifically of download file selection) in that video have been out of date since October 2008. Wink We shipped Samples Refresh 1 on Halloween. Samples Refresh 2 will ship in the second quarter of this calendar, and will consist primarily of bug fixes.

Also, a minor clarification, most of the Books Online examples for SQL Server 2008 still use the original AdventureWorks databases (which is why we ship both versions together for Katmai). For the most part, only the BOL topics which need new features like FILESTREAM, geography, HierarchyID, etc, were updated to use the AdventureWorks2008 family of databases.

We're definitely working to streamline the AdventureWorksKilimanjaro experience, and we're planning to only ship one year-model family of databases for SQL Server Kilimanjaro.
bfready
bfready
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 4
Brian,

Thanks for the tutorial on installing the adventureworks sample db for SQLServer 2008. I have a questions though:

So, I wasn't able to get the database to install because it did not see the SQLServer 2008 instance. I did, indeed, have my instance running that I use to practice making and querying db's and it IS SQLServer 2008. I have the db icon on the the lower right and it has the green arrow and all (I know the service is running). Yet the .msi installation file doesn't see it? What am I doing wrong?

Also, I figured out how to put the database one manually by downloading the mdf and lbf files for adventureworks and attaching it through the SSMS. I'd like to point out that I am an absolute beginner and am trying to teach my self this stuff, so is simply attaching the mdf file a valid way to move or install databases? Is this all that the installation file is doing? Should I also be doing something else?

Thanks for your help!

Best Regards,
Bill
David Reed-223505
David Reed-223505
SSC Eights!
SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)SSC Eights! (932 reputation)

Group: General Forum Members
Points: 932 Visits: 380
Bill, which edition of SQL Server 2008 is your instance (that the SR1 installers can't see)? If it's the base model of Express, you'll need to update that to Express with Advanced Services (because AW2k8 requires iFTS and FILESTREAM that's not available in the base model).

Before I left SQLBU a couple weeks ago, I was working on updates to the SR2 installers. Since they haven't backfilled my old job yet, I'm still working on those in the moonlight, but the timeline's going to be longer than originally planned "Spring '09". If you're willing to try them out, the SR2 beta installers are up on CodePlex and are stable: they'll let you install only the databases that work on Express base model (or an instance that has iFTS or FILESTREAM disabled).
sneakwipe
sneakwipe
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 3
hi every body there is great reason to read and send these kind of resources to other friend because they always looking some good fourms.
thanks.....

the whole information is just wonderful. I really appreciate this effort of yours dear. its been great reading all this information of u.

642-357
1z0-051
1z0-052
70-450
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search