I am pretty sure that a restore operation requires a specific SQL permission outside of the DB permissions i.e. it is a server wide thing and not specific to a database. I think you will need the dbCreator server role: http://msdn.microsoft.com/en-us/library/ms176014(SQL.90).aspx
Regards, Paul Turner Senior Solutions Specialist M: 0412 748 168 P: 08 8238 0912 F: 08 8234 5966 A: 66 Henley Beach Road, Mile End SA 5031 E: paul.tur...@dws.com.au<mailto:paul.tur...@dws.com.au> W: www.dws.com.au [cid:image001.jpg@01CA3C33.795E6AF0] ADVANCED BUSINESS SOLUTIONS LTD This email and any files transmitted with it are confidential and are only for the use of the person to whom they are addressed. If you are not the intended recipient you have received this email in error and are requested to delete it immediately. Any opinion expressed in this e-mail may not necessarily be that of DWS Pty Ltd. Please consider the environment before printing this email. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Wednesday, 23 September 2009 9:32 AM To: ozmoss@ozmoss.com Subject: SQL permissions Hi all, Our sysadmin has become very strict about permissions and service account usage in our new farm. And fair enough to. The problem is that currently I can create content databases via CA but then lack rights to do anything with it (i.e. restore operation) until I'm explicitly given access. He reckons he can't see a way around this as the setup user is always given owner rights to the DB. Does anyone have a workable solution that will allow me to automatically have appropriate permissions to all content DBs without having to rely on his interaction? Is there a 'best practice' around this? It seems nuts that I can create a database, trash any content via code and delete site collections - but am unable to perform a simple restore task! Regards, Paul Online Developer, ICT CEO Sydney
<<inline: image001.jpg>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
