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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Wed, 27 Oct 2004 14:13:01 -0700

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: Error: 0xC00D0FB3
    ... Rod ... > Media Player will not play / copy my music CDs in ... > then I get the same error message (think it's ... > Best Regards, ...
    (microsoft.public.windowsmedia.player)
  • Re: Restoring Old Files
    ... You're welcome Rod. ... Bert Kinney MS-MVP Shell/User ... >> Regards, ... >>> because the old files where I was a password protected user. ...
    (microsoft.public.windowsxp.help_and_support)
  • Table does not split over muløtiple pages..
    ... bottom margin. ... Why doesn't this table split and how can I fix this problem? ... Rod ...
    (microsoft.public.word.tables)
  • RE: Windows/Exchange security auditing tool
    ... Regards, YY ... Subject: Windows/Exchange security auditing tool ... Rod ...
    (Focus-Microsoft)