• 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?