can't use AdventureWorks databases.

Question

1) Hi, I downloaded "SQL2008.AdventureWorks_All_Databases.x86.msi" and installed successfully, but I don't see any bak files in those folders.

2) I ran this code as this thread http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/8f98552f-a3c3-4e1c-b655-860d921f7010

BACKUP DATABASE ADVENTUREWORKS2008 TO DISK = 'C:\Program Files\Microsoft SQL Server\100\Tools\



Samples\AdventureWorks2008.bak'

but it generated errors:

Msg 911, Level 16, State 11, Line 1



Database 'ADVENTUREWORKS2008' does not exist. Make sure that the name is entered correctly.







Msg 3013, Level 16, State 1, Line 1



BACKUP DATABASE is terminating abnormally.

3) I want to run this code in "SQL Server Step by Step" published by Microsoft Press:

EXEC sp_configure 'filestream_access_level',2;



RESTORE DATABASE AdventureWorks FROM DISK='C:\Program Files\



Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008.bak' WITH RECOVERY;



GO







RESTORE DATABASE AdventureWorksDW FROM DISK='C:\Program Files\



Microsoft SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak' WITH RECOVERY;



GO

I'm using SQL Server 2008 Express.
Sorry I'm newbie, thank you.

Answer 1

If the installation had actually been successful the AdventureWorks2008 databases would already be attached to your instance of SQL Server 2008 Express and you would not need to restore from backup.  So, let's assume that the installation failed.  Please perform the following steps:

1.  Read the prerequisite information for installing the sample databases and (http://msftdbprodsamples.codeplex.com/Wiki/View.aspx?title=Database%20Prerequisites) and follow all instructions.

2. Read and follow the installation instructions for installing the sample databases: http://msftdbprodsamples.codeplex.com/Wiki/View.aspx?title=Installing%20Databases

3.  Assuming you do not see any error messages during the installation process, you should be able to open SQL Server Management Studio and see the AdventureWorks databases in the Databases folder of Object Explorer.  Alternatively, you can run the query SELECT * FROM sys.databases and it should list these databases.


Kind regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights