|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
05/07/2007, 19h22
|
#1 |
Messages: n/a
Hébergeur: |
Installation Of SQL - Installing on SAN
To All...
Can you install SQL on a SAN drive...ie...Engine & System Dbs...???... I think I know but just wanted to get some input... To the best of my knowledge, SQL does not care about what kind of drive it is, only the location is important...So, you can install the engine as system dbs on a SAN... Obviously, if SAN connectivity is lost, SQL won't run, so there are some pros and cons about installing to a local drive or to a SAN drive... Thanks in advance... JTJ |
|
|
05/07/2007, 23h48
|
#2 |
|
Messages: n/a
Hébergeur: |
RE: Installation Of SQL - Installing on SAN
I belive you are right, because when installing SQL Server will still put big
chunk of the files on System drive. But in our network configuration, we have Engin/Server files on System Drive. And three additional drives all SAN attached, one stores, Data Files, One Logs, One any secondary data files. And haven't had any issues with that configuration. -- Mohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 "JimiTheJet" wrote: > To All... > > Can you install SQL on a SAN drive...ie...Engine & System Dbs...???... > > I think I know but just wanted to get some input... > > To the best of my knowledge, SQL does not care about what kind of drive it > is, only the location is important...So, you can install the engine as system > dbs on a SAN... > > Obviously, if SAN connectivity is lost, SQL won't run, so there are some > pros and cons about installing to a local drive or to a SAN drive... > > Thanks in advance... > > JTJ |
|
|
|
07/07/2007, 17h22
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Installation Of SQL - Installing on SAN
In our case, the binaries are on local disks, the database files are on SAN
"Mohit K. Gupta" <mohitkgupta@msn.com> wrote in message news:8615F24B-B4DA-43B1-8E67-C54F445DDDBC@microsoft.com... >I belive you are right, because when installing SQL Server will still put >big > chunk of the files on System drive. But in our network configuration, we > have Engin/Server files on System Drive. And three additional drives all > SAN > attached, one stores, Data Files, One Logs, One any secondary data files. > And haven't had any issues with that configuration. > > -- > Mohit K. Gupta > B.Sc. CS, Minor Japanese > MCTS: SQL Server 2005 > > > "JimiTheJet" wrote: > >> To All... >> >> Can you install SQL on a SAN drive...ie...Engine & System Dbs...???... >> >> I think I know but just wanted to get some input... >> >> To the best of my knowledge, SQL does not care about what kind of drive >> it >> is, only the location is important...So, you can install the engine as >> system >> dbs on a SAN... >> >> Obviously, if SAN connectivity is lost, SQL won't run, so there are some >> pros and cons about installing to a local drive or to a SAN drive... >> >> Thanks in advance... >> >> JTJ |
|
|
|
| Outils de la discussion | |
|
|
