Posted by Greg D. Moore \(Strider\) on 11/27/06 11:34

<smokejo@googlemail.com> wrote in message
news:1164142996.477637.282180@f16g2000cwb.googlegroups.com...
> Hi
>
> I am attempting to take a manual backup of an SQL 2005 database, via
>
> Right Click on MyDatabase --> Tasks --> Backup
> [Specify the filename path and type of backup]
>
> However, when I try to specify the filename or, in fact, do anything, I
> receive the following error
>
> 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.Smo)
>
> The user I'm logged into the database with, however, has full rights
> within SQL.

Sounds like the user doesn't have full rights on the directory you're trying
to back up to.


>
> Does anyone have any ideas?
>
> Thanks!
>

• Next in forum: Need Help to form the MDX-Statement
• Prev in forum: Transposing repetitive serial fields into Table structure
• Thread view: Re: Manual back of database error

[Reply to this message]