Hi Team,

Please provide me best solution for me

Due to space issue it(sp2) was failed on 27^th march.so I try to run the setup once again it has failed , I read the log file it has 2015-03-30 08:08:23 Slp: Skipping Action: GetInstanceNameByInstanceIdAction

2015-03-30 08:08:23 Slp: Action is being skipped due to the following restrictions:

2015-03-30 08:08:23 Slp: Condition "Is the datastore flag /Scenario/Patching/IsRunningInnerSetup set" did not pass as it returned true and false was expected.

2015-03-30 08:08:24 Slp:

 i did uninstall  reboot and try to re-install the service pack then no use again it is failed

Thanks

Murali

Only case I remember SQL Server service pack can fail due to space issue is when Drive on which resource database resides does not have enough space.

As per MS

Make sure enough space is available on drive where resource/system databases are present. Resource database is utilized during service pack upgrade. The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of SQL Server, upgrading required dropping and creating system objects. Because the Resource database file contains all system objects, an upgrade is now accomplished simply by copying the single Resource database file to the local server.

Please make sure space is enough

I had same issue.

Check log files at,

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150xxxxxxx\MSSQLSERVER

"Summary_servername_datestamp.txt"

This file should give a more plain-english information about the error. For us it was as some others have stated an incorrect Data Root folder.

Check registry and path set at this key (note the "MSSQL11.MSSQLSERVER" is default instance and might differ for you):

\HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL11.MSSQLSERVER\Setup\SQLDataRoot

Ours had changed - updating this entry fixed.