I have recently had to restore my DNN installation from a backup after a bundled attempt by 1and1 to upgrade there servers to ASP.NET 2. They have now downgraded me back to 1.1 but this did ireversible damage to my DNN install. So I am left with no option than to restore from a backup.

I have a backup of the entire SQL database and the whole DNN folder. When I restore both the folder and the database I get the following error:

Server Error in '/DNN' Application.
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +195
Microsoft.ScalableHosting.Security.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +363
Microsoft.ScalableHosting.Profile.SqlProfileProvider.CheckSchemaVersion(SqlConnection connection) +62
Microsoft.ScalableHosting.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +703
Microsoft.ScalableHosting.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +410
Microsoft.ScalableHosting.Profile.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +264
Microsoft.ScalableHosting.Profile.SettingsBase.GetPropertyValueByName(String propertyName) +101
Microsoft.ScalableHosting.Profile.SettingsBase.get_Item(String propertyName) +102
Microsoft.ScalableHosting.Profile.ProfileBase.get_Item(String propertyName) +5
Microsoft.ScalableHosting.Profile.ProfileBase.get_Item(String propertyName) +0
DotNetNuke.Entities.Users.UserController.FillUserProfile(UserInfo objUserInfo) +317
DotNetNuke.Entities.Users.UserInfo.get_Profile() +50
DotNetNuke.Entities.Users.UserInfo.get_FirstName() +32
DotNetNuke.Entities.Users.UserController.FillUserInfo(IDataReader dr, Int32 PortalId) +804
DotNetNuke.Entities.Users.UserController.GetUser(Int32 PortalId, Int32 UserId) +94
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +760
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +92
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3757
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

I know that it is looking in the wrong place for the procedure as it should be looking at dboxxxxxxx and not dbo. However I have no idea why it is looking in the wrong place and how to fix it.

Please help me!! I am desperate as my whole site is down.