info@systemoperator.nl – rooiedokus.com

mei 12, 2019

SQL databases exporteren / importeren

Door info@systemoperator.nl in PowerShell, Scripting, SQL

Voor een klant mocht ik een server migratie uitvoeren (oude SBS omgeving naar Server 2019).
Op de oude SBS server stond een SQLExpress instance geïnstalleerd met meer dan 300 databases 🙁

Dit wilde ik natuurlijk niet met het handje overzetten om RSI te voorkomen 🙂

In het kort heb ik hier 2 handige scripts voor gebruiken, 1 script om van alle databases (exclusief systeemdatabases) een .bak te creëren en 1 script om al deze .bak bestanden te restoren.

Hieronder het SQL export script:

Copy to Clipboard

Voor het restoren van alle databases heb ik onderstaand PowerShell script gebruikt:

Copy to Clipboard

$backupRoot = Get-ChildItem -Path "D:\BAK_FILE_FOLDER"
$datafilesDest = "D:\DATA_FILE_FOLDER"
$logfilesDest = "D:\LOG_FILE_FOLDER"
$server = "server\inst"

## For each folder in the backup root directory...
#
foreach($folder in $backupRoot)
{   
    # Get the most recent .bak files for all databases...
    $backupFiles = Get-ChildItem -Path $folder.FullName -Filter "*.bak" -Recurse | Sort-Object -Property CreationTime -Descending | Select-Object -First 1

# For each .bak file...
    foreach ($backupFile in $backupFiles)
    {
        # Restore the header to get the database name...
        $query = "RESTORE HEADERONLY FROM DISK = N'"+$backupFile.FullName+"'"
        $headerInfo = Invoke-Sqlcmd -ServerInstance $server -Query $query
        $databaseName = $headerInfo.DatabaseName

# Restore the file list to get the logical filenames of the database files...
        $query = "RESTORE FILELISTONLY FROM DISK = N'"+$backupFile.FullName+"'"
        $files = Invoke-Sqlcmd -ServerInstance $server -Query $query

# Differentiate data files from log files...
        $dataFile = $files | Where-Object -Property Type -EQ "D"
        $logFile = $files | Where-Object -Property Type -EQ "L"

# Set some variables...
        $dataFileName = $dataFile.LogicalName
        $logFileName = $logFile.LogicalName

# Set the destination of the restored files...
        $dataFileFullPath = $datafilesDest+"\"+$dataFileName+".mdf"
        $logFileFullPath = $logfilesDest+"\"+$logFileName+".ldf"

# Create some "Relocate" file objects to pass to the Restore-SqlDatabase cmdlet...
        $RelocateData = New-Object 'Microsoft.SqlServer.Management.Smo.RelocateFile, Microsoft.SqlServer.SmoExtended, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' -ArgumentList $dataFileName, $dataFileFullPath
        $RelocateLog = New-Object 'Microsoft.SqlServer.Management.Smo.RelocateFile, Microsoft.SqlServer.SmoExtended, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' -ArgumentList $logFileName, $logFileFullPath

# Perform the database restore... and then go around the loop.
        Restore-SqlDatabase -ServerInstance $server -Database $databaseName -BackupFile $backupFile.FullName -RelocateFile @($RelocateData,$RelocateLog) -ReplaceDatabase
    }
}

nov 2, 2018

Exchange MessageTracking

Door info@systemoperator.nl in Exchange Tag Exchange 2016

Example 1:

Get-MessageTrackingLog -Server Mailbox01 -Start "03/13/2015 09:00:00" -End "03/15/2015 17:00:00" -Sender "john@contoso.com"

okt 3, 2018

Exchange attachment size limit

Door info@systemoperator.nl in Exchange

Er zijn in principe drie plaatsen waar u de standaardlimieten voor de berichtgrootte op Exchange kunt worden configureert:

```
Organization transport settings
```
```
Send/receive connector settings
```
```
User mailbox settings.
```

get-transportconfig | ft maxsendsize, maxreceivesize 
get-receiveconnector | ft name, maxmessagesize 
get-sendconnector | ft name, maxmessagesize 
get-mailbox Administrator |ft Name, Maxsendsize, maxreceivesize


om eventueel het limiet aan te passen gebruik je onderstaand commando:

Set-TransportConfig -MaxSendSize 15MB -MaxReceiveSize 15MB

sep 25, 2018

Convert Mailbox to a Shared Mailbox

Door info@systemoperator.nl in Exchange, PowerShell Tag Exchange, PowerShell

Set-Mailbox "info@domain.com" -Type shared

sep 25, 2018

Convert shared mailbox to user mailbox

Door info@systemoperator.nl in Exchange, PowerShell Tag Exchange, PowerShell

Set-Mailbox “mailbox display name” -Type:Regular

sep 20, 2018

How to set Exchange Calendar Permissions from the Powershell

Door info@systemoperator.nl in Exchange Tag Agenda

<pre lang="PowerShell" line="1">
Add-MailboxFolderPermission -identity “Managingdirector:\Calendar” -user “personalassistant” -AccessRights Reviewer
</pre>

sep 19, 2018

Keep a copy of sent emails for delegates of user mailboxes

Door info@systemoperator.nl in Exchange Tag Exchange

/**
* Comment
*/
Set-Mailbox mailbox@domain.tld -MessageCopyForSentAsEnabled $true

or

Set-Mailbox mailbox@domain.tld -MessageCopyForSendOnBehalfEnabled $true
exit();

sep 19, 2018

Autodesk DWG TrueView 2018 on Remote Desktop Services

Door info@systemoperator.nl in Terminal Server Tag DWG, Installer, RDS

Problem: Running DWG TrueView 2018 on Windows Server Remote Desktop Services / Terminal Services (RDS/TS) without having to change permissions or give users administrative privileges.

The registry entries (all String values) can be copied from the user profile that was used when installing DWG TrueView 2018. The information below is for the English version of Autodesk DWG TrueView 2018; other language versions may vary the “1001:409” section of the key below.

HKEY_CURRENT_USER\Software\Autodesk\DWG TrueView
- CurVer
HKEY_CURRENT_USER\Software\Autodesk\DWG TrueView\R16
- CurVer
HKEY_CURRENT_USER\Software\Autodesk\DWG TrueView\R16\dwgviewr-1001:409
- AllUsersFolder
- AutodeskShared32Folder
- AutodeskSharedFolder
- DownloadedProgramFilesFolder
- GraphicsCacheFolder
- LocalRootFolder
- PublicFolder
- RoamableRootFolder
- SystemFolder

Important: Three of these need tweaking per user (GraphicsCacheFolder, LocalRootFolder, RoamableRootFolder) to point at the appropriate user profile folder.

There is also a set of files installed to C:\Users\Public\Documents\Autodesk (or wherever your Public user folder resides) that need to be left in place.

When each user opens a .dwg file for the first time (or runs DWG TrueView directly) then the Autodesk installer will run and populate all other missing entries automatically (without trying to elevate).

Alle berichten door op info@systemoperator.nl