myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Unable to restore database. Options · View
cclemon
Posted: Wednesday, December 17, 2008 9:29:19 AM
Rank: Member
Groups: Member

Joined: 12/17/2008
Posts: 10
Points: -61
Hello.

Follow the WH Backup Restore Configuration Guide, but failed to restore.

The following is the environment.

WEB: IIS7.0 on Windows Server 2k8
SQL: SQL Server 2k5 on Windows Server 2k8

I have to try Configuration#2 at the guide.
Backup is not a problem.
When restore operations, the following error appears.


Code:
Offending URL: http://xxxx.xxxx/mla/tools/restorewh.aspx

Source: mla_gui

Message: Object not set to an instance of an object reference.

Stack trace: mla_gui.RestoreWH.btnSubmit_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Target site: Void btnSubmit_Click(System.Object, System.EventArgs)



How should respond to this error?
I am very worried. Please, please help.

Thanks,
elian
Posted: Wednesday, December 17, 2008 9:43:21 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Hi - It looks like you did not correctly specify the sysadmin info in the config.xml or web.config file.

In order to solve that quickly, it would be easier that you contact us from a livechat session: http://mylittleadmin.com/en/support.aspx then click on the Live Chat icon

Regards
cclemon
Posted: Wednesday, December 17, 2008 1:09:37 PM
Rank: Member
Groups: Member

Joined: 12/17/2008
Posts: 10
Points: -61
elian

Thanks to resolve the issue.
Thanks so much!

Regards
cclemon
Posted: Thursday, March 12, 2009 8:06:44 AM
Rank: Member
Groups: Member

Joined: 12/17/2008
Posts: 10
Points: -61
Hi elian.

Thank you very much recently.

I noticed another problem.

10MB if I can restore files around.
However, 30MB caused an error when trying to restore the files.

The error code is [404].

Aborted connection.
Was reset The connection to the server during the page load.
I'm out of links in the network connection. Please try again.


About upload size limit is defined as follows.

<httpRuntime executionTimeout="900" maxRequestLength="2048000" />

What causes this? Please tell us what to do.

Regards
elian
Posted: Friday, March 13, 2009 7:29:05 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
myLittleAdmin does not use upload component, thus uploading large file will often fails. In order to backup/restore large db, please consider myLittleBackup.

Anyway, there are a few things to check:

1. in your web.config file, check that the executionTimeout and maxRequestLength properties are correctly set

2. if you're using URLScan, URLScan has its own maxRequestLength-like property. You need to update it too.

3. if you're using IIS7, by default in IIS 7 requestFiltering has the MaxAllowedContentLength property enabled. It specifies, in bytes, the maximum length of the content in a request. The default is 30,000,000 (approximately 30 megabytes.)

To change this value you must edit the following file:
%windir%\System32\inetsrv\config\applicationHost.config.

In the ApplicationHost.config file, locate the <requestLimits> node.
Modify the following code.
<requestLimits maxAllowedContentLength ="209715200" />
(Note that maxAllowedContentLength is in bytes, 209715200 is around 200 Mb)


Hope this helps
cclemon
Posted: Friday, March 13, 2009 7:55:00 AM
Rank: Member
Groups: Member

Joined: 12/17/2008
Posts: 10
Points: -61
elian

My problem was caused by URLscan.
Has been successfully resolved in a way you know!
Thank you very much. Thanks.

Regards
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.