Troubleshooting: SharePoint Sites Missing from Site Selection Tree in Backup Page
KB ID: 35
Cause 1:
The error occurs when there is no portal site available to list. This typically happens for WSS2.0/SPS2003, and there are no issues for WSS3.0/MOSS2007 and MS SharePoint 2010.
Solution 1:
1. Enter a valid portal site URL.
2. Add the portal site through the menu "Backup -> SharePoint -> SharePoint Settings -> Portal Site Settings (tab)".
3. Confirm the successfully added portal site is listed in the table below.
4. Only portal sites listed in this table will appear in the "Backup >> SharePoint" page. Refer to the SharePoint Settings section for detailed instructions.
Cause 2:
If the path of "STSADM.EXE" provided in "Backup -> SharePoint -> SharePoint Settings -> Path Settings (tab)" is incorrect or empty.
Solution 2:
1. Enter the exact path of STSADM.EXE through the menu "Backup -> SharePoint -> SharePoint Settings -> Path Settings (tab)".
2. For WSS2.0/SPS2003, usually found in C:/Program Files/Common Files/Microsoft Shared/web server extensions/60/BIN folder.
3. For WSS3.0/MOSS2007, typically found in C:/Program Files/Common Files/Microsoft Shared/web server extensions/12/BIN folder.
4. For MS SharePoint 2010, usually located in C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/BIN folder. Refer to the SharePoint Settings section for more details.
Cause 3:
SQL Server service is not running.
Solution 3:
1. Check if the SQL Server instance associated with the SharePoint farm is running.
2. If the SQL Server service is stopped, StoreGrid will be unable to list the site collections under a portal site.