locked
recovery RRS feed

  • Question

  • Hi all,

    how to recover data in ms sql server ..?

    Tuesday, May 28, 2013 10:49 AM

Answers

  • What made you to recover data?

    The best way is to restore the recent valid backup.


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, May 28, 2013 10:59 AM
  • Hi SLNSH,

    What situation are you dealing with? Please tell more information here for analysis. There are some proposes, you can refer to them.

    1. If some errors and disasters could take your database offline, we will need to take backup and recovery plan to bring the database into a consistent state. 
    Backup (T-SQL): http://msdn.microsoft.com/en-us/library/ms186865.aspx
    Restore (T-SQL): http://msdn.microsoft.com/en-us/library/ms186858.aspx
    2. There are a number of ways to deal with recovering deleted data in SQL Server.
    1). Rollback the transaction; 2) Restore the last good backup under a new name, and use it to copy the affected rows back into your database; 3)Use a log explorer to generate undo scripts and so on.

    There is more details on the following link, you can also refer to the solution
    there: http://thehobt.blogspot.com/2008/12/recovering-deleted-data-in-sql-server.html

    Wednesday, May 29, 2013 4:56 AM

All replies

  • What made you to recover data?

    The best way is to restore the recent valid backup.


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Tuesday, May 28, 2013 10:59 AM
  • What situation are you dealing with?

    Corruption?

    Missing data?

    The best approach is restoring from the last known good backup

    Regards

    Tuesday, May 28, 2013 11:36 AM
  • when the data is deleted from a table, check my blog for action plan

    http://sqlservr.blog.com/2012/01/20/how-it-happen-so/

    to recover my a corruted database

    run the command in the management studio

    1select DATABASEPROPERTYEX('dbname','status')

    2check you disk availability

    3 check the database status ot try to reset it

    4 DBCC CHECKDB('dbname')


    Ramesh Babu Vavilla MCTS,MSBI

    Tuesday, May 28, 2013 11:45 AM
  • Hi SLNSH,

    What situation are you dealing with? Please tell more information here for analysis. There are some proposes, you can refer to them.

    1. If some errors and disasters could take your database offline, we will need to take backup and recovery plan to bring the database into a consistent state. 
    Backup (T-SQL): http://msdn.microsoft.com/en-us/library/ms186865.aspx
    Restore (T-SQL): http://msdn.microsoft.com/en-us/library/ms186858.aspx
    2. There are a number of ways to deal with recovering deleted data in SQL Server.
    1). Rollback the transaction; 2) Restore the last good backup under a new name, and use it to copy the affected rows back into your database; 3)Use a log explorer to generate undo scripts and so on.

    There is more details on the following link, you can also refer to the solution
    there: http://thehobt.blogspot.com/2008/12/recovering-deleted-data-in-sql-server.html

    Wednesday, May 29, 2013 4:56 AM