Slammer

Slammer

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?
 
 
 

Slammer

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
http://www.yqcomputer.com/

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
MSSQLSERVER)
If it is a named instance (it will show up in services as MSSQL$XXXX) then
run

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'

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.yqcomputer.com/

 
 
 

Slammer

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
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org



http://www.yqcomputer.com/