Article ID: 323249 - View products that this article applies to.
This article was previously published under Q323249
In SQL Server Enterprise Manager, if you follow these steps
Error 229: Execute permission denied on object "xp_availablemedia" owner "dbo"
This problem occurs under the following conditions:
Only members of the SQL Server system administrators role (sysadmin) can view the directory structure and select local backup files. This behavior prevents you from accidentally overwriting backup files.
To work around this behavior, assign the user profile to the sysadmin role. By doing so, the user profile has unlimited access to all SQL Server features.
REFERENCESFor more information about the sysadmin role, view the "Adding a Member to a Predefined Role" topic in SQL Server Books Online.
Article ID: 323249 - Last Review: October 3, 2003 - Revision: 3.3