Posted by smokejo on 11/21/06 21:03

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.

Does anyone have any ideas?

Thanks!

• Next in forum: Database updates (using SqlDataAdapter) during runtime but Database Table Does Not Update
• Prev in forum: Conflict With Network Communications
• Thread view: Manual back of database error

[Reply to this message]