Procedures for scheduling a SQL 2005 backup using Microsoft SQL Server Management Studio.
There are several ways to shrink or truncate your MS SQL databases. One procedure is to run a backup from within the Enterprise Manager. Open Enterprise Manager Expand your SQL Server Group and your Local server Expand Databases Right Click…
While trying upgrade Windows Server Update Services, WSUS, I experience the following error in the setup log and the install would stop:
2010-01-08 10:37:52 Error MWUSSetup ExecuteQuery: Failed to execute SQL query USE SUSDB IF EXISTS (select * FROM master..sysdatabases WHERE name= N’SUSDB’ AND suser_sname(sid) is null) EXEC dbo.sp_changedbowner N’”DomainName”\administrator’ (Error 0x80040E14)
Here are the steps I used to move SQL Reporting Services reports from one server to another: