none
refreshing database before restart

    Question

  •  

    i am running a game from a dedi box .. ms sql..

    and every time i restart and put it back up ,,,,it rewinds the database

    the only way i can prevent this is if i restart the server

    wait a phew hours then put it back up ,,"which makes it the same way it was when i logged off"

    i was told that sql database servers refresh every hour.

    is there a way i can make it refresh before i restart it so then i can put the server straight back up

    \

    \

    \

    if i restart the server back up straight away it does a rewind for some reason.

    \

    \

    tech ::

     the server does a rewind because it wouldn't have saved the game so to speak - as in updated everyone's characters. So yes waiting is the only way as far as I know to save the game.

    Friday, June 08, 2007 6:45 AM

Answers

  • This must be wrapped up in the game's logic where it keeps one database transaction open for a long time (like an hour).

    Proper database behavior is that if an update transaction is never committed by the application, the updates are rolled back (rewound) if for any reason the connection is broken.

     

    There is NOTHING in SQL that limits updates to that kind of frequency.

    Unfortunately, you need to talk to whoever made/runs the game.  They can chat with us and we'll help them.

    Tuesday, June 12, 2007 5:48 PM
    Moderator

All replies

  • This must be wrapped up in the game's logic where it keeps one database transaction open for a long time (like an hour).

    Proper database behavior is that if an update transaction is never committed by the application, the updates are rolled back (rewound) if for any reason the connection is broken.

     

    There is NOTHING in SQL that limits updates to that kind of frequency.

    Unfortunately, you need to talk to whoever made/runs the game.  They can chat with us and we'll help them.

    Tuesday, June 12, 2007 5:48 PM
    Moderator
  • ok thanks for ypur help anyway
    Tuesday, June 12, 2007 11:23 PM