Very Computer

by **Akshay** » Fri, 07 Sep 2001 01:44:05

Hi,
Is anybody running SQL 2K Standard Edition in production? Also if it is a
web site.
Our servers are 4cpu upto 2 gb. only other thing we need is log shipping
for which I guess we would do manual implementation. Does enterprise dition
provide us with anything extra.
Regrads,
AK

by **Bob Pfeif** » Fri, 07 Sep 2001 02:31:02

If you aren't taxing the 4 CPU/2GB machines with your web site, and manual
log shipping is feasible for your failover needs, then the standard edition
is probably fine. I've worked on several e-commerce sites that use standard
edition.

There is a matrix of features in books online that you should look at.

by **flicke** » Fri, 07 Sep 2001 05:37:12

You can manually set up log shipping with Std. Edition. Look at
http://www.sql-server-performance.com/sql_server_log_shipping.asp.
Enterprise Edition has Log Shiping built-in as part of Database Maintenance
Plans.

Quote:> Hi,
> Is anybody running SQL 2K Standard Edition in production? Also if it is a
> web site.
> Our servers are 4cpu upto 2 gb. only other thing we need is log shipping
> for which I guess we would do manual implementation. Does enterprise
dition
> provide us with anything extra.
> Regrads,
> AK

Very Computer

Standard Edition v/s Enterprise Edition ?

Standard Edition v/s Enterprise Edition ?

Standard Edition v/s Enterprise Edition ?

Standard Edition v/s Enterprise Edition ?