Tag: Server 2008

How to connect to the WSUS Database

How to connect to the WSUS Database

To connect to the WSUS Database in SBS2011 (Server 2008) follow the below steps:

1) Open the Microsoft SQL Server Management Studio (As Administrator)
Microsoft SQL Management Studio
2) In the Database field Enter the below:
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
WSUS Connetion - MSSMS
3) Click Connect

Done

Want to read more of my articles on WSUS:

Resolve the CLR20r3 MoveData.exe Crash
Property Owner is not available for database SUSDB
Free up Disk Space in Small Business Server (SBS2008 / SBS2011)

Windows Server Backup – “The filename, directory name, or volume label syntax is incorrect”

Windows Server Backup – “The filename, directory name, or volume label syntax is incorrect”

Problem:

I had used AOMEI Server Edition to re-size the Partitions on a Windows 2008 R2 Server. Once the re-size was complete the server functioned as normal but the Window Server Backup stopped working.

I was getting Error Event 146 in the Backup Log with the message:

A volume VOLUME_NAME included for backup is missing. This could be because the volume is dismounted, reformatted or disk is detached.”

For more information about this error see the TechNet Article here:

In my case I could not remove the Volume from Windows Server Backup. Attempting to modify the backup Schedule via the GUI gave me the error:

The filename, directory name, or volume label syntax is incorrect

Solution:

To resolve the issue I disabled Windows Backup via the GUI. I then re-setup the backup as normal with a single External Backup Drive. This retained my current backups and did not format the drive.

I then added the other drives into the Backup Schedule via the “wbadmin enable backup -addtarget” command. For more information on this command see here:

The backups then worked as they should.

Configure a new NTP Server in Windows Server

Configure a new NTP Server in Windows Server

Configuring a new NTP Server in Windows Server

Open an Elevated Command Prompt:

Query the current Time Service using:
w32tm /query /status

Run the following Command to configure a new NTP Peer:
w32tm /config /manualpeerlist:uk.pool.ntp.org

Restart the Windows Time Service:

net stop w32time
net start w32time