Reinstalling of Sample database( AdventureWorks - OLTP) in SQL 2005

Hi All,
I was successfully installing sample database AdventureWork on my server the
first time, But realized that I didn't install with all the features with it
.
I delete the DB and try to reinstall it with all the features. it goes
through all the steps but DB don't install or attach. There isn't any error
messages.
I'm trying to install it so that I can use or test the Partition script that
come with it (PartitionAW.sql). Since I'm trying to partition my database.
How do I fix this problem or resolve it?
Thanks for your help.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1I was able to reinstall Adventureworks Sample database using instawdb.sql bu
t
can't find PartitionAW.sql. The version of Sql2005 that I have is a
developer's version. I'm wandering if it doesn't come with the partitioning
script.
Does anyone knows how I can get this script to run or test it in Sql2005.
Thanks.
Naana wrote:
>Hi All,
>I was successfully installing sample database AdventureWork on my server th
e
>first time, But realized that I didn't install with all the features with i
t.
>I delete the DB and try to reinstall it with all the features. it goes
>through all the steps but DB don't install or attach. There isn't any error
>messages.
>I'm trying to install it so that I can use or test the Partition script tha
t
>come with it (PartitionAW.sql). Since I'm trying to partition my database.
>How do I fix this problem or resolve it?
>Thanks for your help.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1

Registering AdventureWorks

The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:\ProgramFiles\Microsoft SQL Server\90\Tools\Samples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection Properties" tab of New Server Registration.

I am familiar with database development as it relates to MS Access but I realize this is a whole new ball of wax. Any advise would be appreciated as it relates to this problem but also any information, i.e., very basic books on learning SQL Server would also be appreciated.

Treasa

The database samples only install as physical files, they are not attached to the SQL Server process. If you want to use them, go in the SSMS and right click on the Database node, choose All Tasks and click Attach database.. Locate the MDF File and the LDF File and click Apply (or OK). SQL Server will attach the databases to the SQL Server process and you can access the data.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

I advice you to uninstall 2005 and install it again. When you

running the setup push the advanced options and choose the option of books online and samle database also (at the bottom) and make it available at setup. this will help you to save lots of time.

Tomer

|||

another option is when you install the adventureworks install in with attach option - this way it will attach the database dierctly to your sql server. Also try and see if you have under msql folder --> data a file name adventureworks.mdf --> if you have it you need to attach it by right click on the server container and all tasks attach and choose the mdf file.