Execute below T-SQL Script to get the SQL Server version details.
SELECT SERVERPROPERTY ('productversion') as ProductVersion,
SERVERPROPERTY ('productlevel') as Productlevel,
SERVERPROPERTY ('edition') as Edition
Output:
-Product version (for example, 10.0.1600.22)
-Product level (for example, SP3)
-Edition (for example, Development)
SQL Server 2012 version number examples
11.0.2316 SQL Server 2012 CU1
11.0.2100.6 SQL Server 2012 RTM
Problem: MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
Solution:
You will get the above error while applying the Service Pack to SQL Server 2005 where you have installed the Reporting Service Component as well.
You wil get the error information from summary.txt file. Below information you find from the log.
Status : Failure
Log File : D:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB2463332_sqlrun_rs.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
As you aware that, SQL Server 2005 Reporting Service is dependent on the IIS, SSRS configuration manager is using IIS for virtual directory. (Fyi, SSRS 2008 is not dependent on the IIS)
In case of the above error you have to check the status of IIS, IIS Admin Service shouldn’t be disabled and stopped.
You can check the IIS status using below command.
— To check the status of the IIS services
c:\>iisreset /status
–To start the IIS from Command Prompt follow below steps
--To start the IIS from Command Prompt follow below steps --start world wide web services c:\>net start w3svc --start the ftp service c:\>net start msftpsvc --start the smtp service c:\>net start smtpsvc --start the plesk control panel service c:\>net start PleskControlPanel --start the HTTP SSL service c:\>net Start HTTPFilter --restart IIS services c:\>iisreset /restart
You can move the job using one of the below technique.
Using SSIS
You can use the transfer Jobs Task in SSIS to move the job to different SQL Instance. Right Click on Transfer Jobs task and click on Edit…
Specify the Source Connection and Destination Connection in Jobs page. Here you have options, you can either transfer all jobs or select the specific job from the job list drop down.
By Scripting Out Job
You can also move the job by scripting it out.
You can also restore the MSDB database on target SQL Box if it is the same SQL version and there is no other jobs exist there.
You can check IIS version by simply typing http://localhost into Internet Explorer, or you can browse the registry path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\InetStp\ and check for the VersionString registry value.
Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don’t run out of disk space. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell.
aiDeeva.com 