December 26, 2005 at 6:00 am
Hi! I need your help!
I ve connected to the remote server using the Management Studio. Im accessing the database and Im getting the backup, but unfortunately I see that the back up is being saved on the remote server.
I tried to change "destination" by clicking "add" and the following error occured:
"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)"
How can I backup the database saving it on my machine?
Any kind of help would be MUCH appreciated
January 3, 2006 at 7:14 am
This is the same behaviour as SQL 2000. The back up destination is a folder on the server machine.
July 4, 2008 at 1:51 pm
Hi!
I picked up the following for the SBS 2008 migration paper:
If you receive an error stating "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)," you must add the following value to the Registry via the Regedit tool:
- Registry key: HKLM\Software\Microsoft\Microsoft SQL Server\SharePoint\MSSQLServer
- Name: BackupDirectory
- Type: Reg_SZ
- Value: C:
It may not be related to your problem. But this was the only response from google on may error. I therefore posted it.
December 2, 2008 at 5:37 pm
Hi All
I tried this fix and it worked for me, i am running SBS 2003 R2 with SQL 2005 Lite for Sharepoint
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply