Procedures for scheduling a SQL 2005 backup using Microsoft SQL Server Management Studio.
SLQ
Shrink MSSQL Databases
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 the database you would like to backup Under All Tasks Select Backup Database Select...
Error When Upgrading WSUS 3 SP2
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...
Move Reporting Services Reports from one SQL Server to Another
Here are the steps I used to move SQL Reporting Services reports from one server to another:
Recent Comments