Q. The following message displays upon opening Agvance indicating the last database image took place a few days ago. However, it is scheduled to make an image every day. How can this be resolved?
A.
1. In some instances, the scheduled image is created in the AgvImage folder but is not copied over to the LastImage folder. To correct this, go to Start / Programs / Microsoft SQL Server 2005 / Configuration Tools / SQL Server Surface Area Configuration. Choose the option Surface Area Configuration for Features.
Select xp_cmdshell from the list on the left and select the option on the right labeled Enable xp_cmdshell.
Choose Apply and then OK.
2. If recently upgraded from MSDE to SQL Express (2005), the SQL Server Agent is no longer available. The replacement software must be purchased to continue scheduling images. We recommend Vale Software; click here for more information on this software.
In SQL 2008, the Surface Area Configuration options are in a different location. To change the settings in version 2008, run the following queries in Agvance Utilities at Utilities / Run Query / SQL Server or MSDE Database for the database named master (this is an available selection in the dropdown menu at the top of the query screen):
To allow advanced options to be changed:
EXEC sp_configure 'show advanced options', 1
To update the currently configured value for advanced options:
RECONFIGURE
To enable the feature:
EXEC sp_configure 'xp_cmdshell', 1
To update the currently configured value for this feature:
RECONFIGURE
Alternatively, log into Microsoft SQL Server Management Studio, right-click on the server name/instance name (if present) at the top of the list on the left side of the screen, and choose Facets.
Select the Surface Area Configuration facet from the drop-down list.
Change XPCmdShellEnabled to True.
