Access Denied Error Message When Modify Backup Path
Posted on 2008-11-17
I want to backup several databases on the live server so I can restore to another server in a test environment. I want to backup since I cannot stop the real database to copy it because its in production.
I right click the database under databases. Select "Backup" then at the bottom where it says desktionation, it lists a non-existent path such as \ABSupport.bak If I use that it says the path doesnt exist. If I click remove on it, I can, but when I click add it says "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Express.Smo)"
I am able to backup several of the other databases that for some reason point to a valid path, I just rename them after it backups.
I am logged in as the domain admin, so im out of things to check. What can cause this?