Re: How to move system databases to new SAN drive in cluster serve
From: RIBR (RIBR_at_discussions.microsoft.com)
Date: 11/09/04
- Next message: Michael Cheng [MSFT]: "RE: Virtual SQL Server Transaction Log Auto-Grow problem."
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL Clustered Node restarting unexpectedly"
- In reply to: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Next in thread: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Reply: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Nov 2004 00:07:06 -0800
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
> > > > > > >> >> >
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >> >>
> > > > > > >>
> > > > > > >>
> > > > > > >>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
- Next message: Michael Cheng [MSFT]: "RE: Virtual SQL Server Transaction Log Auto-Grow problem."
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL Clustered Node restarting unexpectedly"
- In reply to: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Next in thread: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Reply: Chen: "Re: How to move system databases to new SAN drive in cluster serve"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
