| Author |
 Topic  |
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
 Posted - 03 December 2006 : 12:28:57
|
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/bbs/admin_forums.asp, line 463
That's the error message I keep getting when I try to archive a very large forum. I've tried it in every increment and it still times out.
What can I do? All I need is to archive everything older than a year once and then I'll archive on a continual basis. |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 03 December 2006 : 12:35:29
|
| only thing you can do is try archiving it in smaller chunks (ie everything older than 2years, then everything older than 18 months etc) you may have to tweak the code to accomplish it, but other than that you are stuffed. |
 |
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 03 December 2006 : 12:46:21
|
Hm. The code only lets me archive stuff up to 1 year old.
How can I adjust it to archive things older than 2 years, etc?
(I'm not much when it comes to coding without readme's)  |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 03 December 2006 : 17:30:12
|
quote:
Originally posted by ruirib
Stan, drop me an email. I can add some code to your database and redo your archiving routine to minimize the chance of that occurring.
Email sent. Thanks Rui. |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
kodylia
Starting Member
4 Posts |
Posted - 11 April 2007 : 15:16:37
|
Sorry to break in but will you share the solution?
I also have posts from 2004 in my database and would like to archive it. |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 11 April 2007 : 15:54:10
|
There was a mod written recently by I believe Etymon to archive one topic or something like that. Do a search and you should find it.  |
|
|
| |
Topic |
|
Topic Locked
