dbTalk Databases Forums  

non-cluster to cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss non-cluster to cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Wishart
 
Posts: n/a

Default non-cluster to cluster - 01-13-2004 , 11:07 AM






How do I move a database from a non-clustered sql server
to a clustered sql server and be able to use the database.

Reply With Quote
  #2  
Old   
Jinhe
 
Posts: n/a

Default RE: non-cluster to cluster - 01-13-2004 , 04:16 PM






detach/attach or backup/restore works too on cluster.
Just be sure that you put the db files etc in the shared disk, such as in data directory

Reply With Quote
  #3  
Old   
Uttam Parui[MS]
 
Posts: n/a

Default RE: non-cluster to cluster - 01-13-2004 , 05:50 PM



The procedure to move a db from a non-clustered SQL Server to a clustered
SQL Server is exactly the same you follow to move a db from a non-clustered
SQL Server to a non-clustered SQL Server. Only thing to remember in a
clustered SQL Server is that you need to put the database on the shared
disk that the clustered SQL Server is using (or dependent on).

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.


Reply With Quote
  #4  
Old   
ross
 
Posts: n/a

Default RE: non-cluster to cluster - 01-17-2004 , 08:01 AM



To this poing, the drives that you are using for the
databases must be dependencies on the cluster SQL Server.

Quote:
-----Original Message-----
The procedure to move a db from a non-clustered SQL
Server to a clustered
SQL Server is exactly the same you follow to move a db
from a non-clustered
SQL Server to a non-clustered SQL Server. Only thing to
remember in a
clustered SQL Server is that you need to put the
database on the shared
disk that the clustered SQL Server is using (or
dependent on).

HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and
confers no rights.

Are you secure? For information about the Strategic
Technology Protection
Program and to order your FREE Security Tool Kit, please
visit
http://www.microsoft.com/security.

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.