Re: Moving DB Server

From: Harry Ng (harry_at_infocan.net)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 00:45:02 -0700

But, eveyone need to REMEMBER THAT: THESE METHODS ONLY MIGRATE THE DATABASES ONLY. NOT ALL THE SETTINGS, SUCH AS (registry settings: e-mail server setting, content sources settings: indexes). 

-- 
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:
> 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: SceCli Error 1202 filling up the Event Log!
    ... > after restarting the Win2003 server, the secedit.sdb database does not get ... >>> security database and have it recreated. ... >>> configuration\windows settings\security settings, you should inventory ...
    (microsoft.public.win2000.advanced_server)
  • Re: help with 2000i on win2k server (sp3 on database)
    ... See Leonard's post for the config options. ... If the server is mangling itself, then ANYTHING running on the server ... that I work with will support the database AND the application. ... As for Windows vs. Linux/NetWare, I can agree, but I also see MANY ...
    (comp.databases.btrieve)
  • Re: Win2k3 SP1 error: New transaction cannot enlist in the specifi
    ... Glad to hear it, Ronan, and it might come in handy to know that if the s**t ... > are NO installed COM+ components has to have the same COM+ MSDTC settings ... >> to a Windows Server 2003. ... >> Do you use SQL Username and password, or SSPI to logon to the database ...
    (microsoft.public.windows.server.general)
  • Re: Error During Team Foundation Server Setup
    ... I'm sure it is just a minor config issue... ... the only way I could fix it was by rebuilding the server! ... think the problem might be related to the config database. ... I am attempting to install Team Foundation Server. ...
    (microsoft.public.vsnet.enterprise.tools)