|
|
You're in the
sql server clustering
group:Ent Mgr. does not show databases after OS upgrade
sql server clustering:
My configuration is Windows 2000 Adv. server SP4 and two istances of SQL 2000 sP3. I just updated the OS from sp3 to SP4 last night and now when i open Ent. Mgr from any desktop or console pc and when opening the Database folder on node2 comes up with no items " i don't see any databases", and in Management i don't see the jobs or what's runnig or what's not. Didn't know wherwe to post this on sql group or the cluster group,can some one shed some light on this issue is it a known issue when upgrading the os to sp4 or is there any thing i need to reconfigure to make it work. since it has been less than 24 hours on the upgrade i cam across seeing once or twice and not most of the other time ??? Thanks and regards
Upgrades are never your friend. Nuke and pave my friend. Then restore the
DB's from backup! Cheers, Rodney R. Fournier MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog http://www.clusterhelp.com - Cluster Training ClusterHelp.com is a Microsoft Certified Gold Partner [quoted text, click to view] "jetski" <layth.shasha@fbnz.co.nz.nojunk> wrote in message news:FC89789F-6901-4943-9300-742BA18BF990@microsoft.com... > Hi > My configuration is Windows 2000 Adv. server SP4 and two istances of SQL > 2000 sP3. > I just updated the OS from sp3 to SP4 last night and now when i open Ent. > Mgr from any desktop or console pc and when opening the Database folder on > node2 comes up with no items " i don't see any databases", and in > Management > i don't see the jobs or what's runnig or what's not. > Didn't know wherwe to post this on sql group or the cluster group,can some > one shed some light on this issue is it a known issue when upgrading the > os > to sp4 or is there any thing i need to reconfigure to make it work. > since it has been less than 24 hours on the upgrade i cam across seeing > once > or twice and not most of the other time ??? > Thanks and regards > Layth
do they show up through isqlw/Query Analyzer?
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "jetski" <layth.shasha@fbnz.co.nz.nojunk> wrote in message news:FC89789F-6901-4943-9300-742BA18BF990@microsoft.com... > Hi > My configuration is Windows 2000 Adv. server SP4 and two istances of SQL > 2000 sP3. > I just updated the OS from sp3 to SP4 last night and now when i open Ent. > Mgr from any desktop or console pc and when opening the Database folder on > node2 comes up with no items " i don't see any databases", and in > Management > i don't see the jobs or what's runnig or what's not. > Didn't know wherwe to post this on sql group or the cluster group,can some > one shed some light on this issue is it a known issue when upgrading the > os > to sp4 or is there any thing i need to reconfigure to make it work. > since it has been less than 24 hours on the upgrade i cam across seeing > once > or twice and not most of the other time ??? > Thanks and regards > Layth
Thanks Hilary and Rodney
We've fixed it http://www.mcse.ms/archive83-2005-5-1490199.html and http://groups.google.co.nz/group/microsoft.public.sqlserver.server/browse_thread/thread/34a17fbf83c6d800/09f7325c72d4553f?lnk=st&q=odbc+sqlstate%3A+22003+error+220%3A+arithmetic+overflow+error&rnum=2&hl=en#09f7325c72d4553f We had 4 offline databases ready to be deleted sometime in the future, brought them back online and all is sweet, Thanks also to sql services www.sqlservices.com regards Layth [quoted text, click to view] "Hilary Cotter" wrote:
> do they show up through isqlw/Query Analyzer? > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > "jetski" <layth.shasha@fbnz.co.nz.nojunk> wrote in message > news:FC89789F-6901-4943-9300-742BA18BF990@microsoft.com... > > Hi > > My configuration is Windows 2000 Adv. server SP4 and two istances of SQL > > 2000 sP3. > > I just updated the OS from sp3 to SP4 last night and now when i open Ent. > > Mgr from any desktop or console pc and when opening the Database folder on > > node2 comes up with no items " i don't see any databases", and in > > Management > > i don't see the jobs or what's runnig or what's not. > > Didn't know wherwe to post this on sql group or the cluster group,can some > > one shed some light on this issue is it a known issue when upgrading the > > os > > to sp4 or is there any thing i need to reconfigure to make it work. > > since it has been less than 24 hours on the upgrade i cam across seeing > > once > > or twice and not most of the other time ??? > > Thanks and regards > > Layth > >
[quoted text, click to view] "jetski" wrote:
> Thanks Hilary and Rodney > We've fixed it > http://www.mcse.ms/archive83-2005-5-1490199.html > and > http://groups.google.co.nz/group/microsoft.public.sqlserver.server/browse_thread/thread/34a17fbf83c6d800/09f7325c72d4553f?lnk=st&q=odbc+sqlstate%3A+22003+error+220%3A+arithmetic+overflow+error&rnum=2&hl=en#09f7325c72d4553f > > We had 4 offline databases ready to be deleted sometime in the future, > brought them back online and all is sweet, > Thanks also to sql services > www.sqlservices.com > > regards > Layth > > > "Hilary Cotter" wrote: > > > do they show up through isqlw/Query Analyzer? > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > Looking for a FAQ on Indexing Services/SQL FTS > > http://www.indexserverfaq.com > > > > "jetski" <layth.shasha@fbnz.co.nz.nojunk> wrote in message > > news:FC89789F-6901-4943-9300-742BA18BF990@microsoft.com... > > > Hi > > > My configuration is Windows 2000 Adv. server SP4 and two istances of SQL > > > 2000 sP3. > > > I just updated the OS from sp3 to SP4 last night and now when i open Ent. > > > Mgr from any desktop or console pc and when opening the Database folder on > > > node2 comes up with no items " i don't see any databases", and in > > > Management > > > i don't see the jobs or what's runnig or what's not. > > > Didn't know wherwe to post this on sql group or the cluster group,can some > > > one shed some light on this issue is it a known issue when upgrading the > > > os > > > to sp4 or is there any thing i need to reconfigure to make it work. > > > since it has been less than 24 hours on the upgrade i cam across seeing > > > once > > > or twice and not most of the other time ??? > > > Thanks and regards > > > Layth > > > >
Hi Layth,
Just in case anybody else has this problem. Here is some more info on it. The problem exists after the Windows SP4 install as it somehow corrupts the database version in sysdatabases. To fix this and determine if you have the same problem, execute the following statement in master with Query Analyzer: PROBLEM ========== select * from sysdatabases This should return something like (the value may differ): Microsoft SQL-DMO (ODBC SQLState: 22003) Error 220: Arithmetic overflow error for that data type smallint, value=32826. Arithmetic overflow error for data type smallint, value=32826. The statement has been terminated. CAUSE ========== An offline database had a version value of 32826 (or whatever you value is) in the "version" field, which is too large for a smallint datatype column in the sysdatabases table. RESOLUTION ============ It will fall over when it when it gets to the database with the incorrect "version" and will NOT show you the name of the database, so you will need to know the actual name of the database. Keep in mind you CAN see the list of databases in QA, but NOT the problem database, so it's NOT the next one in the list when you run the select query. Once you identify your culprit. Run the Alter database statement to set the database back online: "ALTER DATABASE databasename SET ONLINE". That should fix it. Cheers Richard [quoted text, click to view] "jetski" wrote:
> Thanks Hilary and Rodney > We've fixed it > http://www.mcse.ms/archive83-2005-5-1490199.html > and > http://groups.google.co.nz/group/microsoft.public.sqlserver.server/browse_thread/thread/34a17fbf83c6d800/09f7325c72d4553f?lnk=st&q=odbc+sqlstate%3A+22003+error+220%3A+arithmetic+overflow+error&rnum=2&hl=en#09f7325c72d4553f > > We had 4 offline databases ready to be deleted sometime in the future, > brought them back online and all is sweet, > Thanks also to sql services > www.sqlservices.com > > regards > Layth > > > "Hilary Cotter" wrote: > > > do they show up through isqlw/Query Analyzer? > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > Looking for a FAQ on Indexing Services/SQL FTS > > http://www.indexserverfaq.com > > > > "jetski" <layth.shasha@fbnz.co.nz.nojunk> wrote in message > > news:FC89789F-6901-4943-9300-742BA18BF990@microsoft.com... > > > Hi > > > My configuration is Windows 2000 Adv. server SP4 and two istances of SQL > > > 2000 sP3. > > > I just updated the OS from sp3 to SP4 last night and now when i open Ent. > > > Mgr from any desktop or console pc and when opening the Database folder on > > > node2 comes up with no items " i don't see any databases", and in > > > Management > > > i don't see the jobs or what's runnig or what's not. > > > Didn't know wherwe to post this on sql group or the cluster group,can some > > > one shed some light on this issue is it a known issue when upgrading the > > > os > > > to sp4 or is there any thing i need to reconfigure to make it work. > > > since it has been less than 24 hours on the upgrade i cam across seeing > > > once > > > or twice and not most of the other time ??? > > > Thanks and regards > > > Layth > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |