[dba-SQLServer]Cross Posted - Upsizing fails

John W. Colby jcolby at colbyconsulting.com
Mon Feb 24 23:52:25 CST 2003


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4516 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030225/842c3029/attachment.bin>


More information about the dba-SQLServer mailing list