I have turned on logging and have found the follwoing error that occurs when I try to restore and receive the unable to create selection list error:
10/23/05 08:43:42 -1 PRINO Start(565): Object:MD_OBJTYPE_RESOURCE, Call:MID_INSERTOBJECT, Local:yes
10/23/05 08:43:42 -1 SQLLog(566):Database Exception Context:{? = CALL DBO.SAVERESOURCE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} Error:-536837662: :: -2147217873:The statement has been terminated. :: DB Error Set 0: native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated. :: DB Error Set 1: native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 SQLLog(567):Database Exception Context:Resource Insert Error:-536837662: :: -2147217873:The statement has been terminated. :: DB Error Set 0: native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated. :: DB Error Set 1: native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 Error(6/10): 3621:native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated.
10/23/05 08:43:42 -1 Error(6/10): 2601:native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 Error(6/10): -536837662:-536837662: :: -2147217873:The statement has been terminated.
10/23/05 08:43:43 -1 PRINO End(565): nRet=e00081e2
10/23/05 08:43:43 09 ScriptMgrBO, ParseServerAndResourceInfo: Failed:0xe00081e2.
10/23/05 08:43:43 -1 Error(9/8): -536837661:The database function to insert failed.