| Author |
SQL Memory Issues - Need Advice
|
|
| interflex@hotmail.com 2005-05-27, 11:23 am |
| 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...
| |
| joshsackett 2005-05-27, 11:23 am |
| 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.
| |
| interflex@hotmail.com 2005-05-27, 1:23 pm |
| Do you know if you can do a upgrade or a complete reinstall of both the
OS and the version of SQL?
| |
| joshsackett 2005-05-27, 1:23 pm |
| 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.
| |
| Simon Hayes 2005-05-27, 1:23 pm |
|
<interflex@hotmail.com> wrote in message
news:1117212617.824406.182680@z14g2000cwz.googlegroups.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/defaul...kb;en-us;295306
Simon
|
|
|
|