Post reply

Who dropped my table ?

  • September 19, 2007 at 8:18 am

    #181098

    Hi,

    I want to find out how a particular table in a DB got dropped....all the info regarding that...SOS

    Also is there a way that I can restore the dropped table in SS2K5, as we've in Oracle 10G, the Flashback command?

    Thanks,

    Sayan

  • September 19, 2007 at 12:53 pm

    #734703

    Unless you had some sort of auditing running: Profiler, DDL triggers, etc., you won't be able to see who dropped the table without the help of a transaction log reader tool like those available from Lumigent, RedGate et al.

    The only way to restore the dropped table is to restore a backup.

    Greg

    Greg

  • September 20, 2007 at 6:56 pm

    #735101

    if you dowad a trial copy of Litespeed you can use object level recovery to get the table from your last full back up (it works with native backups as well).  I used to work for quest, when i left they where still giving trial users access to OLR.

     

     

  • September 21, 2007 at 12:24 am

    #735123

    if you are using SQL Server 2005 then then Report namely schema changes would help you to view the schema changes in your DB.

  • September 21, 2007 at 12:57 am

    #735127

    Abhijit is right.

    The SSMS report should show any schema changes, when and by whom. Another alternative is the default trace which is running with SQL 2005.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • September 21, 2007 at 1:03 am

    #735128

    can u expalin in detail

     

    Thanks

  • September 21, 2007 at 2:41 am

    #735149

    SSMS contains a couple of standard reports. Depending on which SP you have installed you can either find them at the top of the summary window (Pre-SP2) or by right-clicking on your server or database and then select reports. The report you should be looking for is called "Schema Changes History"

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • September 21, 2007 at 4:06 am

    #735162

    Markus,

    Please let us know where the shcema change report exist is SSMS.I have searched lot but it is not showing anywhere any reports.

  • September 21, 2007 at 5:26 am

    #735177

    As I wrote before it depends on the service pack version where you find them.

    For the RTM and SP1 do the following steps :

    1. Open Management Studio
    2. Highlight a server instance or database in Object Explorer
    3. Open the Summary Page (F7)
    4. Click on the Reports button

    http://www.fotia.co.uk/fotia/images/DY.10.SsmsReports.jpg

    If you're having SP2 in Object-Explorer right-click either on the server or the database in question. In the context menu you see Reports>Standard Reports>Schema change History.

    If you really can't find them, are you sure the server you're looking at is 2005 ???

    Markus

    [font="Verdana"]Markus Bohse[/font]

Viewing 9 posts - 1 through 8 (of 8 total)

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