Sample Databases for Microsoft SQL Server 2008R2 (SR1)

Question

Hi-

Is there a backup version of AdventureWorks2008R2(OLTP) available anywhere to download and restore? This FileStream feature is a killer.

I'm trying to installing it on a VM over a trial version of Sql Server 2008 R2(which installed beautifully).

I followed all the instructions/tips/tricks before trying to install the OLTP version of AdventureWorksR2, but it sort of freezes. it installs the other two(DW and LT version like a charm).

MSSqlServer service account is "LocalSystem".

Windows Login account has Administrator rights.

OS is Windows XP with the latest Service Pack.

All the OS and Sql srver patches are installed.

the AV software is disabled for this process.

 

Please hep!

 

Thanks,

Ramin

 

Answer 1

No answer yet. Seems nobody knows what to do with this damn' thing :-P

 

Answer 2

Hi,

try to download version for Denali from codeplex and attach it. I think it's the same as for SQL 2008 R2 and you can skip that installer

http://msftdbprodsamples.codeplex.com/releases/view/55330

 

Jiri

Answer 3

Hi Ramin,

I am going to post just a MDF file for the AdventureWorks2008R2 OLTP database that does not contain the filestream property.  You should be able to download that file and attach it to your instance of SQL Server 2008 R2.

I should have it posted to Codeplex by the end of this week.  I'll follow up with this thread when the file is available.

Regards,

Gail

---

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

Answer 4

You can download and attach a version of AdventureWorks2008R2 OLTP database that does not contain filestream properties from this location http://msftdbprodsamples.codeplex.com/releases/view/59211.

Regards,

Gail

---

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