Tag: Microsoft

Backup all SQL databases

The following script can be used to backup all databases from a SQL server. The system databases are excluded. If any other database should be excluded, add them to the “NOT IN” section. For different date formats in…

Read More »

Administer WID instance with SQL Server Management Studio

Windows Server Update Services (WSUS) can use a Windows Internal Database (WID). This database is manged through WSUS, but occasionally you want to administer this with SQL Server Management Studio. Install SQL Server Management Studion (Express) on the…

Read More »

MsSQL – Backup all SQL Server Databases

source: https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ Change @Path for the location of the backups. DECLARE @name VARCHAR(50) — database name  DECLARE @path VARCHAR(256) — path for backup files  DECLARE @fileName VARCHAR(256) — filename for backup  DECLARE @fileDate VARCHAR(20) — used for file…

Read More »

MsSQL Backup a Database

Use the following query to backup a MsSQL database. Fill in the correct database name (@name) and backup location (@path). This script uses the date for the filename, so if multiple backups are needed on the same day…

Read More »

Last Logon Date AD Users

source: https://gallery.technet.microsoft.com/scriptcenter/Get-Last-Logon-for-Users-c8e3eab2 The “lastLogon” Active Directory attribute is a property that is not replicated throughout the Domain Controllers.  This attribute is stored on the domain controller that received the authentication request and updated its property accordingly.  Because of…

Read More »

Get Office 365 users with a specific license type via Powershell

It can sometimes be useful to get a list of Office 365 users with a specific license type via PowerShell. Instead of logging into the Office 365 portal and using a filtered view in the admin center, you…

Read More »

How to enable the Disk Cleanup tool on Windows Server 2008 R2

source: https://support.appliedi.net/kb/a110/how-to-enable-the-disk-cleanup-tool-on-windows-server-2008-r2.aspx How to enable the Disk Cleanup tool: 1) Go to Programs & Features, and in the Features section, enable/install “Desktop Experience”.   The downside to this is that you will need to reboot your server after installing this…

Read More »

Synching Microsoft NPS (RADIUS) servers

source: http://www.routereflector.com/2016/07/syncing-microsoft-nps-servers/ Use the following powershell script to sync microsoft NPS (radius) servers.

 

Read More »

Failed To Open or Edit GPO

source: https://mohdzmaili.wordpress.com/2017/02/15/failed-to-open-or-edit-gpo/comment-page-1/#comment-30   Group Policy Object cannot be opened or edited with the error: Failed to open Group Policy Object. You might not have the appropriate rights. Details: The volume for a file has been externally altered so that…

Read More »

Resetting Administrator Password in Windows 2012

Instructions To reset the password on your Windows 2012 server, simply complete the following steps: Boot from the Micrsoft Windows Server 2012 DVD From the Windows Setup menu, click “Next”. Select “Repair your computer” Under Choose and option,…

Read More »