Danilo Brambilla's questions

I need to set the Exchange mailbox property ProhibitSendQuota equal as the ProhibitSendReceiveQuota, but my powershell fails as follows:

Get-Mailbox -Identity 'name.surname' | Set-Mailbox $_ -ProhibitSendQuota "$_.ProhibitSendReceiveQuota" -WhatIf

WARNING: The object has been corrupted, and it's in an inconsistent state. The following validation errors happened:
WARNING: The value of property 'ProhibitSendReceiveQuota' must be greater than or equal to that of property 'ProhibitSendQuota'. ProhibitSendReceiveQuota: '3.796 GB (4,075,520,000 bytes)', ProhibitSendQuota: '3.815 GB (4,096,000,000 bytes)'.

Cannot process argument transformation on parameter 'ProhibitSendQuota'. Cannot convert value ".ProhibitSendReceiveQuota" to type "Microsoft.Exchange.Data.Unlimited`1[Microsoft.Exchange.Data.ByteQuantifiedSize]". Error: "The string '.ProhibitSendReceiveQuota' isn't correctly formatted. It can contain a number with an optional unit specifier or the long ByteQuantifiedSize format. Examples include "12345", "104 MB", and "1 KB". Using the short format limits the string to 15 digits. However, the long format supports strings up to the maximum ByteQuantifiedSize value."
+ CategoryInfo          : InvalidData: (:) [Set-Mailbox], ParameterBindin...mationException
+ FullyQualifiedErrorId : ParameterArgumentTransformationError,Set-Mailbox

Any suggestion? Many thanks in advance for help!

Is it safe to optimize a SQL Server 2005 SAP R/3 database using Database Tuning Advisor raccomandatations? We are experiencing very low performance on a dedicated SAP database because of intense read operations ad the db and DTA suggest to create about 25 indexes and 100 stats. I am not an expert of SAP and I am quite surprised to see that this database has about 56.000 tables and 6500 views (120 GB of data).

Thank you all for help

I am going to start a migration from and Exchange 2003 cluster to a new Exchange 2010 SP2 with 14 mailbox databases of a supposed maximum size of about 400 GB each. Each database will be divided into 2 LUNS, data and transaction logs. LUN size takes into account to leave about 20% of free space to avoid monitoring alerts. As mailboxes will be distributed randomly during migration, how can I be sure that 400 GB database size limit will not be exceeded? And after migration, as mailboxes will grow time by time, how to make Exchange respect database size limits?

If I have a two nodes Exchange 2010 DAG stretched over two sites with DAC mode enabled and all databases active on primary site, I would still be able to activate some databases on the secondary site without do a complete datacenter switchover?

How do I check for remaining days of Remote Desktop Services grace period if the server is also a Domain Controller (so I cannot logon as local admin)?

Does it make sense to place DAG members in different sites when the witness server must stay in one of them? Think to this configuration: two DAG mailbox servers, one into primary site with witness folder on a HUB/CAS server and the second mailbox server in DR site and a very very fast and secure dedicated line between them. All users are into primary site, so all databases would be always active on primary mailbox server, with all passive copies on secondary mailbox server. In the case of failure of primary site, suppose both primary mailbox server and witness go down, will be the secondary mailbox server able to support users?

Is it supported to install a Certification Authority service on a Windows Server 2008 R2 joined on a 2003 native functional level domain?

If I logon to Exchange servers using the local Administrator account and I open EMS it results in this error:

[server.domain.local] Connecting to remote server failed with the following error message : WinRM cannot process the r
equest. The following error occured while using Kerberos authentication: A specified logon session does not exist. It m
ay already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or us
e HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
 see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (System.Manageme....RemoteRunspace:RemoteRunspace) [], PSRemotingTransportExc
   eption
    + FullyQualifiedErrorId : PSSessionOpenFailed
Exception calling "GetComputerDomain" with "0" argument(s): "Logon failure: unknown user name or bad password.
"
At P:\Program Files\Microsoft\Exchange Server\V14\bin\ConnectFunctions.ps1:204 char:70
+     [System.DirectoryServices.ActiveDirectory.Domain]::GetComputerDomain <<<< ().Forest.Name
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

Exception calling "GetComputerSite" with "0" argument(s): "Logon failure: unknown user name or bad password.
"
At P:\Program Files\Microsoft\Exchange Server\V14\bin\ConnectFunctions.ps1:164 char:92
+     $localSite=[System.DirectoryServices.ActiveDirectory.ActiveDirectorySite]::GetComputerSite <<<< ()
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

Exception calling "FindAll" with "0" argument(s): "Unknown error (0x80005000)"
At P:\Program Files\Microsoft\Exchange Server\V14\bin\ConnectFunctions.ps1:253 char:17
+     $search.FindAll <<<< ()
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

You cannot call a method on a null-valued expression.
At P:\Program Files\Microsoft\Exchange Server\V14\bin\ConnectFunctions.ps1:146 char:33
+                 $siteName = $siteDN.ToString <<<< ().SubString(3).Split(",")[0]
    + CategoryInfo          : InvalidOperation: (ToString:String) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

