Im using dbo schema for ABC SQL Server 2005 Enterprise database on my laptop. I would like to deploy the ABC into a server running on SQL Server 2005 Standard database. The server database is using abcuser schema. I can do attach/detach and backup/restore on the server.
I got error so I generated sql script and install into the server. So now I see all the tables are created with abcuser schema. Once I tried to generate a backup from the server I got the following error. what is the problem guys
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)
I have no idea what it means by insufficient access rights. How do I solve it
insufficient access rights error when doing backup
Mark Berndt MCSD
You can backup database without any GUI. Just execute the command: "backup
database ABC to disk='c:\fa.bak'"DmVa
i have followed the same methods ..registry updates and restarted the system ..using windows xp prof. sp2 with sql server 2005..
i can take backup from query analyzer..i want take backup from GUI...
still error shows
"property backup directory 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 "..pl.
Le Van Dung
All you have to do is add a string value to the registry pointing to the default backup directory for the given SQL Instance.
For instance, if you are in the default SQL instance, create the "BackupDirectory" string value under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer and in the value itself put the complete path for the default backup directory you want.
If you are unconfortable working in the registry, paste the text between # to a file and rename it DB_Bck.REG.
Just run it and you should be good to go:
#
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer]
"BackupDirectory"="C:\MyBckDir"
#
After running this, your default backup directory for the default instance of your SQL Server points to C:\MyBckDir (make sure you create the folder).
If you have a named instance of a SQL Server, just add the name of instance before "\MSSQLSERVER". If you have an instance named FAXSERVER, you must use the following key:
#
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\FAXSERVER\MSSQLServer]
"BackupDirectory"="C:\MyBckDir"
#
Hope this helps.
Fakrudeen Ali Ahmed