Sign In  |  Register
 
 DotNetNuke Powered!
DotNetNuke Support Forums

Database problem

Rate this topic:

Please Register to post a reply.
Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.

AuthorMessages
lynngrin
Posts:95



04/25/2007 12:44 PM  

Hi John

My hosting provider have removed my DNN 4.41 database from there server as it appears to be causing problems:

Problem:-
Error: 7105, Severity: 22, State: 6
Page (1:11640), slot 13 for text, ntext, or image node does not exist.    

Error: 823, Severity: 24, State: 2
I/O error (bad page ID) detected during read at offset 0x00000005af2000 in file D:\Program Files\Microsoft SQL Server\MSSQL\Data\****

 We are getting 100 of such error on the MSSQL5 server where this database resides this caused too much hike in the CPU. We have done the dbcc operations and that errors are still occuring it may be getting bad query or had invalid data entered.

So we had to detach the database after doing so the server stared responding normally.

We request you to please  get a proper database backup which is not having corrupted data.

I would appreciate any advice you may offer to help solve this problem.

Thanks

Lynn


www.drivewaydesign.eu For A Dream Driveway

www.a2zdom.com Domain name matters


John Mitchell
Posts:3380



04/25/2007 12:50 PM  
If you can get a backup and make it available to me, I may be able to fix it.
lynngrin
Posts:95



04/25/2007 5:24 PM  
Hi John

Thanks John for your very kind offer. I have been in touch with my hosting company and they are going to put a backup into my root folder. I am waiting for them to get back to me to confirm transfer.

Lynn

www.drivewaydesign.eu For A Dream Driveway

www.a2zdom.com Domain name matters


lynngrin
Posts:95



04/25/2007 6:00 PM  
Hi John

DB backup now in my site Root. I shall send you an email with details.

Thanks

Lynn

www.drivewaydesign.eu For A Dream Driveway

www.a2zdom.com Domain name matters


lynngrin
Posts:95



04/30/2007 4:48 AM  

Hi John

Thanks so much for your invaluable help.

Regards

Lynn


www.drivewaydesign.eu For A Dream Driveway

www.a2zdom.com Domain name matters


John Mitchell
Posts:3380



04/30/2007 12:59 PM  

Hi Lynn,

We do not seem to be getting each others e-mail very well so I'll post here.

I have downloaded your website and corrected the issues with the database.  It is all running locally for me.

There were several errors, and some were in the Html table, so you may be missing some content on some pages.

I have just finished uploading your clean DB to the root of your site (Eureka.bak).

Please Register to post a reply.
Another benefit of registration is the ability to subscribe to and recieve notifications of new posts.




ActiveForums 3.7
Visit our Store for great DotNetNuke Modules and Skins
DNNMasters Sitemap/Google Sitemap 3.0

Item codeSM3-01
Price$29.00
Product Information 
DotNetNuke CSS NavMenu 3.3 (Developers)

Item codeCSSNM33DEV
Base Price$149.00
Product Information 
Snapsis PageBlaster 3.3.2 for DotNetNuke - Professional Edition

AuthorJohn Mitchell
Base Price$79.00
Product Information 
XDAkuna (Web 2.0 CSS XHTML Skin)

Item codeXDAkuna
AuthorNina Meiers
Price$49.00
Product Information