Find SQL-database backup dates

Type this query to find them:   SELECT T1.Name as DatabaseName, COALESCE(Convert(varchar(12), MAX(T2.backup_finish_date), 101),’Not Yet Taken’) as LastBackUpTaken, COALESCE(Convert(varchar(12), MAX(T2.user_name), 101),’NA’) as UserName FROM sys.sysdatabases T1 LEFT OUTER JOIN msdb.dbo.backupset T2 ON T2.database_name = T1.name GROUP BY T1.Name ORDER BY…

Continue Reading Find SQL-database backup dates

Remote powershell to Lync 2010 / 2013 FE

Connet session: $cred = Get-Credential domainusername $session = New-PSSession -ConnectionURI “https://LYNCFE.FQDN/OcsPowershell” -Credential $cred Import-PsSession $session Disconnect session: Get-PSSession | Remove-PSSession

Continue Reading Remote powershell to Lync 2010 / 2013 FE

What to do when VCenter start fails after demoting Domain Controller

MS SQL is the backend database, yes. If you have access to the DB server, the easiest way to view/modify the table is via MS SQL Server Management Studio. – Open MS SQL Server Management Studio and point it to…

Continue Reading What to do when VCenter start fails after demoting Domain Controller

Verify Exchange update rollup version

Open powershell and type: Get-Command Exsetup.exe | ForEach-Object {$_.FileVersionInfo}

Continue Reading Verify Exchange update rollup version