Post reply

point in time recovery

  • July 19, 2010 at 1:56 pm

    #235509

    hi guys i am new in this forum i need your help

    my db is full recovery mode

    recently i take a full backup but don't have any log backup

    after half an hour one table is drop

    so i can only recover db till last full backup or

    there is any option to recover the only drop table without affecting other tables cos lot of changes in other tables?

    and

    there is any option or sys object to know the time when the object is droped?

    i take current log file backup but don't know the exect time when the table is droped?

    thanks

  • July 19, 2010 at 4:02 pm

    #1195185

    You can check the default trace for the information. If not too much time has passed, it should have the time in it.

    http://www.sqlservercentral.com/articles/64547/

    Otherwise, take the log backup, try restoring to different times to find when the drop occurred.

  • July 19, 2010 at 9:12 pm

    #1195264

    there is any option to recover the only drop table without affecting other tables cos lot of changes in other tables?

    Find out the time the table was dropped as per the suggestions by Steve.

    Take a transaction log backup.

    Restore the full and transaction log to another database, to the point in time before the table was dropped.

    Copy the contents of the dropped table to your current database, perhaps using the SELECT ... INTO construct.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • July 20, 2010 at 6:57 am

    #1195476

    joshanil (7/19/2010)

    hi guys i am new in this forum i need your help

    my db is full recovery mode

    recently i take a full backup but don't have any log backup

    after half an hour one table is drop

    so i can only recover db till last full backup or

    there is any option to recover the only drop table without affecting other tables cos lot of changes in other tables?

    and

    there is any option or sys object to know the time when the object is droped?

    i take current log file backup but don't know the exect time when the table is droped?

    thanks

    You can restore most recent backup ( before dropping table ) at any other location. then may be using EXPORT method , you can migrate that table to desired database.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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