Thank you for your comments Andrew,
I was looking for others to chime in with their experiences as well. I am in a really bad spot here and don't have the full finances to do it right.
Maybe it is my setup (in SQL Server Management Studio) but the shared SQL2005 server doesn't give me any (other than Copy Database) options then SQL express. I have no DTS / SSIS capabilities. No replication, etc.
I can backup the database maunally (don't want to do that everyday, or more).
So I am at a loss as to how to handle my issues.
I looked at the pricing for SQL server and it is confusing. If I use a virtual webserver for my website and install SQL 2005 or 2008 I am not sure which package I need. Also CALs needed etc.
Would a website only need 1 CAL? I found a listing for SQL Server 2008 Standard 32/64-Bit (10-Client) Full Retail Box
Can you or someone tell me is that what I need?
Since I am currently using SQL2005(Express) and am comfortable with it. Can SQL2005 still be purchased? (and supported by MS?) I noticed a price of $6300 for the enterprise edition but $24 for the standard, Workgroup (32 bit) for $550 - $600.
I simply don't know what I need. If I need to provide more information about my site / senerio please advise.
I thank you as well as all others for their comments and suggestions.