Error threads

Question

Hi,  SQL is new  thing for me and dont really know how to fix these problmes or know where is the problem.
If someone can help, I would appreciate it.

Ok, here is the code.
I have downloaded and installes Adwentureworks 2008 in my computer and of course SQL-server.

EXEC sp_configure 'filestream_access_level', 2;
GO
RECONFIGURE
GO
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

and it gives these errors:

Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft SQL
Server\100\Tools\Samples\AdventureWorks2008.bak'. Operating system error 123(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Program Files\Microsoft
SQL Server\100\Tools\Samples\AdventureWorksDW2008.bak'. Operating system error 123(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Answer 1

Does the file "C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks2008.bak" really exist on the server?

Moving to a more appropriate forum as well.

---

http://www.sqlis.com | http://www.konesans.com

Answer 2

Nope, there is no AdventureWorks2008.bak file there. How can I get that to there?