Trying to better understand how ASM works in a SQL 2008 on a 2008 Windows server. Has anyone done it succesfully?

Hey Sruiz39,

That's a good suggestion for something we should try and get up here on the site... I'll see if I can't get one recorded, although it probably won't be quick enough for your needs.

Have you seen the 44 page Technical Report on the EqualLogic support website (Page 9 has setup best practices):

SQL Server Data Protection with Auto-Snapshot Manager/Microsoft Edition
This Technical Report describes using Auto-Snapshot Manager/Microsoft Edition with Microsoft® SQL Server® to perform online Smart Copy protection and recovery operations for SQL Server databases using PS Series arrays.

The site is here:
https://www.equallogic.com/support/tech_reports.aspx#db

If you aren't registered with the website, please do -- it's free if you are current on support.

http://www.equallogic.com/resourcecenter/assetview.aspx?id=6643 this is a demo video

Yes, I use it on all my SQL 2008 servers, and it works very well. Anything in particular you are unsure about?