Recreate Veeam ONE’s Database

Stop al VeeamONE services get-service veeam* | stop-service Drop the VeeamONE database from SQL and rename the database and log files. 1. Open SQL Server Management studio. 2. Create a service account for Veeam ONE and assign the following permissions to it: Public role (default permissions) CREATE ANY DATABASE permissions db_owner role on the Veeam ONE database db_datareader permissions … Read more

WSUS Database Maintenance

Step 1 Connect to SQL management studio and connect to SUSDB\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\queryCopy below script and change the adminname parameter to your user name and parameter (@adminName=N’domain\user) Step 2 Step 3 Step 4 Step 5 Run the normal Server Wizard from the WSUS Management Console. Optional Automation If you’d like to automatically run the WSUS maintenance tasks, refer to … Read more

Reinstalling WSUS

Install-WindowsFeature -Name UpdateServices-Services,UpdateServices-DB -IncludeManagementTools You can get away with not uninstalling WSUS entirely. Stop the related services, delete the DB and run the post-install. .\wsusutil.exe postinstall SQL_INSTANCE_NAME=”DC1\SQL2008″ It’s also recommended to delete the MMC console data as that can sometimes prevent the postinstall from creating the database. This can be found here: Try removing the … Read more