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

From: RIBR (RIBR_at_discussions.microsoft.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 04:35:06 -0700

Hi Chen and Rod,

I have same question. How move system databases and all other directories of
SQL virtual server (on shared disk) to different location (disk)?

Regards

Richard

"Chen" wrote:

> 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: Differences in clustered system dbs vs standalone system dbs
    ... I plan on giving the Virtual SQL Instance name the same name as my current ... That way the name of the SQL Server will not change. ... Again, copying the system databases, even if successful, won't fix ...
    (microsoft.public.sqlserver.clustering)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... Again, copying the system databases, even if successful, won't fix ... planning a major server migration. ... > virtual SQL Server instance is the same as before. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Re: Detaching system databases...
    ... Here is some information about moving system databases, ... Need SQL Server Examples check out my website at ... > I need to detach MASTER, ...
    (microsoft.public.sqlserver.server)
  • Re: sunmanagers Digest, Vol 11, Issue 6
    ... check this e-mail and any attachments for viruses. ... > not an easy way of doing it, since my print server is ... >> Regards, ... > I did a tail on the messages file to get a stop action of the flying ...
    (SunManagers)