SQL 2000 Service Pack 1

[jde_cnc]

List-

Due to a SQL 2000 bug, we are being forced to apply SP 1 for the database. Essentially, we are unable to perform a full backup on the database using Veritas BackupExec due to the fact that all Recovery Models are defaulting to "Simple" and cannot be changed.

Anyhow, JDE has not yet certified SP 1 for SQL 2000. Has anyone applied this fix, and if so, can you share any thoughts about it?

Best regards.

OneWorld Xe SP 15.1, Update 2
Win2K Advanced Server/SQL 2000 Enterprise Edition

 

[barleyj]

I am using BackupExec and SQL2000 on Win2000 with no problem.

However I did come across something that sounds a bit like your problem. When I initially tried to changed the recovery mode of a database from Simple to Full, the OK button stayed grey and would not change it.

I resolved this by changing the log file to allow unlimited expansion, then all was OK.

Anyway, I have not applied SQL2000 SP1!

Jonathan Barley
Xe SP15 Update 2 Win2000 SQL2000 WTS2000/Citrix1.8

 

[jde_cnc]

FYI

The SQL 2000 SP1 install went without issue. The recovery mode can now be
altered while still keeping the DB size restricted.


----- Original Message -----
From: "barleyj" <[email protected]>
To: <[email protected]>
Sent: Tuesday, July 17, 2001 8:09 AM
Subject: Re: SQL 2000 Service Pack 1


When I initially tried to changed the recovery mode of a database from
Simple to Full, the OK button stayed grey and would not change it.
then all was OK.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
6451



OneWorld Xe SP 15.1, Update 2
Win2K Advanced Server/SQL 2000 Enterprise Edition

 

[LostinOW]

We've been running SQL 2000 SP1 for two months with no issues.

Frank

OneWorld Xe + XU1 SP 14.2, AS/400 V4R4M0
Windows 2000 SP1, SQL2000 SP1,
Citrix Metaframe 1.8A SP1