Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-03-22 : 16:30:40
|
| What are the pitfalls, tricks and precautions to look for when installing SQL 2000 on a SAN?All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-22 : 16:32:43
|
| None that I've encountered. I've installed SQL Server several times on a server that has drives on a SAN.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-03-22 : 16:56:57
|
| Do you install the SQL Binaries to the SAN drives or the local drives?I think for our install, the binaries were on the local server (c:\Program Files...) and all of the datafiles were on the SAN.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-22 : 17:00:24
|
| We put all application stuff on the E drive, which is local. We use C for OS only. I believe we put the page file on the E drive.For data files, we use F. For log files, we use G. For backup files, we use H. F, G, H are all on the SAN.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-03-22 : 18:32:17
|
| What's the point of putting the binaries on the SAN? If your server dies, you are still going to have to install the OS and reinstall the software, right? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-03-22 : 18:46:10
|
| I would suggest that you make sure that you have current firmware on HBAs, switches and the SAN itself. Also check that your HBA drivers are up to date.We ran into a corruption problem that was related to a driver/firmware combination we were using. Our particular problem might have been avoided had our software not been so far down-level.-ec |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-22 : 21:36:17
|
| What's the point of putting the binaries on the SAN? If your server dies, you are still going to have to install the OS and reinstall the software, right?If you are going to put the binaries on the SAN, put the OS also. It can actually be really nice to have the OS on the SAN. The performance is usually a lot faster. You can also replicate the entire environment, including OS drives to another LUN if you have a disk replication tool.Otherwise, leave the Binaries on the server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2004-03-26 : 11:47:19
|
| Good infor here, thank you guys. Kepp it coming if you have more.All help appreciated. |
|
|
|
|
|
|
|
|
Installing SQL2000 on a SAN