[dba-SQLServer]Cross Posted - Upsizing fails

Billy Pang tuxedo_man at hotmail.com
Tue Feb 25 14:06:39 CST 2003


On the machine that is trying to access the newly installed ss2k, check the 
Client Network Utility.  There might be an old alias in there.

Billy



>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]Cross Posted - Upsizing fails
>Date: Tue, 25 Feb 2003 00:52:25 -0500
>
>Ooooh isn't that embarrassing!  Sorry.
>
>Yes, this SQL Server is on another box.  The SQL Server physically resides
>on my old dual PII 233 machine, which is the one I reformatted and
>re-installed on.
>
>I work on my dev machine which is my "new" AMD Athlon 1.33ghz, running 
>Win2K
>Pro.  It has the EM installed on it as well, and had been talking to the 
>SQL
>Server on my "old server" (which was wiped out).  Thus I am sure there is
>something somewhere that tells everything that said server existed.  I get
>the feeling that the tables that failed to import did so due to an "order"
>problem.  At the time it tired, something else it needed (a parent table)
>wasn't moved yet.  That kind of thing.  With only 4 missing it will be easy
>enough to drag them in I think.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>-----Original Message-----
>From: dba-sqlserver-admin at databaseadvisors.com
>[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Francisco
>Tapia
>Sent: Tuesday, February 25, 2003 12:42 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer]Cross Posted - Upsizing fails
>
>
>you forgot the "co", Francis +  co = Francisco :D
>
>Glad it worked out for you... I don't really see how you could have even
>seen the old server from .net if you wiped out the system, I mean that 
>would
>have ment the whole registry would have gone with it too.. unless this is 
>on
>another box?
>
>-Francisco
>http://rcm.netfirms.com/
>----- Original Message -----
>From: "John W. Colby" <jcolby at colbyconsulting.com>
>To: <dba-sqlserver at databaseadvisors.com>
>Sent: Monday, February 24, 2003 9:23 PM
>Subject: RE: [dba-SQLServer]Cross Posted - Upsizing fails
>
>
>: OK, things are getting better.  I found an article on the web that
>mentioned
>: that I had to create the database out in SQL Server first, which I did.  
>I
>: then created a DSN (I think it is called) that pointed to this table, and
>: ran my export.  This time only a handful of tables failed to export.  At
>: least I have a place to begin looking at why, rather than a complete and
>: total failure.  It would be nice to know why the "create new db" won't
>work
>: though.
>:
>: John W. Colby
>: Colby Consulting
>: www.ColbyConsulting.com
>:
>:  -----Original Message-----
>: From: dba-sqlserver-admin at databaseadvisors.com
>: [mailto:dba-sqlserver-admin at databaseadvisors.com]
>: Sent: Monday, February 24, 2003 11:53 PM
>: To: dba-sqlserver at databaseadvisors.com
>: Subject: RE: [dba-SQLServer]Cross Posted - Upsizing fails
>:
>: Francis,
>:
>: As for "Where" it is coming from, I have no idea, but my guess would be
>the
>: registry.  The new .net stuff just "found" the old sql server and gave it
>to
>: me as a choice in my combo of sql servers that I could attach to.  I had
>to
>: go specify the new in order to get at the new.  I also deleted the old
>(from
>: a right click menu in the wizard I was in in .net).
>:
>: As for what I did - I had Win2K Pro and SQL Server.  I wanted to install
>: Win2K Server which will not install "over" Pro.  Due to the fact that I
>also
>: had dual boot to Unix that was on a disk that I removed, and such
>ugliness,
>: I decided to just format and start from scratch.  So yes, I formatted the
>HD
>: and installed Win2K Server and SQL Server from scratch.
>:
>: SQL Server management console shows version 5.0 (build 2195: Service Pack
>3)
>: in the help about.
>: Windows shows 5.00.2195 Service Pack 3
>:
>: Because I put my data out in one of my data disks (partitions) for the
>: previous install, the old SQL database (the databases themselves)
>continued
>: to exist after I reinstalled, however I had no idea how to get SQL Server
>to
>: talk to them, and I had nothing important in them anyway, so I think I
>just
>: blew them away.
>:
>: I just tried the upsize wizard again.  The new SQL Server was the default
>: server in the combo for selecting that.  I selected new database and
>called
>: in something unique (not already in SQL Server).  The wizard took off and
>: ran in about 2 seconds (or less) came back with a "table  was skipped or
>: export failed" for every table.  Going to EM there is no sign of a new db
>by
>: the name I specified.
>:
>: It looks like it just didn't do anything beyond generating a report that
>it
>: didn't do anything.
>:
>: John W. Colby
>: Colby Consulting
>: www.ColbyConsulting.com
>:
>: -----Original Message-----
>: From: dba-sqlserver-admin at databaseadvisors.com
>: [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Francisco
>: Tapia
>: Sent: Monday, February 24, 2003 11:14 PM
>: To: dba-sqlserver at databaseadvisors.com
>: Subject: Re: [dba-SQLServer]Cross Posted - Upsizing fails
>:
>:
>: : Is there any way to get rid of all traces of, all references to, a
>sequel
>: : server that no longer exists?  Then set up Access to know about the SQL
>: : Server that does exist.  Then run the upsize.
>:
>: You say there are traces of the old server name, where? through the UDL
>: interface? or through the wizard?  Did you re-format your entire system 
>in
>: order to install Win2K server? what SP do you have installed on Win2K you
>: should have up to SP2 at the very least... And for SQL Server 2000 you
>: should have it up to SP2 to start, SP3, can cause some wierd
>abnormalities..
>: Once you have your Sp's up to SP2 for both the OS and SQL let us know how
>: that is looking... I'd like to keep this thread on the list in order to
>keep
>: it in the archives if you don't mind... :D
>: -Francisco
>: http://rcm.netfirms.com/
>:
>:
>:
>: ----------------------------------------------------
>: Is email taking over your day?  Manage your time with eMailBoss.
>: Try it free!  http://www.eMailBoss.com
>:
>: ----------------------------------------------------
>: Is email taking over your day?  Manage your time with eMailBoss.
>: Try it free!  http://www.eMailBoss.com
>:
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
>----------------------------------------------------
>Is email taking over your day?  Manage your time with eMailBoss.
>Try it free!  http://www.eMailBoss.com
><< winmail.dat >>


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963




More information about the dba-SQLServer mailing list