Single Storage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ahmadzia673 - 28 Mar 2006 13:28 GMT

Hi,

Is it possible to use a single storage with multiple SQL Servers??

Regards
Ahmad Zia

Reply to this Message

Geoff N. Hiten - 28 Mar 2006 20:15 GMT

If you mean a single data store where multiple servers update the database,
then the answer is "No". SQL Server is not architected in a way to support
that. If you need more transactional processing power, purchase a larger
server.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi,
>
> Is it possible to use a single storage with multiple SQL Servers??
>
> Regards
> Ahmad Zia

Reply to this Message

Linchi Shea - 28 Mar 2006 22:45 GMT

In addition to what Geoff said, if the data is read only, you can present the
same storage to multiple SQL Server instances on different hosts.

Linchi

> If you mean a single data store where multiple servers update the database,
> then the answer is "No". SQL Server is not architected in a way to support
[quoted text clipped - 7 lines]
> > Regards
> > Ahmad Zia

Reply to this Message