Maybe Friday isn't the best time to ask, but here goes... To improve our single instance sql2000 to High Availability standards, I'm looking into clustering, log shipping, etc. We are totally sql2k now, so we would tend to stay there. Are there any HA features in Sql2005 that are not in Sql2000? Clark
Yes, Database Mirroring give you another option for HA without the cost and hassle that clustering requires. -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous [quoted text, click to view] "Clark" <Clark@discussions.microsoft.com> wrote in message
news:B0D5C89A-3018-460D-A46D-02BC0C70CB75@microsoft.com...
> Maybe Friday isn't the best time to ask, but here goes...
> To improve our single instance sql2000 to High Availability standards, I'm
> looking into clustering, log shipping, etc.
>
> We are totally sql2k now, so we would tend to stay there. Are there any
> HA
> features in Sql2005 that are not in Sql2000?
>
> Clark
>
Thanks Arnie, that is just the feature I need. [quoted text, click to view] "Arnie Rowland" wrote:
> Yes, Database Mirroring give you another option for HA without the cost and
> hassle that clustering requires.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Clark" <Clark@discussions.microsoft.com> wrote in message
> news:B0D5C89A-3018-460D-A46D-02BC0C70CB75@microsoft.com...
> > Maybe Friday isn't the best time to ask, but here goes...
> > To improve our single instance sql2000 to High Availability standards, I'm
> > looking into clustering, log shipping, etc.
> >
> > We are totally sql2k now, so we would tend to stay there. Are there any
> > HA
> > features in Sql2005 that are not in Sql2000?
> >
> > Clark
> >
>
>
Isn't it equally valid to state that "Clustering gives you another option for HA without the cost and hassle that Database Mirroring requires." These are two different technologies for different purposes, depending on what you want to protect aginst. Linchi [quoted text, click to view] "Arnie Rowland" wrote:
> Yes, Database Mirroring give you another option for HA without the cost and
> hassle that clustering requires.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Clark" <Clark@discussions.microsoft.com> wrote in message
> news:B0D5C89A-3018-460D-A46D-02BC0C70CB75@microsoft.com...
> > Maybe Friday isn't the best time to ask, but here goes...
> > To improve our single instance sql2000 to High Availability standards, I'm
> > looking into clustering, log shipping, etc.
> >
> > We are totally sql2k now, so we would tend to stay there. Are there any
> > HA
> > features in Sql2005 that are not in Sql2000?
> >
> > Clark
> >
>
>
Of course, you're correct about that. I guess I could have been a little more 'diplomatic'. -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous [quoted text, click to view] "Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:881254F5-1D8B-438B-974C-9992CC40F184@microsoft.com...
> Isn't it equally valid to state that "Clustering gives you another option
> for
> HA without the cost and hassle that Database Mirroring requires."
>
> These are two different technologies for different purposes, depending on
> what you want to protect aginst.
>
> Linchi
>
> "Arnie Rowland" wrote:
>
>> Yes, Database Mirroring give you another option for HA without the cost
>> and
>> hassle that clustering requires.
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>>
>> "Clark" <Clark@discussions.microsoft.com> wrote in message
>> news:B0D5C89A-3018-460D-A46D-02BC0C70CB75@microsoft.com...
>> > Maybe Friday isn't the best time to ask, but here goes...
>> > To improve our single instance sql2000 to High Availability standards,
>> > I'm
>> > looking into clustering, log shipping, etc.
>> >
>> > We are totally sql2k now, so we would tend to stay there. Are there
>> > any
>> > HA
>> > features in Sql2005 that are not in Sql2000?
>> >
>> > Clark
>> >
>>
>>
>>
Be sure to install SP1 before using mirroring. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada .. [quoted text, click to view] "Clark" <Clark@discussions.microsoft.com> wrote in message
news:40CE7F40-9024-47B4-B88E-34B0E72AF2F6@microsoft.com...
Thanks Arnie, that is just the feature I need. [quoted text, click to view] "Arnie Rowland" wrote:
> Yes, Database Mirroring give you another option for HA without the cost
> and
> hassle that clustering requires.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Clark" <Clark@discussions.microsoft.com> wrote in message
> news:B0D5C89A-3018-460D-A46D-02BC0C70CB75@microsoft.com...
> > Maybe Friday isn't the best time to ask, but here goes...
> > To improve our single instance sql2000 to High Availability standards,
> > I'm
> > looking into clustering, log shipping, etc.
> >
> > We are totally sql2k now, so we would tend to stay there. Are there
> > any
> > HA
> > features in Sql2005 that are not in Sql2000?
> >
> > Clark
> >
>
>
>
Don't see what you're looking for? Try a search.
|
