Re: How to move system databases to new SAN drive in cluster serve

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: RIBR (RIBR_at_discussions.microsoft.com)
Date: 11/12/04 

Date: Thu, 11 Nov 2004 23:17:01 -0800

Hi Chen,

See following article which contains information about Registry and editing
the Registry. http://support.microsoft.com/kb/256986/EN-US/

I You need move directory which contains data of SQL Server Search You must
made following steps. By example You have two node cluster (NODE1 and NODE2)
and you move data from G:\MSSQL\FTDATA to directory R:\MSSQL\FTDATA.

1. Stop all services of virtual SQL Server by cluster administrator.
2. Run Regedit on NODE1
3. Export Registry Key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search to .REG
file and store it on save place.
4. Export Registry HKEY_LOCAL_MACHINE\Cluster to .REG file and store it on
save place.
5. Repeat steps 2., 3. and 4. on NODE2.
6. COPY! directory FTDATA to new location.
7. On NODE1 change value of Key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Applications\SQLServer\SearchDirectory to R:\MSSQLDATA\FTDATA\SQLServer\Projects
8. On NODE1 change value of Key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering
Manager\Applications\SQLServer\ApplicationPath to
R:\MSSQLDATA\FTDATA\SQLServer\
9. On NODE1 change value of Key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering
Manager\Applications\SQLServer\DefaultProjectPath to
R:\MSSQLDATA\FTDATA\SQLServer\Projects
10.On NODE1 change value of Key
HKEY_LOCAL_MACHINE\Cluster\Resources\97506eb7-4e15-48f5-ae1e-093639aebf8b\Parameters\ApplicationPath
to R:\MSSQLDATA\FTDATA (Warning: the GUID
97506eb7-4e15-48f5-ae1e-093639aebf8b can be different, search key with string
FTDATA).
11. Repeat steps 7. - 10. on NODE2.
12. Rename original directory FTDATA to FTDATA1.
13. Start all services of virtual SQL Server by cluster administrator.
14. Control functionality.

I tried this method on Windows 2000 Advanced server with SP4 and SQL Server
2000 Enterprise with SP3. On different version of Windows server method may
be different.

Regards

RIBR

"Chen" wrote:

