468,458 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,458 developers. It's quick & easy.

SQL Memory Issues - Need Advice

We are currently using SQL 2000 Standard with W2K Standard and the
server has 3Gb of RAM. SQL is currently occupying 1.85Gb of memory
which I believe is the maximum for this version of the OS. I believe I
am at my limitations with my current versions of software. My
questions are:
1) Is the version of SQL Standard actually different than the
Enterprise edition. Will my database run on Enterprise if it runs on
Standard?
2) The same questions goes for the operating system? If my code runs
on W2k Standard will it run on Advanced Server?

Thanks a lot...

Jul 23 '05 #1
4 1213
Standard and Enterprise run exactly the same. The only difference is
when you upgrade to Enterprise you unlock the other features (memory
size, log shipping, etc.). Your code will also run exactly the same if
you upgrade to W2K Advanced Server from W2K Server.

Jul 23 '05 #2
Do you know if you can do a upgrade or a complete reinstall of both the
OS and the version of SQL?

Jul 23 '05 #3
You can do an upgrade of SQL Server with no problem. When you put in
the SQL EE disk and run the setup it will ask if you if you want to
upgrade. It will take about 2 minutes and then viola.

I recommend performing a complete reinstall of the OS if you upgrade.
This will mean you need to completely reinstall SQL Server though. If
you need to upgrade in place, do the OS first, reboot and then do the
SQL upgrade.

Jul 23 '05 #4

<in*******@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Do you know if you can do a upgrade or a complete reinstall of both the
OS and the version of SQL?


As far as I know, you can run the Enterprise setup program, and there's an
option to Upgrade. Although of course if you want or need to reinstall the
OS then you'll have to reinstall MSSQL anyway - you can use just backup your
databases and then restore them on the new installation.

If you do upgrade your MSSQL installation, and you're planning on using log
shipping, then see this KB article:

http://support.microsoft.com/default...b;en-us;295306

Simon
Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by john.livermore | last post: by
1 post views Thread by russ | last post: by
9 posts views Thread by Rafael Charnovscki | last post: by
7 posts views Thread by David Jacques | last post: by
reply views Thread by John Linn | last post: by
81 posts views Thread by Peter Olcott | last post: by
27 posts views Thread by George2 | last post: by
22 posts views Thread by Peter | last post: by
reply views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.