I’ve recently taken on a SQL Server related assignment with a client running a very large database in a very poor environment.
We have a 200GB database with virtually no failover support. I’m interested in transactional replication, hardware redundancy, failover support and find that before moving forward on that we probably need to seriously re-evaluate our whole logical and physical design. My experience is more on the TSQL side rather than full dba hardware, optimization, tuning areas. Any suggestions for quickly ramping up my skills on the dba side (books, courses, etc.) and also recommendations for short term support resources would be appreciated. I’m want to make sure I cover all my bases with regard to future scalability, disaster recovery, high availability etc.
I have a 250GB database running on a server that has no failover or replciation running on it. It is for the desktop group, and they did not want to spend the money on all that fancy stuff. If they lose the data, they are OK with that as a risk. Is the client asking you to "bulletproof" this system? Or give them more uptime?
We'll have to start a new thread for that, maybe like a television plea..."Do you or someone you know suffer from lack of redundancy? MCrowley is the poster child for this sometimes fatal affliction and with your help, we can find the cure. Do you know what it's like to not sleep at night? Wondering if/when your hard disk was going to crash and how painful that would be (yikes)? When you wouldn't be able to boot it backup up (ouch)? When you would finally hit that big blue-screen in the sky? We're accepting donations now! Please call and be as generous as you can (large bills PREFERRED but smaller ones will NOT be rejected). Together we can help MCrowley and finally relieve him (her?) of this pain once and for all. Let's do it for all the MCrowleys in the world, one MCrowley at a time. Thank you for your support." - Sorry, it's almost the weekend and I'm out of here in like 20 minutes so I'm a little stoked. And what a way to begin posting on a new forum. I guess the only way for me to go from here is up!