For doing so please use the following command. Before executing the following command I will strongly recommend that you back up your database and restore it with a different name and then try the following command on the new database instance.
IF EXISTS (SELECT name FROM sys.partition_schemes WHERE name='AuditPScheme')
BEGIN
SELECT
CASE WHEN ind.type != 1
THEN
'DROP INDEX [dbo].[AuditBase].' + QUOTENAME(ind.name) + ' '
ELSE ' '
END +
'CREATE ' + CASE is_unique WHEN 1 THEN 'UNIQUE ' ELSE '' END +
ind.type_desc + ' INDEX ' + QUOTENAME(ind.name COLLATE SQL_Latin1_General_CP1_CI_AS ) + ' ON [dbo].' + QUOTENAME(OBJECT_NAME(object_id)) + ' (' +
REVERSE(SUBSTRING(REVERSE((
SELECT name + CASE WHEN sc.is_descending_key = 1 THEN ' DESC' ELSE ' ASC' END + ','
FROM
sys.index_columns sc
JOIN sys.columns c ON sc.object_id = c.object_id AND sc.column_id = c.column_id
WHERE
OBJECT_NAME(sc.object_id) = 'AuditBase' AND
sc.object_id = ind.object_id AND
sc.index_id = ind.index_id
ORDER BY index_column_id ASC
FOR XML PATH('')
)), 2, 8000)) + ')' +
CASE WHEN ind.type = 1
THEN
' WITH (DROP_EXISTING = ON) ON [PRIMARY]'
ELSE
' '
END as Script
INTO #indexesScript
FROM sys.indexes ind
JOIN sys.partition_schemes ps on ind.data_space_id=ps.data_space_id
WHERE
OBJECT_NAME(object_id) = 'AuditBase'
AND ps.name = 'AuditPScheme'
AND is_unique_constraint = 0
SELECT * FROM #indexesScript
DECLARE @recreateScript nvarchar(max)
DECLARE indScript CURSOR FOR
SELECT Script FROM #indexesScript
OPEN indScript
FETCH NEXT FROM indScript INTO @recreateScript
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRANSACTION t1
Execute sp_executesql @recreateScript
IF @@ERROR > 0
BEGIN
ROLLBACK TRAN t1
declare @message varchar(max)
set @message = 'Audit history recreate index failed. SQL: ' + @recreateScript
RAISERROR (@message, 10,1)
END
ELSE
BEGIN
COMMIT TRAN
END
FETCH NEXT FROM indScript INTO @recreateScript
END
DROP PARTITION SCHEME AuditPScheme
DROP PARTITION FUNCTION AuditPFN
CLOSE indScript
DEALLOCATE indScript
DROP TABLE #indexesScript
END
CREATE UNIQUE CLUSTERED INDEX [cndx_PrimaryKey_Audit] ON [dbo].[AuditBase] (CreatedOn DESC,AuditId DESC) WITH (DROP_EXISTING = ON) ON
DROP INDEX [dbo].[AuditBase].[ndx_PrimaryKey_Audit] CREATE NONCLUSTERED INDEX [ndx_PrimaryKey_Audit] ON [dbo].[AuditBase] (AuditId ASC,CreatedOn DESC)
DROP INDEX [dbo].[AuditBase].[ndx_ObjectId] CREATE NONCLUSTERED INDEX [ndx_ObjectId] ON [dbo].[AuditBase] (ObjectId ASC,CreatedOn DESC)
DROP INDEX [dbo].[AuditBase].[ndx_UserId] CREATE NONCLUSTERED INDEX [ndx_UserId] ON [dbo].[AuditBase] (UserId ASC,CreatedOn DESC)
DROP INDEX [dbo].[AuditBase].[fndx_ObjectTypeCode] CREATE NONCLUSTERED INDEX [fndx_ObjectTypeCode] ON [dbo].[AuditBase] (ObjectTypeCode ASC,CreatedOn DESC)
DROP INDEX [dbo].[AuditBase].[ndx_SystemManaged_Audit] CREATE NONCLUSTERED INDEX [ndx_SystemManaged_Audit] ON [dbo].[AuditBase] (CallingUserId ASC,Action ASC,Operation ASC,CreatedOn DESC)
Once done now you can backup the database and it will be restored without any problem on SQL Server 2012