RE: MS SQL Farm

Ruski

http://www.microsoft.com/sql/evaluation/casestudies/default.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/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
.

Relevant Pages

  • Re: Is TFS a Dev or Production System?
    ... you give the developers rights to TFS through the TFS bits only. ... Backup is primarily on the TFS SQL Server database, as that is where everything is stored. ... it is production. ... As stated, this is not an issue, as developers cannot directly access the system; they work through tools to check in/out source, update work items. ...
    (microsoft.public.vstudio.general)
  • MS SQL Farm
    ... infrastructure that will help us leverage MS Sql server. ... implementation and design will be done by us developers. ... development/test and production servers with stand by servers. ... Appliance storage. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Developers Access in PROD
    ... I was assuming that you were talking about developers on a development box. ... The first concern is the sensitivity of the production data. ... > with users in PROD. ... >>> In your SQL Server shop, what kind of access has been ...
    (microsoft.public.sqlserver.security)
  • SQL Server 2000 on SBS 2003
    ... of it in production, I prefer to use SQL Server based on ... Regards ... Chip ...
    (microsoft.public.sqlserver.server)
  • Re: Question on conversion to ADP
    ... parameters through VBA/pass-through queries. ... help/guidance coming from Microsoft for Access developers trying to ... Microsoft Access or SQL Server 2005: ...
    (microsoft.public.access.adp.sqlserver)