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 |
|
maryxu
Starting Member
36 Posts |
 Posted - 2008-03-03 : 17:21:41
|
| Hi, I am going to start as the only DBA in a company, very nervous, since there is no peer at the company and no transition from the job, could someone told me when I start, what would be the initial steps to take for starting? I read some article about daily activities on the job, since i used to be a development dba, now into a produciton dba with 15-20 servers, how to get to practice myself for this new job requirements? What would be the best way to fit into the organization quickly? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-03 : 17:29:54
|
Make sure you have backup and restore procedures.If not, make them.After taking backups, test them with restoring them.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
maryxu
Starting Member
36 Posts |
Posted - 2008-03-03 : 17:37:41
|
| so if things like this, people leave the firm and no existing dba, would there be a document i could follow up for the daily check list? For initially, would there be enough? To test the restore, since there are about 20 servers, the largest db size 700g, so what would be the best way to test? Each of them? thank you. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-03 : 17:49:25
|
Databases of size 70 GB and no disaster/recovery plan if responsible DBA quits?Are you sure you want the job?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
maryxu
Starting Member
36 Posts |
Posted - 2008-03-03 : 18:06:35
|
| I didn't know their recovery plan, Maybe until first date. Just try to get some sort of check list to help myself fit in. Yes, that's weird to me since there are no backup dba and i am the only one carry pager 24 by 7. |
|
|
|
maryxu
Starting Member
36 Posts |
Posted - 2008-03-03 : 19:12:34
|
| This role also require to hand reporting service, so anyone has experience on handling both? thank you |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-03 : 20:47:44
|
I am not sure if any reply to a post on a forum would give you enough information as "general" rule to apply in your situation.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 22:57:05
|
| Setup a testing server with all services and play them. |
|
|
|
|
|
|
|
|
DBA role