Re: Moving DB Server

From: Derek Martin (dmj2195_at_DONTSPAMMEokstateDOT.edu)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 08:57:49 -0500

Hi Harry, last night I did almost exactly that and -- miraculously!!! - it
worked....needless to say I was quite nervous. My exact procedure was this,
however, if anyone else ever needs to do this:

1. Do the SPS Backup
2. Shut off all the components in the server topology
    DON'T CLOSE THIS BROWSER WINDOW!
3. Detach the config database - just clear the connections if there are
still some left over
4. COPY (don't move in case it goes south) the config database from A to B
5. Attach the configuration DB to server B.
6. Back in the browser, connect to the new configuration database.
7. Delete the portal site in your configuration (just go with it, I know
it's scary) after connecting to configuration DB on B.
8. Reattach the components in server topology (wed, search, index, etc.) as
they were.
9. Perform a full restore to your new configuration databased database
server.
10. Bingo bango!

Good luck everyone, thanks Harry for getting me started down that path.

Derek

"Harry Ng" <harry@infocan.net> wrote in message
news:BF1E6CB1-AC66-4FBA-8281-DAF0DA83A1E0@microsoft.com...
> You problem is that:
> When you use the backup tool, it only can backup the site database (but
not config database). So... If you restore the site database, it will find
the virtual server for install. But, you re-created the config db, the
virtual server setting lost. Anyway...
>
> You can migrate the database:
> 1. Remove Virtual Server
> 2. Detach and attach config, site database from Server A to Server B
> 3. Change the Config db location
> 4. Connect to existing site db.
>
> Just easy!! Enjoy.
> --
> Harry Ng
> harry@infocan.net
> System Consultant
> Microsoft Certified Trainer
> INFOCAN Computer (HK) Limited
> Tel: (852) 2882-2456
> Fax: (852) 2882-2707
>
>
> "Derek Martin" wrote:
>
> > Please someone help me!!!!!
> >
> > I have done these steps and gotten close:
> >
> > 1. Perform full backup using the SharePoint Backup utility
> > 2. Disconnected from Server A.
> > 3. Created a configuration DB and connected to it on Server B.
> > 3. Performed restore to Server B -> here is where it errors, it says
that
> > the virtual servers are not in the configuration database....what step
am I
> > missing here???
> >
> > PLEASE PLEASE PLEASE HELP!
> >
> > Thanks,
> > Derek
> >
> >
> >
> > "Derek Martin" <dmj2195@DONTSPAMMEokstateDOT.edu> wrote in message
> > news:enPAIdLdEHA.1692@tk2msftngp13.phx.gbl...
> > > Hi there, I need to move my configuration DB and single portal
instance
> > from
> > > database server A (SQL Server 2000SP3a) to database server B (SQL
Server
> > > 2000SP3a). No other changes are needed.
> > >
> > > How do I go about doing that? I know simply detaching and moving from
the
> > > SQL console won't cut it as there is stuff in the configuration DB
that I
> > > will need to set before hand (or after the fact). HELP!!!!!
> > >
> > > Thanks,
> > > Derek
> > >
> > > --
> > > Derek Martin
> > > 593074
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: Ideal Web Development Environment?
    ... only developer in a 1 server department with no budget, few resources, ... sandboxed area of the dev box. ... php, database, third party tools, onto your own computer (which could ... Config Files: There have to be many types of config files. ...
    (comp.lang.php)
  • Re: Offline Files and RDC (Multiple)
    ... Create a computer account on the customers SBS server. ... Well that worked fine on my system - which I'd setup exactly how the clients ... Also its not at all clear whether the message is talkin about the "Client" ... do I remove whatever has got setup to config "multiple remote desktop ...
    (microsoft.public.windows.server.sbs)
  • Re: RAID 1
    ... Stop focusing on the server - it is a straw man. ... As you can see from the config above and its ... As you can also see, immediately before reading post 9, which is your ... >> where you don't move the disk, ...
    (comp.os.linux.networking)
  • Exchange 2000 to Exchange 2003 swing migration - DCOM errors
    ... I have added an Exchange 2003 FE server which accepts POP and HTTP ... navigate to the following registry value ... Double-click Administrative Tools and then double-click Component Services. ... Config. ...
    (microsoft.public.exchange.setup)
  • SUMMARY: Solaris 8 Postfix SMTP Gateway and Postfix Mailserver
    ... postfix config problem. ... That you make entries in /etc/hosts for gateway and mailserver with both ... from OpenWebMail to a domain or local user on the same server it will not be ... No I know that this is not a special Solaris 8 question but I don't know if ...
    (SunManagers)