RE: Installing SP4 on SQL 2000

I have only recently re-installed SQL on my machine, because I need it
instead of Access on a project I am doing. Fortunately, installing SP4 was
the first thing I have decided to do, so, as yet, there are no other
databases other than the default ones that ship with SQL Server. I haven't
even started building the first table.

Hopefully this will make things a little simpler. In anticipation I have
downloaded kb article 290991 "How to manually remove SQL Server 2000 default,
named or instance". As well as kb article 303747 "How to install SQL Server
2000 - Basic Local Installation".

I notice on page 1 of the removal kb that it lists a set of database files
that MUST be saved. I'm not sure why I would worry if I haven't used the
database for anything as yet. It also says I could use the setup program to
uninstall, perhaps I should try that, with the installation disk, first?

Any words of advice before I do this?
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

I understand what you could be feeling. I think reinstalling would be the
best option. But before we reinstall following things to consider:

1) SQL Jobs running on the server (Backup jobs, and other tasks? GO to
Instance -> Mangement -> SQL Server Agent -> Jobs)
2) Number of user databases (System databases are master, model, msdb, and
tempdb; Example databases are pubs and Northwind)
3) The Security accounts. (How many accounts on the server? Go to Instance
-> Security -> Logins, how many logs exist there aside from SA,
BUILTIN\Administrator, will it be difficult for you to recreate these?)
4) Any DTS packages? (Go to Instance -> Data Transformation Services ->
Local Packages)

Since we will be wiping clean and starting over restoring the master
database might not be required depending on the answeres above.

Since this is your application, I am expecting this will be easy to get
restored and working.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

I have downloaded SP3a. I extracted all files to a folder I created called
SP3a. I double clicked Setup.bat, which consists of the code:
@echo off

start x86\setup\setupsql.exe

And, there was a brief flash of the DOS window, the mouse turned to an
hourglass for 3 or 4 seconds, and that was it. Nothing else, no dialogue
boxes, no nothing. I can honestly tell you this is becoming depressing.
I'm willing to continue because I need this database to be up and working on
my machine. Is the next suggestion to uninstall this installation and
reinstall it? Are there other suggestions?

--
Thanks
David G
Albury, Australia

.

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sharepoint Services SSEE data folder contents
    ... The limit is 4GB and it only applies to the version of SQL Server 2005 Express used by MOSS 2007 (and the independent installation of SQL Server 2005 Express). ... It doesn't apply to the version used by a WSS 3.0 Basic installation which has no database size limits (and which is btw officially called the "Windows Internal Database" although it too is indeed an embedded version of SQL Server 2005 Express - just one without that db limit. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
Loading