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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-12-02 : 16:08:26
|
| Hi,I am working on a project where sql server and windows server is manged by server team. Now client is thinking to seperate services so sql server should be handled by dba support team. So we will transition support from server team to dba team. What I am thinking to give dba team access to this database server and after that they will continue support. is it right or something more I have to do? Client also ask to prepare documentation for this tranisition? Is there any specific document I have to prepare, any guideline etc. Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-12-02 : 18:19:02
|
| Most shops I've seen give the DBA system administration rights on the SQL Server machine. If this seems like too many rights, I'd be interested to see what people list as the correct set of rights.As far as the documentation, you'll want to delineate the responsibilities for maintenance and disaster recovery. Items such as:1) Who is responsible for the hardware?2) Which software patches get applied by whom? (e.g., OS and application patches by IT but SQL patches by the DBA)3) Security: How are new users added at the OS level? At the SQL Level?4) Who handles database backups? Who performs archiving of backups to offline media?5) Disaster recovery (Major): Who is responsible to which parts of the system?6) System resource monitoring: Who will track usage (CPU, IOPS, etc.) Who will track disk usage (Available space)?7) Who has system design authority? (We want disks laid out this way but they want it laid out that way)Just a few thoughts and I'm sure you'll think of others. The important thing is to clearly define who is responsible for what.HTH=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
 |
|
|
|
|
|
Transitioning