Hi.
If i try to recover a SQL 2000 Database with veritas be 10 SP5 with SQL server agent, the first time it' s all ok, but of o try to repeat the restore operation, with the same db or with another db, i've this error:
Unable to create selection list
I've activated log and I find this error:
SQLLog(5181):OLEDB CreateCommand starts: cmd=0x24d5a04
[0436] 07/09/07 16:02:52 -1 SQLLog(5182):{? = CALL DBO.SAVERESOURCE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} hr=80040e2f
[0436] 07/09/07 16:02:52 -1 SQLLog(5183):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'.
[0436] 07/09/07 16:02:52 -1 SQLLog(5184):OLEDB CreateCommand ends: ~CSQLCommand: m_cmd=0x24d5a04
[0436] 07/09/07 16:02:52 -1 SQLLog(5185):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'.
[0436] 07/09/07 16:02:52 -1 Error(6/10): 3621:native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated.
[0436] 07/09/07 16:02:52 -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'.
[0436] 07/09/07 16:02:52 -1 Error(6/10): -536837662:-536837662: :: -2147217873:The statement has been terminated.
[0436] 07/09/07 16:02:52 -1 PRINO End(5179): nRet=e00081e2
[0436] 07/09/07 16:02:52 -1 SQLLog(5186):~CDataRowset ReleaseAccessor dbRefcount = 0 hr = 0x0
[0436] 07/09/07 16:02:52 -1 SQLLog(5187):OLEDB CreateCommand ends: ~CSQLCommand: m_cmd=0x24ccf34
[0436] 07/09/07 16:02:52 09 ScriptMgrBO, ParseServerAndResourceInfo: Failed:0xe00081e2.
[0436] 07/09/07 16:02:52 -1 SQLLog(5188):
What can i do?
Thank's Roberto
