Hi,

Overall, its really a team effort with the split being division of responsibility and each team member taking care of what they are skilled at doing well. This is a regularly surfacing issue and coming from a infrastrusture background, completely understand this challenge.

In most organisations I have consulted, there is a boundry between server admins and database admins, where server admins are responsible for everything server-side such as operating system, network interfaces, O/S monitoring and application installation. Database administrators take over from server admins immediately once server (e.g. db server) is production grade and apply the appropriate security to enforce is division of labour. There are occassions where database admins would appreciate having server admin rights and the same issue surfaces, yet again.

Overall, as outlined earlier, its a team effort that requires a solid communication structure between all involved and clear allocation of responsibility to reduce overall risk. It doesn't matter who does the backup or restore as long as they are properly trained, the team communicate and the correct change control processes are in-place to reduce risk of mistakes.

Currently, I work within a team of three and I take care of majority of SQL Server server work and the infrustructure members take care of non-SQL Server tasks, but I still take the time to knowledge transfer SQL Server tasks and this works nicely.

Thank you,

Phillip Cox

MCITP - DB Admin