SQL disaster recovery article index

Applies to:
ApexSQL Log, ApexSQL Recover

Summary:
This article provides key information and links to all important recovery-related articles. They are categorized by

• [Both] – includes articles for both ApexSQL Log and ApexSQL Recover

• [ApexSQL Log] – only ApexSQL Log articles

• [ApexSQL Recover] – only ApexSQL Recover articles

Before the recovery:

• Both

  • Critical steps users should perform immediately after they think a disaster has occurred This article describes the critical steps that should be performed as soon as possible after the disaster occurs in order to ensure that the information for the recovery is kept safe from any overwriting processes and available once the recovery process is put to motion and to ensure maximal recovery success rate.

  • What information do I need to send to get help with a SQL recovery? If you’ve already checked some of the information or guides on our web site, but still require help with your recovery, this article offers recommendations on what information to send to ApexSQL support agents to get a quick and helpful advice on the recovery as quickly as possible.

• ApexSQL Recover

  • Recovery possibilities when a database is in simple recovery mode – In order to ensure all lost data/structure is recovered, database must be in a full recovery model to ensure all information required by the recovery process is available. If a database is in the simple recovery process, recovery will most likely be limited – this article offers information on what can be done in case that database was not in the full recovery model when the disaster occurred.

How to decide on the best recovery solution:

• Both

  • Recovery flow chart – This article guides user through a series of yes/no questions on available resources (backups, logs…) in order to help decide on which tool and approach to use for the particular recovery process based on the answers.

  • How to choose and perform the most appropriate recovery solution after the data loss – In some recovery cases, multiple tools that utilize different mechanisms can be used to perform the recovery job. This article helps users decide on which tool would be the most suitable one for their particular recovery.

  • Recovery features comparison: ApexSQL Log vs. ApexSQL Recover – For those that want a direct comparison of all recovery features of ApexSQL Log and ApexSQL Recover, this article provides a head to head information.

Recover from SQL operations (drop, delete, update, truncate):

• Both

  • How to recover SQL Server data from accidental UPDATE and DELETE operations – A step-by-step guide on delete/update recovery with ApexSQL Log.

  • How to recover views, stored procedures, functions, and triggers – Follow this guide when recovering dropped SQL Server object to maximize the recovery success rate.

• ApexSQL Recover

  • Recover SQL database data lost due to a DELETE operation – A step-by-step guide on recovering from rogue delete operations with ApexSQL Recover.

  • Recover lost data due to a TRUNCATE operation – When table is truncated, ApexSQL Recover is the sole ApexSQL solution for the recovery, and this article shows how to successful recover the lost data.

  • Recover lost data due to a DROP TABLE operation – Follow this article when recovering table and/or structure lost due to drop operation.

Guides for specific recovery cases

• Both

  • How to recover data that is missing or damaged as a result of a SQL injection attack – A quick step-by-step guide on how to completely recover from a SQL injection attack.

  • Recover a SQL Server database using an old backup and the current transaction log file – Learn how to recover your SQL Server database by using only an old database backup and the online transaction log file.

  • Reverting your SQL Server database back to a specific point in time – When a database needs to be rolled back to a specific point in time, ApexSQL Log can be used to undo all changes for specific time period, and this article provides a detailed guide.

• ApexSQL Recover

  • How to recover a single table from a SQL Server database backup – Restoring a database backup for the purpose of extracting only single or just few tables can be costly process – both timely and performance-wise. With ApexSQL Recover, users can extract only specific tables without restoring the actual backup, by following instructions in this article.