Post by Germann » Sat, 08 May 2004 02:43:34

We have a server that runs our tape backup using the Tape
Exec drive and Veritas. The Veritas software install
only minimal pieces of the SQL files bt not enough to
allow us to install SQL server 2000 Security SP3 patch.

Does anyone know how to get around this without having to
do an install of SQL Server?


Post by Jasper Smi » Sat, 08 May 2004 03:03:27

It's probably MSDE. This requires a different service pack install than
other editions and it can be found here

If its MSDE you need the file sql2kdesksp3.exe

You can confirm what edition it is by opening a cmd prompt and running

osql -E -Q"select cast(serverproperty('Edition') as varchar(30))"

The above assumes a default instance (it will show up in services as
If it is a named instance (it will show up in services as MSSQL$XXXX) then

osql -S.\XXXX -E -Q"select cast(serverproperty('Edition') as varchar(30))"

where XXXXX is the part of the service name after the $ sign

If MSDE it will return 'Desktop Engine'


Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -



Post by Geoff N. H » Sat, 08 May 2004 04:42:55

Veritas backup exec does install MSDE. It can also hook into an existing
SQL server installation.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator

I support the Professional Association for SQL Server