MS SQL Farm

Hi all, thank in advance for your help.
The company I work for have been predominately using Oracle and IBM DB2. We
do use Sql Server on case by case basis, but there is no well implemented
infrastructure that will help us leverage MS Sql server. There has been
initiative between us (developers) to implement a structured proactively
managed Sql farm, so that we could continue developing MS Sql reliant
solutions. Unfortunately, there is not full time DBA and most of the
implementation and design will be done by us developers. More over we would
have to sell the idea to the management.
Would anyone be able to point to any source of documentation or study cases
that we could learn from? Products that will help implement and manage some
aspects of the environment such as monitoring/notification agents, backup
agents.
We were looking at implementation a solution that will be comprised of the
development/test and production servers with stand by servers . All data for
both the production and test environments will placed on the Network
Appliance storage (Filer iSCSI attached storage).
Regards,
Dominic
Ruski
http://www.microsoft.com/sql/evaluat...s/default.mspx
http://www.microsoft.com/technet/pro.../logship1.mspx
http://www.microsoft.com/sql/default.mspx
Hope this helps
Regards
CT
"Ruski" wrote:

> Hi all, thank in advance for your help.
> The company I work for have been predominately using Oracle and IBM DB2. We
> do use Sql Server on case by case basis, but there is no well implemented
> infrastructure that will help us leverage MS Sql server. There has been
> initiative between us (developers) to implement a structured proactively
> managed Sql farm, so that we could continue developing MS Sql reliant
> solutions. Unfortunately, there is not full time DBA and most of the
> implementation and design will be done by us developers. More over we would
> have to sell the idea to the management.
> Would anyone be able to point to any source of documentation or study cases
> that we could learn from? Products that will help implement and manage some
> aspects of the environment such as monitoring/notification agents, backup
> agents.
> We were looking at implementation a solution that will be comprised of the
> development/test and production servers with stand by servers . All data for
> both the production and test environments will placed on the Network
> Appliance storage (Filer iSCSI attached storage).
> Regards,
> Dominic