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...
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...
Here are the steps I used to move SQL Reporting Services reports from one server to another:
Recent Comments