Re: Moving databases to a cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 10:59:42 -0500

Depending on how your move a database, you may or may not get the SQL logins
to come across. The Books online are excellent in regards to moving/copying
a database.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Bill" <anonymous@discussions.microsoft.com> wrote in message
news:746e01c4764a$da0da000$a301280a@phx.gbl...
> 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: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)