King Computer Solutions
spacer

Posts Tagged SQL

06.10.2009

Scheduled backup using Microsoft SQL Server 2005

The Express version of MS SQL 2005 does not include functionality to perform a scheduled backup. To get around this, use the “Script to File” option and then run it from the command line using a batch file and Windows Scheduled Tasks function. 1. Open up SQL Server Management Studio Express 2. Drill down to […]

02.19.2009

Upgrading MSDE prior to installing Sophos PureMessage

When installing Sophos PureMessage anti-spam / mail filtering software, if your Microsoft SQL Desktop Engine (MSDE) engine is not at SP4, the installer will report that it is Unable to connect to \local\SOPHOS. However if you try to install SP4 for MSDE, it won’t necessarily upgrade the correct version of MSDE. To check which version […]