| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-04-19 : 20:23:39
|
| Can anyone let me know the new Disaster Recovery (DR)\High Availability (HA) solution introduced with SQL Server 2005 also their benefits?Also What was the new programming language introduced in the relational engine and enabled this language?Thanks All. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-19 : 22:32:47
|
| Thanks Tara for responding.I was reffering to the Procedure in general for both questions as they were asked me to expedite in detail for the Organisation.I dont have certain clue as to how to respond to such, to implement and document.Your contribution invaluable. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-20 : 03:33:20
|
quote:
Originally posted by dbalearner
I was reffering to the Procedure in general for both questions as they were asked me to expedite in detail for the Organisation.
I think you need to get more details from the Organisation. There's not enough information herequote:
I dont have certain clue as to how to respond to such, to implement and document.
Maybe consider getting a consultant in, one who does know DR well.--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-20 : 17:30:05
|
| Idea is to formulate the situation but I dont have any clue as to where to begin and how to manipulate thereafter.Any starting points for me.......Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-20 : 21:02:45
|
| I really Appreciate the Helping Forum for not giving enough feedback on my question and I have just the WORD called DR,and unfortunately as I do have little understanding and all I want to know is how in first place if at all (hope not) getting into real practise for the DR procedure.May be I need to put like this What are the Subjects I need to keep in mind for DR to Adopt.May be I need to know what are the Preliminary steps needs to adhere before I could land for myself in doing the DR methods.May be I need to know the types of Precautions to be adopted.May be I need to know the supporting arguments for the DR.These are some of the issues I gave a thought as I have to formulate and document and implement when it is required. If nothing happens by far this happens, I need to know them. In this perspective, perhaps I need to accumulate enough information regarding DISASTER RECOVERY and HIGH AVAILABILITY.Thanks all for your patient replies despite my little inputs. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-21 : 03:22:06
|
| I think you need to do a lot of research and reading yourself first. DR (disaster recovery) is a very wide topic and covers everything from data to networks to electricity, plus the planning, processes, procedures that go around. It's not a single feature that you can simply implement.Start with your favourite search engine and see what it returns. See what's on MSDN/TechNet. On the book side, Pro SQL Server Disaster Recovery, is a decent enough book and fairly good to start with.Otherwise, as I suggested, consider getting a consultant in to evaluate your needs and make recommendations--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-22 : 01:55:02
|
| Thanks GMonster and Tara as you have ascertained to get someone to employ to administer the DR and High Availability. I would rather have hands on this subject and hopefully would like to implement from scratch analysis and go thereby in step-wise manner.I strongly believe it is the matter pertaining to organisation needs and strengths, based on this I would use the available script and use go from thereafter.Thanks once again for your words. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-22 : 05:14:53
|
| You definitely need to do a lot of reading if you want to implement the DR yourself, plus you should try out various features on a test server, make sure you understand how they work. It's not something that someone on a forum can just tell you about.--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-26 : 17:59:24
|
| I knew DR is big subject pertaining to the environment.I have started with backups like storing on the flat file system which is 1-day old; on to the tapes for 30 days old; Also using compression method for storing and Application related on user's intervention.These are some of the methods utilised for retrieving the lost information based on time and date.May be I need some more inputs for the worst case scenario.(Which I haven't come across)Thanks all. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-27 : 04:52:26
|
| I'd prefer not to go into too much detail. It was embarrassing. That said, it wasn't my database, I was just assisting.To briefly summarise...All backups were local, because offsite storage was waiting for more drive space.The database was mirrored but the mirror was offline for hardware upgrades (specifically disk)A SAN drive failed (no big deal, RAID 5)A san controller went offline (no big deal, they were paired, the second controller took over)Then someone decided, while the mirror was offline and the offsite storage not available, to fix the SAN. Replaced the drive and reinitialisd the controller. The controller promptly wrote garbage across the two LUNs that it controlled, including the Primary data file and the local backup drive. Irreparable corruption, non-restorable backup--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-27 : 04:57:46
|
quote:
Originally posted by dbalearner
I knew DR is big subject pertaining to the environment.I have started with backups like storing on the flat file system which is 1-day old; on to the tapes for 30 days old;
What happens if the drive containing the backups fails?Do you test your backups? Are they restorable?Do you know how to do point in time restores?quote:
May be I need some more inputs for the worst case scenario.(Which I haven't come across)
What happens if the disks containing the database fail?What happens if the server's hardware (CPU, power supply) fails?What happens if someone accidentally drops a critical table?What happens if there's a fire in the data center that destroys the server, the local storage and the tape backup device (along with any tapes there)--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-27 : 21:01:14
|
Wonderful Gail Shaw.You have answered all my unknown questions and I have spared them across the Infrastructure to discuss them and We are in the right direction.As you said I have ANSWERED all of them and they were all FINE and in the worst scenario, we are prepared for the NECESSARY ACTION.What happens if the drive containing the backups fails? Infrastructure Informed and we have SAN working on 3 LUNS with RAID5 Do you test your backups? Are they restorable?DATABASE RELATED: now backups were intact in 3 forms.Do you know how to do point in time restores?Yes I have tested for PIT Recovery on Development ServerOther Questions we are still discussing with available hardware equipment to the planned structure for the backups - recovery - Storage - Capacity - infrastructure - Planning for the next near future - anticipated growth - possible DB restructuring etc.....Thank you very much Tara Kizer for initiating the problem to another Hall of fame Gail Shaw - your contribution here is worth, and those who read this thread will draw some ideas and conclusions.You are unpaid for this paid job. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-28 : 03:43:35
|
| That was just a quick couple of questions off the top of my head. Are you sure you want to risk your company's data based on a couple of questions that someone posted in their free time?I see far too many companies that think they have DR in place, until a disaster happens.--Gail ShawSQL Server MVP |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-28 : 17:59:03
|
| Unfortunately, the current organisation doesn't possess one such DR and they asked me to formulate and thereafter we will be poised for the think-tank (Includes support experts)to facilitate with exact plan for what we have.What I was trying to do from the begining was, I should not miss any possible basic points for DR and High Availability since I was not aware of some of the basics.As you said, I will not take someone who posted in their leisure time, but I know the Value of the points and will be grilled on them; and investigate them from my perspective and move the ball rolling for us.So far I have got and more to come and this maiden step will give us to ignite the things to full exposure.Thanks once again. |
|
|
|
|
Server and Database Related
Tara Kizer