Re: Moving databases to a cluster

From: Bill (anonymous_at_discussions.microsoft.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 08:35:33 -0700

Thanks - I know that.
But I have been told that there are a number of security
issues that you have to deal with after you have moved the
databases over. Are you aware of these.

>-----Original Message-----
>Moving data to SQL Cluster or a Stand Alone SQL server,
is the same process.
>Data Transformation Services will also work. A SQL
Cluster is still a SQL
>box.
>
>Cheers,
>
>Rod
>
>MVP - Windows Server - Clustering
>http://www.nw-america.com - Clustering
>
>"Bill" <anonymous@discussions.microsoft.com> wrote in
message
>news:739e01c47646$339f6950$a401280a@phx.gbl...
>> What is the best method for moving databases from one
>> server onto a clustered setup? Obviously you can use
>> backup/restore or detach/reattach. What I really need to
>> know is what steps you have to do after this. There must
>> be security problems with the new database. ie how do
you
>> ensure security etc is carried over to cluster servers
>> from original server esp with login info living in
master
>> database of original server.
>
>
>.
>

Relevant Pages

  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.admin)
  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... It ain't that simple for SQL Server. ... that databases get locked off in the current cluster and then properly ...
    (microsoft.public.sqlserver.clustering)