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:

Further Information:

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

SBS 2003: Security Update for SQL Server 2005 Service Pack 3 (KB970892) will not install.

Security Update for SQL Server 2005 Service Pack 3 (KB970892) will not install. After running the Microsoft Baseline Security Analyzer 2.1 i found that this update had not been installed on my SBS 2003 Server. Checked WSUS and it had failed to install.

I found it to be an issue with Backup Exec and after a bit of internet trawling found this solution:

• Open the Programs and Features (Add/Remove Programs) control panel.
• Select Microsoft SQL Server 2005, and click Change.
• Select the database engine component.
• Allow the system configuration check to complete.
• Then choose Complete the suspended installation.
• You may get the error message "The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package "SqlRun_SQL.msi" in the box below." This means that the installer needs access to the original installation files.
  • In this case download SQL Express 2005 SP3 from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6.
  • Execute SQLEXPR.EXE /x and extract the installation files to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Baseline Cache\Express\SP3. This is the location recommended by the article http://support.microsoft.com/kb/955250/, but the location may not really matter.
  • Provide the Setup subdirectory of this path in response to the error dialog above.
• Installation will continue, but you may encounter an additional error "[(Microsoft] [SQL Native Client [SQL Server] Password Validation failed. The password does not meet the Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again."
  • To correct this problem, open the Registry Editor.
  • Locate the key HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\Parameters. Note that it may be MSSQL.2 or some other instance number instead of 1. For x86 operating systems, omit Wow6432Node from the registry path.
  • Create a string (REG_SZ) value named SQLArg3 and set the data to "-T4606" (no quotes).
  • In response to the error message, cancel the installation and allow it to roll back. Then try the installation again.
• Once the suspended installation of SQL Express 2005 SP3 runs to a successful completion, the KB970892 security patch should install successfully.
• You will need to start up the Backup Exec services after the patch installation.

A link to the Symantec Group is posted below as a number of other usefull solutions to this problem are posted.

Further Information:

Symantec Connect: Security Update for SQL Server 2005 Service Pack 3 (KB970892) fails to install