July 31, 2010 at 4:00 am
In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.
My bad uck they didn't provide me any documents also.
servers are sql server 2005 servers.
So please give me suggestions what are the activities need to test or to create from my side.From Application team everything was over.
There was a daily sheduled full backup.But it was shedule at afternoon timings.There is no hourly log back up.
please advise me what to do
Thanks in advance..............
July 31, 2010 at 7:29 am
sql dba kittu (7/31/2010)
In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.My bad uck they didn't provide me any documents also.
servers are sql server 2005 servers.
So please give me suggestions what are the activities need to test or to create from my side.From Application team everything was over.
There was a daily sheduled full backup.But it was shedule at afternoon timings.There is no hourly log back up.
please advise me what to do
Thanks in advance..............
Seriously, tell management they need to hire someone who knows what to do. I know you won't like this answer, but if you had to come here and ask that question, then you're obviously not the person your company needs. Hiring someone who knows what to do may not be in your best interest, but it would probably be best for the company.
Edit:
Ok, although I stand by what I said above, I agree that it's not very helpful for someone like you. You need to become a SQL Server DBA by Monday. For now, I'd make Google search my best friend. Search for topics such as "maintaining SQL server", "SQL DBA checklist", "SQL server backups", etc. (I haven't run a search on these topics so I cannot comment on what they'll return.)
On Monday, you need to sit down with your boss and discuss your training schedule.
You probably won't have time this weekend, so you might have to wait to do this during the week. Make sure your resume is uo to date.
One last thing, change that backup schedule.
I'm not a DBA, but I have been in your shoes before.
Good luck.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 31, 2010 at 9:14 am
A few links for you:
http://www.sqlservercentral.com/articles/1535/
http://www.sqlservercentral.com/articles/701/
http://www.sqlservercentral.com/articles/1353/
http://www.sqlservercentral.com/articles/62480/
I second Alvin's notes. You aren't qualified to do this, and if you lead on the company to think you are, both of you will regret this. Tell your boss you don't know what to do and get him to hire someone for a couple days to teach you, or send you to a class.
July 31, 2010 at 9:22 am
Steve Jones - Editor (7/31/2010)
A few links for you:http://www.sqlservercentral.com/articles/1535/
http://www.sqlservercentral.com/articles/701/
http://www.sqlservercentral.com/articles/1353/
http://www.sqlservercentral.com/articles/62480/
I second Alvin's notes. You aren't qualified to do this, and if you lead on the company to think you are, both of you will regret this. Tell your boss you don't know what to do and get him to hire someone for a couple days to teach you, or send you to a class.
Thanks for the support Steve.
You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with Oracle. That's what you get with managers that do not have the proper qualifications for their positions.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 1, 2010 at 1:34 pm
sql dba kittu (7/31/2010)
In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.My bad uck they didn't provide me any documents also.
servers are sql server 2005 servers.
So please give me suggestions what are the activities need to test or to create from my side.From Application team everything was over.
There was a daily sheduled full backup.But it was shedule at afternoon timings.There is no hourly log back up.
please advise me what to do
Thanks in advance..............
You probably won't think this is helpful but you need a lot of help and you're probably alienating a few folks in the process.
The title of this thread starts out with the words, "Hi i am a sql dba" and your handle has "SQL DBA" in it. My recommendation would be that if your going to ask questions that every DBA should know, you should probably stop saying that you're a "DBA". The term "DBA" is not to be taken lightly.
Don't get me wrong. I understand the spot you're in being one of the few folks who "will take care sql servers" but that's exactly why I'm suggesting you stop using the term DBA in association with yourself. You're not a DBA... you're the poor guy that is stuck with the job of trying to take care of the servers and need some help from some DBA's. If you don't want to alienate them all in a single thread, stop claiming to be a DBA... it's a skill more than it's a postition.
I'm not telling you this to be mean... I'm telling you this to help you survive on SQL Server forums when you ask a question in general. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2010 at 3:10 pm
Hi
also try to post in the correct forum. Posting a topic from which i can see has nothing to do with high availability in the HA section is not a good start. You'll get more responses if you think before posting and post into the appropriate section
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2010 at 3:56 pm
Minto access (7/31/2010)
...2 servers are going to production within 2 days....didn't provide me any documents also.
So please give me suggestions what are the activities need to test or to create from my side.
Looks like you are in between a rock and a hard place.
Start by being sure databases are recoverable meaning, there is a backup/recovery strategy in place that matches business needs.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 2, 2010 at 4:57 pm
Ah... changed my mind. See the next post.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2010 at 8:38 pm
Well done on the handle change, Minto...
Getting back to your original problem... the recommendation that a lot of people make is to do daily full backups and transaction log backups every 15 minutes or so. My recommendation would be to practice doing such things on a practice server and to read about how to do such backups in Books Online.
Just in case you don't know what Books Online is, it's the free "help" system that comes with SQL Server. If you're going to be stuck in this position you've described, you should make Books Online (sometimes referred to simply as "BOL") your best friend.
Post back if you have more questions.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2010 at 1:38 am
You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with Oracle. That's what you get with managers that do not have the proper qualifications for their positions.
Even Im with Alvin, I have seen this in many oranizations. They should understand hadling the Database is not an easy task. By creating oe taking a backup using wizard will not make you a DBA.
Go through the BOL for info on SQL Server Architect, Backup Recovery , Memory Management etc. As said earlier you have to make BOL your best friend.
"More Green More Oxygen !! Plant a tree today"
August 6, 2010 at 6:33 am
Minaz Amin (8/6/2010)
You know what upsets me about this issue? Lots of companies would not have any second thoughts about doing this with SQL Server but wouldn't dare do this with Oracle. That's what you get with managers that do not have the proper qualifications for their positions.
😀 unfortunatelly this is nothing but the naked truth.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 6, 2010 at 6:42 am
in my opinion and experience, management who are lacking the key understandings are the real issue. They dont necessarily need to be a DBA themselves but they should have a certain understanding of server systems, etc.
I came across one person who thought Access and SQL were similar :crazy:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply