Why do I see these two files at the first place?
Mssqlsystemresource1.ldf
Mysqlsystemresource1.mdf
There are other instance on this server where SP4 installation was successful and I only see below two files there.
Mssqlsystemresource.ldf
Mysqlsystemresource.mdf
While for this installation which is failing i see below 4 files.
Mssqlsystemresource.ldf
Mysqlsystemresource.mdf
Mssqlsystemresource1.ldf
Mysqlsystemresource1.mdf
Can these two files be created due to failed installation of SP4?
Also while reading the log you can see that installer is trying to rename this file to original file name.
•MSI (s) (C8!6C) [13:15:45:495]: PROPERTY CHANGE: Adding Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B property. Its value is '100Renaming Files200D:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource1.ldfD:\SQLData\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf0'.
MSI (s) (C8!6C) [13:15:45:495]: Doing action: Rollback_sqlFileRename.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
MSI (s) (C8!6C) [13:15:45:495]: Transforming table CustomAction.
MSI (s) (C8!6C) [13:15:45:495]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.
MSI (s) (C8!6C) [13:15:45:510]: Transforming table CustomAction.
Can I just move these two files Mssqlsystemresource1.ldf and Mysqlsystemresource1.mdf which is giving us problem to some other folder and eventually delete it if installation is successful?
Just one issue i see in this approach is that if all these 4 files belong to the resource database then moving this files to some other folder will make resource database corrupt?