Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
advice please
0 views
Skip to first unread message
mcnewsxp
Jan 21, 2010, 1:09:53 PM1/21/10
to
i need a quick way to provide failover for my sql server. i just want
to have a backup ready to go if server A fails. i will have only two
servers. should i use clustering or mirroring?
tia,
mcnewsxp
to have a backup ready to go if server A fails. i will have only two
servers. should i use clustering or mirroring?
tia,
mcnewsxp
Geoff N. Hiten
Jan 22, 2010, 12:20:45 PM1/22/10
to
Forst of all, there are a LOT of other variables so you really need to read
up on them.
up on them.
Short answer is that clustering fails over the whole server (instance).
Mirroring fails over at the database level.
--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"mcnewsxp" <mcou...@mindspring.com> wrote in message
news:db546465-b06c-46df...@b9g2000yqd.googlegroups.com...
Uri Dimant
Jan 24, 2010, 6:47:55 AM1/24/10
to
To add on Geoff's comment take a look into Log Shipping as well
"mcnewsxp" <mcou...@mindspring.com> wrote in message
news:db546465-b06c-46df...@b9g2000yqd.googlegroups.com...
mcnewsxp
Jan 25, 2010, 2:48:46 PM1/25/10
to
well, the client has only 2 windows 2003 servers and they are running
only one database on sql 2005. i'm thinking mirroring would be the
simplest for them to maintain once i set it up for them.
only one database on sql 2005. i'm thinking mirroring would be the
simplest for them to maintain once i set it up for them.
Geoff N. Hiten
Jan 25, 2010, 8:49:27 PM1/25/10
to
That sounds like a good candidate for mirroring.
--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"mcnewsxp" <mcou...@mindspring.com> wrote in message
news:8a68b87c-62f2-4ac8...@p24g2000yqm.googlegroups.com...
0 new messages