domingo, 18 de abril de 2010 12:52
I am newbie to SQL 2008, SQL at all :)
That is why I start study Trainig Kit 70-432. I have SQL 2008 server on virtual machine with 2008 server.
I have to install AdventureWorks2008 and AdventureWorksDW2008 from CodePlex website. I have not find those databases.
When I used those databases and code (from Training Kit)EXEC sp_configure 'filestream_access_level' , 2;GORECONFIGURERESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008.bak' WITH RECOVERY;GORESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak' WITH RECOVERY;GO
I received errorsConfiguration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.Msg 3201, Level 16, State 2, Line 2Cannot open backup device 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 15105).Msg 3013, Level 16, State 1, Line 2RESTORE DATABASE is terminating abnormally.Msg 3201, Level 16, State 2, Line 1Cannot open backup device 'C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak'. Operating system error 2(failed to retrieve text for this error. Reason: 15105).Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.
I will be thankful for any suggestion and help
Todas as Respostas
domingo, 18 de abril de 2010 20:09Moderador
The instructions provided in the Training Kit are based on a preliminary method we used to install AdventureWorks2008. Due to some problems we encountered with that method, the installation has since changed and the instructions in the book are invallid.
You can successfully install AdventureWorks2008 from the source that you found: AdventureWorks2008_SR4.exe. When you run the executable, you will get a Data Selection page, please verify that there is a check mark next to AdventureWorks OLTP 2008 and not a warning sign. If there is a warning sign, click the More Information button and correct the issues it lists.
Also, if you run into other errors, they may be Permissions related. You may need to run the executable with administrator permissions.
Hope that helps,
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights
- Marcado como Resposta roomasek segunda-feira, 19 de abril de 2010 08:03
segunda-feira, 19 de abril de 2010 08:04
Thanks Gail for your help
I found this topic as well
quarta-feira, 27 de julho de 2011 21:21
I have the same problem as roomasek. My question is, how many databases to be used to complete the book? Only AdventureWorks OLTP 2008 or all the databases in the SR4.exe file?
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
quarta-feira, 27 de julho de 2011 21:29Moderador
I believe that you only need the OLTP (AdventureWorks2008 database) and the data warehouse (AdventureWorksDW2008) for the training kit. You can skip the LT version and the Analysis Services project.
Please make sure that you follow the prerequisites information described on the page: http://msftdbprodsamples.codeplex.com/releases/view/37109. It will save you a great deal of trouble during the installation.
Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights
- Sugerido como Resposta Naomi NMicrosoft Community Contributor, Moderator quarta-feira, 27 de julho de 2011 22:44