Professional Web Applications Themes

retrieve deleted records for a specici userid - Microsoft SQL / MS SQL Server

Hi Freinds, I have a database used by 40 users in a NT domain. I doing Data backup evey day at 18:00 and doing log backup every hour Here is the situation : One of the users <mydomain\username> deleted some records about 20 min ago and I have to retrieve those back. How can I do that???? the next log backup is not started yet ! Thanks in advance, Pat...

  1. #1

    Default retrieve deleted records for a specici userid

    Hi Freinds,
    I have a database used by 40 users in a NT domain. I doing Data backup evey
    day at 18:00 and doing log backup every hour
    Here is the situation :
    One of the users <mydomain\username> deleted some records about 20 min ago
    and I have to retrieve those back.
    How can I do that???? the next log backup is not started yet !

    Thanks in advance,
    Pat



    Patrick Guest

  2. #2

    Default Re: retrieve deleted records for a specici userid

    Lumigent's Log Explorer can generate the INSERT statements to replace the data:

    www.lumigent.com

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Patrick" <all-in-1.com> wrote in message news:#ZsS#phx.gbl...
    Hi Freinds,
    I have a database used by 40 users in a NT domain. I doing Data backup evey
    day at 18:00 and doing log backup every hour
    Here is the situation :
    One of the users <mydomain\username> deleted some records about 20 min ago
    and I have to retrieve those back.
    How can I do that???? the next log backup is not started yet !

    Thanks in advance,
    Pat




    Tom Guest

  3. #3

    Default Re: retrieve deleted records for a specici userid

    is this a 3-rd party applicant?
    what about SQL log?

    "Tom Moreau" <spam.me.cips.ca> wrote in message news:#$phx.gbl...
    Lumigent's Log Explorer can generate the INSERT statements to replace the data:

    www.lumigent.com

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Patrick" <all-in-1.com> wrote in message news:#ZsS#phx.gbl...
    Hi Freinds,
    I have a database used by 40 users in a NT domain. I doing Data backup evey
    day at 18:00 and doing log backup every hour
    Here is the situation :
    One of the users <mydomain\username> deleted some records about 20 min ago
    and I have to retrieve those back.
    How can I do that???? the next log backup is not started yet !

    Thanks in advance,
    Pat




    Patrick Guest

  4. #4

    Default Re: retrieve deleted records for a specici userid

    It is a 3rd party tool. There are no public MS tools to read the log.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Patrick" <all-in-1.com> wrote in message news:phx.gbl...
    is this a 3-rd party applicant?
    what about SQL log?

    "Tom Moreau" <spam.me.cips.ca> wrote in message news:#$phx.gbl...
    Lumigent's Log Explorer can generate the INSERT statements to replace the data:

    www.lumigent.com

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Patrick" <all-in-1.com> wrote in message news:#ZsS#phx.gbl...
    Hi Freinds,
    I have a database used by 40 users in a NT domain. I doing Data backup evey
    day at 18:00 and doing log backup every hour
    Here is the situation :
    One of the users <mydomain\username> deleted some records about 20 min ago
    and I have to retrieve those back.
    How can I do that???? the next log backup is not started yet !

    Thanks in advance,
    Pat




    Tom Guest

Similar Threads

  1. Retrieve records by date?
    By btn in forum Dreamweaver AppDev
    Replies: 3
    Last Post: July 6th, 03:24 PM
  2. Retrieve n records from database
    By Sean Berry in forum Macromedia Flash
    Replies: 1
    Last Post: January 18th, 03:11 AM
  3. How to retrieve the records if I have .SQL script file using ADO.net
    By Kiran in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: October 14th, 08:38 PM
  4. Need to retrieve records
    By MLangner-MMTS in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 12th, 11:14 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139