Page 2 of 2 FirstFirst 12
Results 21 to 32 of 32

Thread: ClubSNAP Forums Database damaged

  1. #21
    Member
    Join Date
    Feb 2006
    Location
    Bukit Timah
    Posts
    145

    Default Re: ClubSNAP Forums Database damaged

    Thanks for restoring the server and for your effort. It's okay and this place is a great place after all.
    Nikon D80|Nikon 18-135 AF-S DX|Nikon 70-300 AF|Nikon 50 f/1.4 AFD|Nikon SB-800|Canon IXUS 70

  2. #22

    Default Re: ClubSNAP Forums Database damaged

    Edmund,

    You have done a great job already! I'm a IT Administrator. From the progression you have recover, you have done beyond that already!

  3. #23
    Member
    Join Date
    Dec 2006
    Location
    Punggol
    Posts
    93

    Default Re: ClubSNAP Forums Database damaged

    How come such a important forums without run a transaction log backup at least every hours so that such case wouldnt happen? or at least can recover until the last hour of failure?

  4. #24
    ClubSNAP Admin Darren's Avatar
    Join Date
    Jan 2002
    Location
    Melbourne
    Posts
    8,496
    Blog Entries
    2

    Post Re: ClubSNAP Forums Database damaged

    Quote Originally Posted by hiroko View Post
    How come such a important forums without run a transaction log backup at least every hours so that such case wouldnt happen? or at least can recover until the last hour of failure?
    That would require too much hardware - will require a slave server to replicate the database and then another storage device to perform the backups - Our database size now is in excess of 6GB thus an hourly backup is not feasible on our current hardware.

    Of course, if you are willing to sponsor such a setup, we can talk . Call me if you have anything useful to share.

  5. #25
    Member
    Join Date
    Dec 2006
    Location
    Punggol
    Posts
    93

    Default Re: ClubSNAP Forums Database damaged

    Quote Originally Posted by Darren View Post
    That would require too much hardware - will require a slave server to replicate the database and then another storage device to perform the backups - Our database size now is in excess of 6GB thus an hourly backup is not feasible on our current hardware.

    Of course, if you are willing to sponsor such a setup, we can talk . Call me if you have anything useful to share.
    Transaction log backup is not a replication method. thus no need slave server or additional storage device.

    Anyway i believe 6GB for a database is not really consider huge.

    Transaction log backup for an hourly schedule is really taking a small chunk of data. it depends on that hour's transaction.

    since you have a full backup run every midnite. thus transaction log backup data up to the hour before full backup still can recover more over after your full backup is done. you can just override it.

    just a suggestion only.

    No offence here.

  6. #26

    Default Re: ClubSNAP Forums Database damaged

    Many thanks for all that I have learnt from Clubsnap since I joined and the hours I have spent reading all the threads and forum messages.

    I have great admiration for all the work that you guys put in behind the scene and rewarded only by self-satisfaction for work well done.

    I know it is easy to say "keep up the good work", but I do not have the IT technical skill to contribute.

    However, please let me know if I can help somehow.

  7. #27

    Default Re: ClubSNAP Forums Database damaged

    Things happen, we understand. No worries.

    Thanks for getting things back up and running again... appreciate the work.

  8. #28
    Member
    Join Date
    May 2007
    Location
    Northern California
    Posts
    1,622

    Default Re: ClubSNAP Forums Database damaged

    I can definitely appreciate the hard work putting things back together after one too many restores of some rather large corporate systems.

    Thanks for doing the best to keep the forums running smoothly.

  9. #29

    Default Re: ClubSNAP Forums Database damaged

    Dear Edmund & Adminstrators,

    Thank You very much for the job well done.

  10. #30
    Senior Member Cheesecake's Avatar
    Join Date
    Aug 2003
    Location
    I live in a haunted house!!!!!
    Posts
    16,416

    Default Re: ClubSNAP Forums Database damaged

    Thanks for the hardwork!
    You'll Never Walk Alone! - i have the best job in the world!

  11. #31
    Senior Member
    Join Date
    Jul 2005
    Location
    sewage drain/manhole
    Posts
    5,011

    Default Re: ClubSNAP Forums Database damaged

    Thanks CS admins for the hardwork and OT.

  12. #32
    ClubSNAP Admin Edmund's Avatar
    Join Date
    Jan 2002
    Location
    Singapore
    Posts
    2,336

    Default Re: ClubSNAP Forums Database damaged

    Thanks for everyone's kind support and encouragements, much appreciated!

Page 2 of 2 FirstFirst 12

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •