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.
Does anyone have any ideas?
Thanks!<smokejo@.googlemail.comwrote in message
news:1164142996.477637.282180@.f16g2000cwb.googlegr oups.com...
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
>
Does anyone have any ideas?
>
Thanks!
>
No comments:
Post a Comment