Hi
We have a client that wants to implement a SAN to be shared by other
servers.
How do you setup a SQL server to use the SAN array? The client only has one
SQL server (node).
I have implemented SQL onto Active/Active and Active/Passive clustering
before, but i am confuse to just how to install single SQL node to a SAN
array (i.e no failover)
Can anyone give me some pointers please
Regards
James
Use the SAN like you would any drive. Attached it to the machine, and store
your databases and T-logs on it.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"James" <hushdontspamme@.Hotmail.com> wrote in message
news:ebTQvZjzEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> We have a client that wants to implement a SAN to be shared by other
> servers.
> How do you setup a SQL server to use the SAN array? The client only has
> one SQL server (node).
> I have implemented SQL onto Active/Active and Active/Passive clustering
> before, but i am confuse to just how to install single SQL node to a SAN
> array (i.e no failover)
> Can anyone give me some pointers please
> Regards
> James
>
|||Hi
Thanks for your relpy. So i am guessing that SQL will detect the SAN as
another drive (once the SAN is attached to the server).
Cheers
James
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OL3vycjzEHA.1192@.tk2msftngp13.phx.gbl...
> Use the SAN like you would any drive. Attached it to the machine, and
> store your databases and T-logs on it.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "James" <hushdontspamme@.Hotmail.com> wrote in message
> news:ebTQvZjzEHA.1300@.TK2MSFTNGP14.phx.gbl...
>
|||Correct, its surprising easy
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"James" <hushdontspamme@.Hotmail.com> wrote in message
news:ez4lCDkzEHA.2016@.TK2MSFTNGP15.phx.gbl...
> Hi
> Thanks for your relpy. So i am guessing that SQL will detect the SAN as
> another drive (once the SAN is attached to the server).
> Cheers
> James
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OL3vycjzEHA.1192@.tk2msftngp13.phx.gbl...
>
|||James,
Just like traditional SCSI, attaching a server to a SAN requires a
controller. Once installed and the SAN is configured you will see one or
more additional drive letters (a few administrators use mount points but
usually in very large implementations). Before you attach, discuss your
requirements with the SAN administrator.
How much disk do you need for data?
What will the RAID configuration be?
How much for logs?
How much for backups?
Will the SAN be used for SQL backups or mirror splits?
How much for tempdb and so on...
You can keep spreading the activities out with more files, filegroups, and
drives.
Good luck,
Danny
"James" <hushdontspamme@.Hotmail.com> wrote in message
news:ebTQvZjzEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Hi
> We have a client that wants to implement a SAN to be shared by other
> servers.
> How do you setup a SQL server to use the SAN array? The client only has
> one SQL server (node).
> I have implemented SQL onto Active/Active and Active/Passive clustering
> before, but i am confuse to just how to install single SQL node to a SAN
> array (i.e no failover)
> Can anyone give me some pointers please
> Regards
> James
>
sql
No comments:
Post a Comment