Sql Server to MSDE - good choice?

[Mark]

Hi - I have a rather unreliable host just now - but they offer .net, sql
server and SSL for a reasonable price.

Problem is, the domain is hosted on a shared server - and it keeps going
down apparantly because of code which is less than clean, on some
peoples sites. (ie. not closing connections etc).

I am considering moving to a decicated server - but at this point in
time, cannot afford a full SQL Server licence for it - however, the
dedicated server does offer MSDE. Is it acceptable to go back to using
this from SQL Server - for a currently low hit site - ie. around 500
hits per day.

Does MSDE offer stored procedures (I don't use views or triggers)? Can
I just take a DTC backup/export of my current SQL Server database, and
restore it to the MSDE one?

What would be the cut-off point for using MSDE?

Thanks for any info - also, if anyone knows why UK companies charge so
much more dor dedicated servers, than US companies - I'd be interested.

Thanks, Mark

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Lyle Fairfield]

Re: Sql Server to MSDE - good choice?

Mark <anonymous@devd ex.com> wrote in news:41691aa2$0 $24925
$c397aba@news.n ewsgroups.ws:

DiscountASP.Net is cheap for shared hosting. It hosts two sites for me.
Down time during a year has been zero per cent. It provides .Net, classical
ASP and MS-SQL 2000 and some other goodies.
For several years previously, Interland hosted my sites. I have found
DiscountASP to be one-third the cost and three times more reliable and
responsive. Its e-mail hosting is much more reliable and facile.

I am not associated with DiscountASP.

[Simon Hayes]

Re: Sql Server to MSDE - good choice?


"Mark" <anonymous@devd ex.com> wrote in message
news:41691aa2$0 $24925$c397aba@ news.newsgroups .ws...[color=blue]
> Hi - I have a rather unreliable host just now - but they offer .net, sql
> server and SSL for a reasonable price.
>
> Problem is, the domain is hosted on a shared server - and it keeps going
> down apparantly because of code which is less than clean, on some
> peoples sites. (ie. not closing connections etc).
>
> I am considering moving to a decicated server - but at this point in
> time, cannot afford a full SQL Server licence for it - however, the
> dedicated server does offer MSDE. Is it acceptable to go back to using
> this from SQL Server - for a currently low hit site - ie. around 500
> hits per day.
>
> Does MSDE offer stored procedures (I don't use views or triggers)? Can
> I just take a DTC backup/export of my current SQL Server database, and
> restore it to the MSDE one?
>
> What would be the cut-off point for using MSDE?
>
> Thanks for any info - also, if anyone knows why UK companies charge so
> much more dor dedicated servers, than US companies - I'd be interested.
>
> Thanks, Mark
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

Check out the information here:

http://www.microsoft.com/sql/msde/default.asp

MSDE is a throttled version of MSSQL - the most significant limitations are
that the database size (meaning data files only, not the log) is limited to
2GB, and there's a workload governor which limits performance when more than
8 connections are active simultaneously (even with many connections, most of
them might be idle most of the time anyway).

Most of the functionality which doesn't exist in MSDE is 'enterprise' stuff
like clustering, indexed views, analysis services etc. (see "Features
Supported by the Editions of SQL Server 2000" in Books Online), so if you're
using 'standard' TSQL functionality, you should be OK. Backup/restore should
work fine, as should DTS, bcp.exe, replication etc.

Simon