Sunday 10 January 2010

SharePoint: Cannot Backup WSS 2.0 Database

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:

  1. Registry key: HKLM\Software\Microsoft\Microsoft SQL Server\SharePoint\MSSQLServer
  2. Name: BackupDirectory
  3. Type: Reg_SZ
  4. Value: C:

image

Further Information:

Microsoft TechNet: Steps performed on the Source Server for Windows SBS 2008 migration

No comments:

Post a Comment