Changing domains and restoring db's

I have a 2000 server that also runs SQL 7.0.
This server is a PDC of domain "A". It also happens to be
the only server on the domain.
I am tasked to eliminate this domain and bring this server
into domain "B". I have been told that unfortunately, I
will have to FDISK this guy to scratch and reinstall OS,
SQL, everythng, to bring him into new domain.
Is this true?
Also, the SQL has some pretty big databases and of course
they are backed up nightly, but I was hoping not to have
to restore these db's from tape but instead, copy the
databases over to another server, then copy them back
after I have reinstalled the server and brought him into
domain "B".
Can I do this and what do I need to know how to go about
this?"Rick" <anonymous@.discussions.microsoft.com> wrote in message
news:00aa01c39991$10541780$a501280a@.phx.gbl...
> I have a 2000 server that also runs SQL 7.0.
> This server is a PDC of domain "A". It also happens to be
> the only server on the domain.
> I am tasked to eliminate this domain and bring this server
> into domain "B". I have been told that unfortunately, I
> will have to FDISK this guy to scratch and reinstall OS,
> SQL, everythng, to bring him into new domain.
> Is this true?
> Also, the SQL has some pretty big databases and of course
> they are backed up nightly, but I was hoping not to have
> to restore these db's from tape but instead, copy the
> databases over to another server, then copy them back
> after I have reinstalled the server and brought him into
> domain "B".
> Can I do this and what do I need to know how to go about
> this?
First make sure that the SQL services are not running under a domain
account. Go to the services applet and change the SQL services to use a
local system login (note: from this point SQL won't be able to use network
resources).
Then run dcpromo. Tell the wizard that this is the last domain controller
in the domain. This should turn it into a standalone server. Then you
should be able to join domain B and run the SQL services under a new domain
account.
To transfer databases from one SQL server to another use the DTS wizard from
Enterprise Manager. It has an option to transfer all objects from one SQL
database to another.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003|||So you're saying that I do not have to FDisk this server
and reinstall everything? I can just turn it into a
standalone server first and then bring it into a new
domain?
If that is the case, then I wouldn't have to do anything
to the SQL portion right? I'd just leave it as is?