sobota, 29 czerwca 2024
query WINS service from command line
by nblookup.exe - tool from Microsft - this is the only way now - no modules for Powershell or just I'm not aware of it
czwartek, 27 czerwca 2024
ADSync database shrink
We have problem with a huge ADSync database and we are in process of shrinking - we can't do upgrade to new Entra tool, so shrinking loooks like below:
c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Binn\SQLCMD.exe -S "(localdb)\.\ADSync2019"
(sqlcmd prompt) DBCC shrinkdatabase(ADSync,1);
(sqlcmd prompt) GO
c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Binn\SQLCMD.exe -S "(localdb)\.\ADSync2019"
(sqlcmd prompt) DBCC shrinkdatabase(ADSync,1);
(sqlcmd prompt) GO
ADSync database statistics
c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Binn\SQLCMD.exe -S "(localdb)\.\ADSync2019"
(sqlcmd prompt) USE ADSync;
(sqlcmd prompt) EXEC sp_spaceused @updateusage = N'TRUE';
(sqlcmd prompt) GO
(sqlcmd prompt) USE ADSync;
(sqlcmd prompt) EXEC sp_spaceused @updateusage = N'TRUE';
(sqlcmd prompt) GO
wtorek, 25 czerwca 2024
how to find all placeholders in MV of Azure AD Connect?
Import-Module "C:\Program Files\Microsoft Azure Active Directory Connect\Tools\AdSyncTools.psm1"
Export-ADSyncToolsAadDisconnectors
Export-ADSyncToolsAadDisconnectors
piątek, 21 czerwca 2024
0x80040e14 during Azure ADConnect upgrade
During upgrade Azure ADConnect to Entra AD Connect 2.3.8.0 we've received 0x80040e14 error. At first we had an idea that it's connected with permission or communication limitation on firewall, after quick search possible reasons:
missing column
or not enough memory for sql
For us it's near not enough memory reason, but we have still SQL Express, so during upgrade there is no place for finishing upgrade (limit 10GB for database size). We must find if we have any not needed objects to remove them from Azure or to move to full SQL server.
For us it's near not enough memory reason, but we have still SQL Express, so during upgrade there is no place for finishing upgrade (limit 10GB for database size). We must find if we have any not needed objects to remove them from Azure or to move to full SQL server.
Subskrybuj:
Posty (Atom)