max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

Master.dbf restore problems.

Over the weekend we did a hardware upgrade to our DB
server and some drives did change. We have setup most of
the DB back again, but the security is still in the
master.mdf file. If we restore this file back we will
loose everything that is working now. anyone know how to
export the security tables without blowing everything away
again.
ThanksAlex,
That is a situation where it really pays to test first<g>. Here are some
links that may be of interest:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
Andrew J. Kelly
SQL Server MVP
"Alex" <alex.chadwick@.cma.ca> wrote in message
news:032a01c33f37$3aa37d50$a101280a@.phx.gbl...
> Over the weekend we did a hardware upgrade to our DB
> server and some drives did change. We have setup most of
> the DB back again, but the security is still in the
> master.mdf file. If we restore this file back we will
> loose everything that is working now. anyone know how to
> export the security tables without blowing everything away
> again.
> Thanks