Central Data Store

[mobius1983]

Hi All,

I'm a newbie to SQL Server, and work have just asked me to set up SQL Server on two servers, but have them both storing the data in the same folder on a NAS. So if one server goes down, and the other has to take over the data is still up to date.

Is this possible?

Thanks for all your help!

Nick.

 

[SQLDenis]

look into clustering

http://sqlservercode.blogspot.com/

 

[mrdenny]

SQL Server does not support using a NAS to store your data.

Doing so places your SQL Server in an unsupportable mode.

Store the databases on local disks, and do regular full and transaction log backups to the NAS. That way you can restore to the other server if needed.

If the systems really do need high availability then you need to look into clustering or at the least log shipping or replication.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com