Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikejatana
Starting Member
4 Posts |
 Posted - 2007-01-04 : 15:37:11
|
| Hi Guys,I was asked this question in a SQL Server DBA Interview:Q: Whats the best way to implement a 24x7 High-availability solution on SQL Server 2000 without depending on SQL Server Controlled scheduled backups. We want that control to be with us and not have SQL Server control it. Can anyone comment on this....Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-04 : 15:38:45
|
| For our high availability environment, we use MS clustering with SQL Server Enterprise Edition. We also have a disaster recovery site that we either log ship (2000) or database mirror (2005) to. We have redundant hardware everywhere at both sites.I don't know what you mean by SQL Server controlled scheduled backups.Tara Kizer |
 |
|
|
mikejatana
Starting Member
4 Posts |
Posted - 2007-01-04 : 15:41:10
|
| Thanks Tara,You make sense.. but just as you, I was also confused by what they meant.. by saying that they don't want SQL Server to control that...a bit strange.. but there might be some insight to it... |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-01-05 : 06:25:07
|
| I would guess that they want to use some other backup software to backup the SQL Server databases. Not something I'd want to put in place for a High Availability solution.What we are implementing is a dual site, solution using MS Clustering with SQL2K EE. We don't do log shipping as we have 2 SAN's at each site and are using SAN Based Hardware mirroring over a dedicated Dark fiber connection. If site A goes down the SQL Cluster and the SAN Disk groups Fail over as one Disaster Recovery Group . . . . Well thats the plan anyway, Its going to be interesting to implement it, and then we have to test the DR Failover . . and all the potential points of failure.-- RegardsTony The DBA |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2007-01-05 : 06:41:18
|
| I would assume that they are steering you away from mentioning SAN based backup technologies or SAN level disk replication, which could serve as a secondary site / availability solution but would be distinct from SQL technology. I doubt that there would be a "correct" answer as such, but they are probably expecting to hear about server clustering, log shipping and database mirroring, among other things.-------Moo. :) |
|
|
|
mikejatana
Starting Member
4 Posts |
Posted - 2007-01-05 : 10:08:30
|
| Thanks guys for all your comments...will try to do some more research into this and see what all options are there...Regards,Mike. |
|
|
|
|
|
|
|
|
Implementing 24x7 High Availability