Topic: cannot backup SQL

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/6/2008 8:23:10 AM

By: James Landon

I'm having trouble backing up SQL data using Microsoft SQL Server Management
Studio Express. When I try backing up to the destination I get the error
message: "Property backupdirectory is not availabe for Settings
'Microsoft.SQLServer.Management.Smo.Settings' This property may not exist
for this object, or may not be retrievable due to inssuficient access
rights."

Can anyone provide a explaination for this?

Thanks
James

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/6/2008 8:23:10 AM

By: James Landon

cannot backup SQL

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/6/2008 8:23:10 AM

By: James Landon

cannot backup SQL

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/6/2008 9:47:25 AM

By: Andrea Montanari

Re: cannot backup SQL

Hi James,
James Landon wrote:
> I'm having trouble backing up SQL data using Microsoft SQL Server
> Management Studio Express. When I try backing up to the destination I
> get the error message: "Property backupdirectory is not availabe for
> Settings 'Microsoft.SQLServer.Management.Smo.Settings' This property
> may not exist for this object, or may not be retrievable due to
> inssuficient access rights."
>
> Can anyone provide a explaination for this?

for some reasons I do not know, a registry value resolving this setting is
sometime not written..
All you have to do is add a string value to the registry pointing to the
default backup directory for the given SQL Instance.

you have to resolve the "name" of the instance in order to manually "hack"
the windows registry..
if you installed only 1 instance of SQL Server, it usually defaults to
MSSQL.1, but the number can change and includes other services like
Reporting Services and Analysis Services, so MSSQL.1 can be 2, 3 or other,
so please check that MSSQL.X value and, obviously, provide the correct path
for it..

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer
"BackupDirectory"="C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Backup"

--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/6/2008 9:47:25 AM

By: Andrea Montanari

Re: cannot backup SQL

Page 1 of 2 Pages