I was preparing a SharePoint Services 2.0 database for transfer from SBS 2003 R2 to SBS 2008 running SharePoint Services 3.0.
While trying to backup the WSS 2.0 database using SQL 2005 Express I was getting the error message:
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)
Solution:
A lot of information exists on this problem, however, they all pointed to the wrong registry key for backing up a SharePoint database.
You must add the following value to the Registry:
- Registry key: HKLM\Software\Microsoft\Microsoft SQL Server\SharePoint\MSSQLServer
- Name: BackupDirectory
- Type: Reg_SZ
- Value: C:
Further Information:
Microsoft TechNet: Steps performed on the Source Server for Windows SBS 2008 migration
No comments:
Post a Comment