Skip to content

Category: Microsoft

Reset WSUS Settings Using PowerShell

Reset WSUS Settings Using PowerShell, To remove the WSUS settings using PowerShell, run the following code. Make sure you run it using an elevated PowerShell command line: Stop-Service -Name wuauserv Remove-Item HKLM:\Software\Policies\Microsoft\Windows\WindowsUpdate -Recurse Start-Service -name wuauserv

Cara Restore SQL Server 2005 Suspect Database

Kadang kala kita menjumpai masalah di sql server 2005 salah satu database kita ada suspect mode, akan tetapi database yang lain harus tetep jalan saya coba langkah dibawah ini ternyata berhasil, anda mempunyai masalah yang sama? selamat mencoba

EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER