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 |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-01-28 : 10:26:00
|
| Is there any reason not to store data on a SAN using SQL Server 2008? This is for an OLAP database. thank you. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-01-28 : 11:38:54
|
| Based on the details that you provided, no.CODO ERGO SUM |
 |
|
|
dportas
Yak Posting Veteran
53 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-30 : 10:15:21
|
| Very useful for disaster recovery - using san mirroring . There are also some other side benefits , such as Fastcopy - to move large files around quickly. Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-31 : 09:38:18
|
quote:
Originally posted by jackv
Very useful for disaster recovery - using san mirroring . There are also some other side benefits , such as Fastcopy - to move large files around quickly. Jack Vamvas--------------------http://www.ITjobfeed.com
Well jackv, Are you using SAN Mirroring? Does it support geographical sites or limited sites? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-02-01 : 03:46:00
|
| Using synchronous mirroring across different sites at the drive level. Two variations : 1) on some servers we're mirroring drives with similar sql server configuarion on either side - i.e c:\ is local everything else is SAN 2) All drives mirrored ,and the server boots off SAN. These solutions aren't HA , but are DR basedJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
Storing data on a SAN