 | |
Application Databases storing location
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Application Databases storing location -
05-03-2004
, 01:57 AM
#2
| |||
| |||
|
|
We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C  local harddisk) of the primaryserver? If there is a solution pls advice. |
#3
| |||
| |||
|
|
We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C local harddisk) of the primaryserver? If there is a solution pls advice. |
#4
| |||
| |||
|
|
-----Original Message----- A clustered SQL server must store data on a drive that is in the same resource group. The SQL server must be dependant on the physical disk(s) that clustered data is stored on. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "Anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:743201c430db$f3018270$a401280a (AT) phx (DOT) gbl... We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C local harddisk) of the primaryserver? If there is a solution pls advice. . |
#5
| |||
| |||
|
|
-----Original Message----- You can copy data to anywhere you would like. To use the data with clustering, you have to have the ability for that data to be reached by any clustered node, even after a failure. If you keep anything local, and that machine fails, other nodes will not be able to access it. Cheers, Rod "Anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:743201c430db$f3018270$a401280a (AT) phx (DOT) gbl... We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C local harddisk) of the primaryserver? If there is a solution pls advice. . |
#6
| |||
| |||
|
|
Can the Clocal harddisk) of the primary server be included as part of the same resource group as the clustered SQL server? -----Original Message----- A clustered SQL server must store data on a drive that is in the same resource group. The SQL server must be dependant on the physical disk(s) that clustered data is stored on. -- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "Anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:743201c430db$f3018270$a401280a (AT) phx (DOT) gbl... We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C local harddisk) of the primaryserver? If there is a solution pls advice. . |
#7
| |||
| |||
|
|
Fine. We do not want the test data in the cluster mode and need not be available in case of failure. Is it possible to have SQL server in Cluster and applications data in the local? -----Original Message----- You can copy data to anywhere you would like. To use the data with clustering, you have to have the ability for that data to be reached by any clustered node, even after a failure. If you keep anything local, and that machine fails, other nodes will not be able to access it. Cheers, Rod "Anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:743201c430db$f3018270$a401280a (AT) phx (DOT) gbl... We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the applications stored in the Cluster Storage F:. Is it possible to store all the test databases of the applications in the C local harddisk) of the primaryserver? If there is a solution pls advice. . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.