| Author |
 Topic Search  Topic Options
|
hans3702 
Mod Builder Group
Joined: 23 March 2003
Location: Netherlands
Status: Offline
Points: 141
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: How to backup the forum database?
Posted: 07 April 2003 at 1:01pm |
Hi,
What is a good way of backup the database
- I have a server of my own, with physical access
- run the forum with a ms access db
Now I copy the file every hour to a forder with the name(time) e.g. 1034 for 10:34
It looks that if the program ( www.secondcopy.com) backup the file and someone is post a message is will crash the forum, a lot of database access erros (80004005) after a reboot every seems to be fine again
Hans
Edited by hans3702
|
|
|
 |
MadDog
Mod Builder Group
Joined: 01 January 2002
Status: Offline
Points: 3008
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 April 2003 at 1:53pm |
|
if your database is getting big and keeps crashing then i suggest that you upgrade to SQL Server. Then you wont have to worry about forum crashes and Database errors.
|
|
|
|
hans3702
Mod Builder Group
Joined: 23 March 2003
Location: Netherlands
Status: Offline
Points: 141
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 1:46am |
It a 2,5 MB database, so don't even think about SQL.
It is just a question about how to backup.
Do I have to bring the forum down?, or can I copy the database when it is in just? Or do I need a APS program to export the data to an other database when I don't want do colse the forum for backup purpuse?
Hans
|
|
|
|
eaglesexec
Groupie
Joined: 02 December 2002
Status: Offline
Points: 127
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 2:11am |
|
u back it up every hour??? i dont even back it up once a day. lol.
|
|
A good plan, violently executed now, is better than a perfect plan next week. -General George S. Patton.
|
|
Dergal
Groupie
Joined: 21 January 2002
Location: United Kingdom
Status: Offline
Points: 67
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 2:32am |
Access 2000 is MUCH better than 97 if that helps...
Using the FSO a simple script could be setup, by backing it up every hour is HUGE... (File System Object)
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=34
I did setup a script for a client to backup his DB by simply emailing it to him...
HTH's
Gerry
Edited by Dergal
|
|
hans3702
Mod Builder Group
Joined: 23 March 2003
Location: Netherlands
Status: Offline
Points: 141
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 4:32am |
 eaglesexec wrote:
u back it up every hour??? i dont even back it up once a day. lol. |
I'm using it for customer support including, history of purchase, support and comuncations. so losing the data migh be a trigger to jump 
Edited by hans3702
|
|
|
|
svpworld
Groupie
Joined: 06 March 2003
Location: usa
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 4:34am |
Mine was less than 2.5MB but I already found it to be slow when a few users began to use it. I moved to SQL, I've never looked back! Its an expensive option unless you really shop around but worth it if you need a robust platform for your forum. I can recommend my hosting provider, I wont mention them here as I dont know if Borg approves to advertising so if your interested please email me personally. The SQL db is backed up daily by the hosting company, its possible to export it for my own personal backup but once it grows to 10's of MB then that does become rather a chore!
Simon Williams
SVPworld
|
|
hans3702
Mod Builder Group
Joined: 23 March 2003
Location: Netherlands
Status: Offline
Points: 141
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 April 2003 at 4:38am |
Dergal wrote:
Access 2000 is MUCH better than 97 if that helps...
Using the FSO a simple script could be setup, by backing it up every hour is HUGE... (File System Object) |
I even convert it to access 2002 (or was that stupit)
A FSO copy looks to me like the same as a copy with explorer at the console. So I still want to know if I and how to backup a running and active forum. Who knows it please tell
option:
I can mod/write the code sot that there be first a check of nummer of active users. before backup
|
|
|
|