> Hi RIBR,
>
> Thank you so much. I will wait for next week you send me list of keys need
> modify. Since this is my first time edit to the registry, can you send steps
> how to modify those keys and after modify do I need stop/start SQL Server
> services?
>
> Regards,
> -Chen
>
> "RIBR" wrote:
>
> > Hi Chen,
> >
> > I did edit Registry keys by Registry Editor.
> > I did not follow an article I have just searched registry keys for MS
> > Cluster service and MS Search Service.
> >
> > Unfortunately I did it at customers place and do not have exact
> > specification with me at the moment. I can send You list of keys modified by
> > me by next week.
> >
> > Regards
> >
> > RIBR
> >
> > "Chen" wrote:
> >
> > > Thanks for everyone reply this question.
> > >
> > > RIBR,
> > >
> > > Can you tell me some details that you did edit keys which bears on MS Search
> > > and MSCS? Is that edit inside the Registry Editor? Which article you follow?
> > >
> > > Regards,
> > > -Chen
> > >
> > > "RIBR" wrote:
> > >
> > > > I tried move FTData.
> > > > I stoped SQL virtual server and SQL Server Search.
> > > > Then I have to edit keys which bears on MS Search and MSCS and moved FTData.
> > > > Finaly i started SQL virtual server and SQL Server Search.
> > > >
> > > >
> > > > "Geoff N. Hiten" wrote:
> > > >
> > > > > I would stop/start using the command-line. Just make sure the resources SQL
> > > > > depends on are online on the node you are working from.
> > > > >
> > > > > FTData is full-text. You will likely need to deal with that as a separate
> > > > > issue. Config files should be a non-issue. Make sure and remove the old
> > > > > drives as dependancies from SQL AFTER you have removed all the data.
> > > > >
> > > > > Remember, do one step at a time. Have backups and a fall-back plan for each
> > > > > step. High availability is a state of mind more than anything else.
> > > > >
> > > > > --
> > > > > Geoff N. Hiten
> > > > > Microsoft SQL Server MVP
> > > > > Senior Database Administrator
> > > > > Careerbuilder.com
> > > > >
> > > > > I support the Professional Association for SQL Server
> > > > > www.sqlpass.org
> > > > >
> > > > > "Chen" <Chen@discussions.microsoft.com> wrote in message
> > > > > news:A81FFC2C-0E88-4AE1-8DDE-3635CE29429C@microsoft.com...
> > > > > > Hi Geoff,
> > > > > >
> > > > > > Thanks for the replay. During the move msdb and model, you need perform
> > > > > the
> > > > > > stop and restart the SQL Server and SQL Agent services. Is this can done
> > > > > in
> > > > > > Cluster Administrator console bring offline SQL instance and bring online,
> > > > > am
> > > > > > I right? Another thing is that after all databases moved, we will get rid
> > > > > of
> > > > > > old drive, how can I treat those cluster Configuration files under the
> > > > > > subdirectory FTDATA and config since they are generate from installation,
> > > > > if
> > > > > > I manually copy them to new SAN drive, the failover should work properly
> > > > > in
> > > > > > the future?
> > > > > >
> > > > > > Best Regards,
> > > > > > -Chen
> > > > > >
> > > > > > "Geoff N. Hiten" wrote:
> > > > > >
> > > > > > > It should work the same. I have moved model, msdb, and tempdb on a
> > > > > cluster
> > > > > > > but not master.
> > > > > > >
> > > > > > > Moving SQL Server databases to a new location with Detach/Attach
> > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
> > > > > > >
> > > > > > > If you get stuck you can start SQL via the command line from the node
> > > > > > > hosting the resource group. Use the correct switch options to point to
> > > > > > > master, etc. and then you can use Enterprise Mangler to fix the startup
> > > > > > > parameters.
> > > > > > >
> > > > > > > --
> > > > > > > Geoff N. Hiten
> > > > > > > Microsoft SQL Server MVP
> > > > > > > Senior Database Administrator
> > > > > > > Careerbuilder.com
> > > > > > >
> > > > > > > I support the Professional Association for SQL Server
> > > > > > > www.sqlpass.org
> > > > > > >
> > > > > > > "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
> > > > > > > message news:eLfiMyGvEHA.612@TK2MSFTNGP15.phx.gbl...
> > > > > > > > I can't find a thing, I am hoping Geoff can come to my rescue once
> > > > > again
> > > > > > > :)
> > > > > > > >
> > > > > > > > Cheers,
> > > > > > > >
> > > > > > > > Rod
> > > > > > > >
> > > > > > > > MVP - Windows Server - Clustering
> > > > > > > > http://www.nw-america.com - Clustering
> > > > > > > > http://msmvps.com/clustering - Blog
> > > > > > > >
> > > > > > > > "Chen" <Chen@discussions.microsoft.com> wrote in message
> > > > > > > > news:6D6B0C7A-DA2C-411A-BEB2-0D1D7288A0D6@microsoft.com...
> > > > > > > > > Hi Rod,
> > > > > > > > >
> > > > > > > > > Any result for this issue?
> > > > > > > > >
> > > > > > > > > Best Regards,
> > > > > > > > > -Chen
> > > > > > > > >
> > > > > > > > > "Rodney R. Fournier [MVP]" wrote:
> > > > > > > > >
> > > > > > > > >> True, I have not moved any of the system databases this way. Let me
> > > > > > > look
> > > > > > > > >> into it.
> > > > > > > > >>
> > > > > > > > >> Rod
> > > > > > > > >> "Chen" <Chen@discussions.microsoft.com> wrote in message
> > > > > > > > >> news:EF8BD43C-381D-4254-A570-D3A32859F196@microsoft.com...
> > > > > > > > >> > Hi Rod,
> > > > > > > > >> >
> > > > > > > > >> > Thanks for the replay. I used detach and attach method for user
> > > > > > > define
> > > > > > > > >> > database all the time in cluster server, but this time I am
> > > > > talking
> > > > > > > > >> > about
> > > > > > > > >> > moving system databases those are master, msdb and model. Compare
> > > > > > > with
> > > > > > > > >> > non-cluster server, can I use the similar way to move system
> > > > > > > databases
> > > > > > > > >> > in
> > > > > > > > >> > cluster server?
> > > > > > > > >> >
> > > > > > > > >> > Regards,
> > > > > > > > >> > -Chen
> > > > > > > > >> >
> > > > > > > > >> > "Rodney R. Fournier [MVP]" wrote:
> > > > > > > > >> >
> > > > > > > > >> >> I use the attach method all the time on SQL clusters, works
> > > > > great!
> > > > > > > You
> > > > > > > > >> >> will
> > > > > > > > >> >> need to take SQL down to add the H: drive to the dependency
> > > > > list, if
> > > > > > > > >> >> the
> > > > > > > > >> >> SAN
> > > > > > > > >> >> does not require the machine(s) to be completely off.
> > > > > > > > >> >>
> > > > > > > > >> >> Cheers,
> > > > > > > > >> >>
> > > > > > > > >> >> Rod
> > > > > > > > >> >>
> > > > > > > > >> >> MVP - Windows Server - Clustering
> > > > > > > > >> >> http://www.nw-america.com - Clustering
> > > > > > > > >> >> http://msmvps.com/clustering - Blog
> > > > > > > > >> >>
> > > > > > > > >> >> "Chen" <Chen @discussions.microsoft.com> wrote in message
> > > > > > > > >> >> news:4EDE74CF-8F64-48E7-A09C-3C219FB91BD4@microsoft.com...
> > > > > > > > >> >> > Hi,
> > > > > > > > >> >> >
> > > > > > > > >> >> > I have to move an entire SQL Server system databases from
> > > > > current
> > > > > > > > >> >> > basic
> > > > > > > > >> >> > drive W: to new SAN drive H: in cluster server (current is one
> > > > > > > node
> > > > > > > > >> >> > with
> > > > > > > > >> >> > two
> > > > > > > > >> >> > instances). During the installation, I put Program files to C:
> > > > > > > drive
> > > > > > > > >> >> > and
> > > > > > > > >> >> > Data
> > > > > > > > >> >> > Files to W: drive. After move all dbs, we will get rid of
> > > > > drive W.
> > > > > > > > >> >> > My
> > > > > > > > >> >> > questions are:
> > > > > > > > >> >> >
> > > > > > > > >> >> > 1) Do I need uninstall and reinstall those instances to move
> > > > > > > system
> > > > > > > > >> >> > dbs
> > > > > > > > >> >> > to
> > > > > > > > >> >> > new location?
> > > > > > > > >> >> >
> > > > > > > > >> >> > 2) Is it possible to following the article 224071 Moving SQL
> > > > > > > Server
> > > > > > > > >> >> > Databases to a New Location with Detach/Attach? If this is the
> > > > > > > case,
> > > > > > > > >> >> > after
> > > > > > > > >> >> > SQL Server system dbs moved, how about those cluster
> > > > > Configuration
> > > > > > > > >> >> > files
> > > > > > > > >> >> > under the subdirectory FTDATA and config, do I need copy them
> > > > > to
> > > > > > > new
> > > > > > > > >> >> > SAN
> > > > > > > > >> >> > drive manually since they automatically generated from
> > > > > > > installation?
> > > > > > > > >> >> > And
> > > > > > > > >> >> > what
> > > > > > > > >> >> > kind order should I follow, msdb, master, model and tempdb or
> > > > > must
> > > > > > > > >> >> > master
> > > > > > > > >> >> > first? During the move, it need perform many times to Stop and
> > > > > > > > >> >> > restart
> > > > > > > > >> >> > SQL
> > > > > > > > >> >> > Server, this should be use Cluster Administrator to offline
> > > > > SQL
> > > > > > > > >> >> > Server
> > > > > > > > >> >> > instance or should go to the control panel services manually
> > > > > stop
> > > > > > > > >> >> > and
> > > > > > > > >> >> > restart
> > > > > > > > >> >> > SQL Server services?
> > > > > > > > >> >> >
> > > > > > > > >> >> > Any input much appreciate,
> > > > > > > > >> >> > -Chen
> > > > > > > > >> >> >
> > > > > > > > >> >>
> > > > > > > > >> >>
> > > > > > > > >> >>
> > > > > > > > >>
> > > > > > > > >>
> > > > > > > > >>
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >

Relevant Pages

  • Re: fulltext search not working
    ... MSSearch service components or registry key &/or values at the server level ... with Microsoft SQL Server support. ... > the FTS component as the server is a production database and is hosted on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Performance Objects (sqlctr80.dll)
    ... reasons, such as Permission, Server Crash, Registry Modification and Virus. ... and "First Counter" values can vary between SQL Server ... Unload the SQL Server Counters ... In command line, execute "unlodctr MSSQLServer" (Without quotation, the ...
    (microsoft.public.sqlserver.setup)
  • Re: Failure to Login
    ... I had already checked the Registry ... At a command prompt, if I ... the MSDE was install with OS Authentication. ... >is the default setup for the SQL Server 2000 Data Engine.) ...
    (microsoft.public.sqlserver.msde)
  • Re: fulltext search not working
    ... this is a FTS component or registry ... as this problem is at the SQL Server level and not database specific. ... and stop both the MSSQLServer and the MSSearch services. ...
    (microsoft.public.sqlserver.fulltext)