I was looking through the logs on our site and the 5.6.0 log reported this from within the host settings.

"A log file does not exist for the script version specified. This generally indicates that the script was never executed."

Even though there was a error during the upgrade process, I am able to access the site and it reports the DotNetNuke version as 5.6.0. I tried to rerun the installer but nothing happens.
 
So is there a way that I can rerun the script manually? Otherwise since it appears my database backup is corrupted, I may resort to creating a new database and site and repopulate it.

I just tried that. I get this error.

System.Data.SqlClient.SqlException (0x80131904): 'IX_Lists_ParentID' is not a constraint. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'IX_Lists_ParentID') ALTER TABLE dbo.[Lists] DROP CONSTRAINT [IX_Lists_ParentID] System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Lists_ParentID' already exists on table 'Lists'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) CREATE INDEX IX_Lists_ParentID on [Lists] (ParentID ASC) on [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): 'IX_Lists_ListName_ParentID' is not a constraint. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'IX_Lists_ListName_ParentID') ALTER TABLE dbo.[Lists] DROP CONSTRAINT [IX_Lists_ListName_ParentID] System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_Lists_ListName_ParentID' already exists on table 'Lists'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String ConnectionString, String Script) CREATE INDEX IX_Lists_ListName_ParentID on [Lists] (ListName ASC, ParentID ASC) on [PRIMARY]

In the readout of the script is this little tidbit of info but I'm not sure how to do it.

/************************************************************/
/*****              SqlDataProvider                     *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/************************************************************/

Steve;
From which DNN version are you upgrading?

---

Ken Grierson
DotNetNuke Corporation
Test Lead