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

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Chen (Chen_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 09:25:04 -0700

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

  • Why is sp_helpdb and sysdatabases different
    ... This is the case for all databases except ... exec sp_helpdb master. ... sp_help is showing on F:\ F: is the correct location. ...
    (comp.databases.ms-sqlserver)
  • Re: qiestion about master
    ... Login into SQL Express using SQLCMD or SQL Server Express management studio ... databasesystem are linked or not to the master, ... Are those local system databases needed for running the central ...
    (microsoft.public.sqlserver.setup)
  • Re: question about logs
    ... I would disable auto-close. ... I support the Professional Association for SQL Server ... > There are 6 databases on this server besides msdb, master, etc. ... > "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)