Wednesday, March 28, 2012

Put data on Windows Storage 2003

We have a NAS-server with WIndows storage 2003, with 3 data-disks in Raid.
Would it be possible to setup an SQL-server on another Windows 2003 server
but ...
put the data on the NAS-server?
And if so what could be the disadvantages?No, you can only use local storage for SQL Server (with local I include SAN,
as it is viewed by the
OS as being local). Well, there used to be a trace flag you could add to be
able to create a
database on a remote server, but the general consensus is to *not* use it an
d I don't know it that
even still exists.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MarioFromBelgium" <MarioFromBelgium@.discussions.microsoft.com> wrote in mes
sage
news:73F03CB4-87F8-4221-85FF-91AF6539B7F7@.microsoft.com...
> We have a NAS-server with WIndows storage 2003, with 3 data-disks in Raid.
> Would it be possible to setup an SQL-server on another Windows 2003 server
> but ...
> put the data on the NAS-server?
> And if so what could be the disadvantages?|||try to use the iSCSI protocol.
you can install an iSCSI target (server) on you storage server and connect
your SQL server to this iSCSI server.
the performance is better then a shared folder access.
but limited by the network speed.
for iSCSI I recommand to setup a dedicated subnet with Gbps cards and
switches that support jumbo frames.
Some Storage server vendors provides an iSCSI target in option.
"MarioFromBelgium" <MarioFromBelgium@.discussions.microsoft.com> wrote in
message news:73F03CB4-87F8-4221-85FF-91AF6539B7F7@.microsoft.com...
> We have a NAS-server with WIndows storage 2003, with 3 data-disks in Raid.
> Would it be possible to setup an SQL-server on another Windows 2003 server
> but ...
> put the data on the NAS-server?
> And if so what could be the disadvantages?

No comments:

Post a Comment