WARNING: No Exchange servers are available in the Active Directory site . Connecting to an Exchange server in another
Active Directory site.
Failed to connect to an Exchange server in the current site.
Enter the server FQDN where you want to connect.:

If I logon to Exchange servers using the domain Administrator account and I open EMS it works fine.

Also opening EMC from local Administrator fails but if I open it from domain Administrator user account it works fine.

Environment: Exchange 2010 SP1 CU4 single-site two-server configuration, with both servers running CAS/HUB and MAILBOX roles. I use DAG to achieve HA and a hardware balancer to balance the CAS roles. No Edge role nor Unified Messaging roles are present.

So, is it possible to open Exchange 2010 EMC and EMS using the local Administrator account when Exchange farm is composed by more then one server?

What is the Exchange 2003 default inheritance security setting at Server level? inheritance enabled or not? If I set delegation at Administrative Group level I can see permission stops at server level because of inheritance current setting is 'do not inherit'. Is this default?

Is there any critical drawback in using an internal CA to release an Exchange 2007/2010 SAN certificate for a production environment?

I am going setup a DAG in a brand new single-site two-server Exchange 2010 SP1 configuration, with both servers running CAS/HUB and MAILBOX roles and hardware-balanced CAS (no Edge roles nor Unified Messaging at all). I have read about this configuration on the Internet and everybody agree that it is a supported scenario, allowing HA using only two servers, but I see now that DAG need also a Witness folder and it hasn't to be located on a server partecipating into DAG. So, how it could be possible to use only two servers if both are giung to be added into the DAG?

I am going to install Exchange 2010 SP1 in a single-site two-server configuration, with both servers running CAS/HUB and MAILBOX roles. I'll use DAG to achieve HA and a hardware balancer to balance the CAS roles. No Edge roles will be installed.

1. When running Exchange setup, at "Configure Client Access External Domain" screen, am I right inserting the same domain (es. mail.mydomain.com) on both servers?
2. Do I need to create a CAS array?

I have a SQL Server 2008 (ver 10.0.1600) running on a Windows Server 2008 R2 Enterprise server with 8 GB of physical ram. If I open Task Manager I can see on 'Physical Memory' section of 'Performance' tab that only 340 MB are Available of 8191 Total, but I can't see any process using such amount of memory. Please note SQL Server is memory limited to 6GB (Maximum Server Memory = 6000).

If I open Sysinternals Process Explorer, I can see sqlsrvr.exe process has:

Private Bytes:  227.000 K
Working Set:    140.000 K
Virtual Size: 8.762.000 K

What does this means? Is there any way to free up this memory for other process? Why Virtual Size figure as allocated memory? I thought that Virtual Size was 'reserved memory' only.

I was used to configure HP iLO from Windows OS using hponcnfg, but how it can be done when operating system is ESXi 4.1 without phisically connect to the iLO port (aka remotely)?

Thank you all for help

while importing a csv data file with a very basic BULK INSERT statement on a SQL 2005 database server, I received some format errors and then a duplicate key error:

Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8625, column 6 (min_prc).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8627, column 6 (min_prc).
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint [TABLE]. Cannot insert duplicate key in object [TABLE].
The statement has been terminated.

Has the entire operation failed without actually have inserted any record? Have the records before the duplicate key error been inserted?

Can anyone point me to a website/document that describes bulk insert actions in case of errors?

Thank you all for help!

every day Domain Controller backup reports some warnings about these files:

C:\WINDOWS\ntfrs\jet\ntfrs.jdb
C:\WINDOWS\ntfrs\jet\temp\tmp.edb
C:\WINDOWS\security\Database\secedit.sdb
C:\WINDOWS\security\edb.log
C:\WINDOWS\security\edbtmp.log
C:\WINDOWS\security\tmp.edb

They are always locked by some process and Data Protector could not backup them. As I backup the System State too, is it safe to set an excepion on these files for file system backup? Can I exclude the whole ntfrs and security folders?

Thank you all for help!

How do I change management default gateway on HP Enclosure C-Class Virtual Connect modules?

Thank you all for help

I was asked to drop some tables on a Company SQL 2005 Server and provide proof of deletion because of these tables contains sensitive data. Is it possible?

Thank you all for help

is there a query to list database user access and related source IPs on SQL Server 2000 and 2005? Please note that reporting service is not installed.

Thank you all for help.

Our Tomcat 6 is running on a Windows Server 2003 server producing some logs on Program Files\Apache Software Foundation\Tomcat 6.0\logs folder.

Only catalina.YYYY-MM-DD.log rotates every night.

Files Admin, Host-Manager, Jakarta, LocalHost, Manager, stderr and stdout do not rotate and are dated at the last server restart date. These files are most empty and always locked.

How can I set Tomcat to rotate all these logs every night (if possible without server/service restart)?

Thank you in advance for help.