Post reply

Recover database value

  • June 3, 2015 at 4:34 am

    #317893

    Hello sir, good afternoon i need your help regarding SQL server, by-mistaken i updated values of a column in a database hosted online, is there any way undo the transaction. I didn't created any backup of the database. I read that still it can be recoverd through the .ldf (log file) but unable to access it. Is there anyway to get access of the Log file or is there any way to recover the data. Please help me sir.

  • June 3, 2015 at 4:57 am

    #1802542

    No backup = no restore.

    -- Gianluca Sartori

  • June 3, 2015 at 5:07 am

    #1802549

    Confirming what Gianluca said, no backup = no restore.

    contact your web host directly and immediately, though.

    if you are lucky, your host might be doing backups automatically on your behalf. if they are, then you might have a chance to get a previous snapshot.

    my web host does a once a month backup outside of what i can do, and my db is in simple mode,so i cannot do point in time restores, but it's just a dev server from my point of view; all my pages are behind a login wall, anyway, nothing externally facing.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 4, 2015 at 4:48 am

    #1802935

    Thanks sir

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply