/3gb memory switch

The properties of sql server (EE 2000) show that the
instance is set to dynamically allocate 0 - 3895 MB.
There are 4gb of ram on the server. However, the /3gb
memory switch is not set in the boot.ini file. It looks
like that this is what is happening -- sql server
recognizes all of the memory in the server, but the OS
prevents user processes from utilizing more than 2 GB. Is
this as expected? I'm getting ready to set the /3gb
switch and need a little reassurance. It is also my
understanding, that AWE does not need to be enabled when
dealing with a server with only 4GB of RAM. The only
change I need to make is the /3gb switch in the boot.ini
file -- can someone confirm?You are correct. /3B switch will allow the SQL process to use 3GB of user
memory instead of 2GB user memory.
AWE is for servers with greater than 4GB of physical memory.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:f92301c3f197$e266ced0$a501280a@.phx.gbl...
> The properties of sql server (EE 2000) show that the
> instance is set to dynamically allocate 0 - 3895 MB.
> There are 4gb of ram on the server. However, the /3gb
> memory switch is not set in the boot.ini file. It looks
> like that this is what is happening -- sql server
> recognizes all of the memory in the server, but the OS
> prevents user processes from utilizing more than 2 GB. Is
> this as expected? I'm getting ready to set the /3gb
> switch and need a little reassurance. It is also my
> understanding, that AWE does not need to be enabled when
> dealing with a server with only 4GB of RAM. The only
> change I need to make is the /3gb switch in the boot.ini
> file -- can someone confirm?

/3gb memory switch

The properties of sql server (EE 2000) show that the
instance is set to dynamically allocate 0 - 3895 MB.
There are 4gb of ram on the server. However, the /3gb
memory switch is not set in the boot.ini file. It looks
like that this is what is happening -- sql server
recognizes all of the memory in the server, but the OS
prevents user processes from utilizing more than 2 GB. Is
this as expected? I'm getting ready to set the /3gb
switch and need a little reassurance. It is also my
understanding, that AWE does not need to be enabled when
dealing with a server with only 4GB of RAM. The only
change I need to make is the /3gb switch in the boot.ini
file -- can someone confirm?You are correct. /3B switch will allow the SQL process to use 3GB of user
memory instead of 2GB user memory.
AWE is for servers with greater than 4GB of physical memory.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:f92301c3f197$e266ced0$a501280a@.phx.gbl...
> The properties of sql server (EE 2000) show that the
> instance is set to dynamically allocate 0 - 3895 MB.
> There are 4gb of ram on the server. However, the /3gb
> memory switch is not set in the boot.ini file. It looks
> like that this is what is happening -- sql server
> recognizes all of the memory in the server, but the OS
> prevents user processes from utilizing more than 2 GB. Is
> this as expected? I'm getting ready to set the /3gb
> switch and need a little reassurance. It is also my
> understanding, that AWE does not need to be enabled when
> dealing with a server with only 4GB of RAM. The only
> change I need to make is the /3gb switch in the boot.ini
> file -- can someone confirm?

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public(selected)
- db_owner(selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.
hi,
u can set a trigger on restorebackup table.
hope this help
from
doller
|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public (selected)
- db_owner (selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.hi,
u can set a trigger on restorebackup table.
hope this help
from
doller|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public (selected)
- db_owner (selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.hi,
u can set a trigger on restorebackup table.
hope this help
from
doller|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.

**Error 21776 for login Sa**

Hi
I'm working with SQL 2000 and I want to view the properties of Sa login by
right clicking on it ,but when I did it ,at first a following message
appearred before the properties window,
'Error 21776 : the name dbo was not found in the users collection. if the
name is a qualified name use [] to separate various parts of the name and
try again.'
and when I went to the last tab of properties for some of my databases just
'public' access was selected for sa!! and when I want to select db_owner too
above error again happened,
how can I repair my problem?
Any help would be greatly thanful.MR
http://www.cryer.co.uk/brian/sqlserver/error21776.htm
"M R" <rezvani@.parskhazar.net> wrote in message
news:%23CMqJJ4UFHA.2168@.TK2MSFTNGP10.phx.gbl...
> Hi
> I'm working with SQL 2000 and I want to view the properties of Sa login by
> right clicking on it ,but when I did it ,at first a following message
> appearred before the properties window,
> 'Error 21776 : the name dbo was not found in the users collection. if the
> name is a qualified name use [] to separate various parts of the name and
> try again.'
> and when I went to the last tab of properties for some of my databases
just
> 'public' access was selected for sa!! and when I want to select db_owner
too
> above error again happened,
> how can I repair my problem?
> Any help would be greatly thanful.
>