Category
主题
副主题
Does ApexSQL Recover supports TDE encryption? (4378593)
Unfortunately, the use of TDE encryption is not supported by ApexSQL Recover. ... Reading the encrypted backup/data use case is not supported by the tool. ... To ensure proper functionality, please verify that there are no encrypted objects in the database or that no modifications will be made to such objects.
How to choose and perform the most appropriate recovery solution after the data loss (4368230)
Whenever an accidental or malicious data loss occurs, it is important to take the most efficient approach in order to perform the most appropriate recovery process and recover full range of lost data.
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
How to restore specific table(s) from a SQL Server database backup (4287890)
How to restore specific table(s) from a SQL Server database backup "<p> If restoration of an original database to a previous state is not an option, in the case of accidentally updated, dropped, deleted, damaged data, it is still possible to restore these tables if a database backup was created prior to the accident.
4 techniques for recovering lost tables due to DROP Table operation (4306782)
4 techniques for recovering lost tables due to DROP Table operation "<p> An accidentally dropped table may be recovered in several ways. ... The choice of technique depends on the resources available for the recovery.
SQL Server disaster recovery - How to quickly recover data lost due to an Inadvertent delete operation (4312061)
SQL Server disaster recovery - How to quickly recover data lost due to an Inadvertent delete operation "<p> It is not that uncommon to find yourself in a situation when some inadvertent delete operations have deleted important data from a SQL Server database.
How to recover objects that are missing as a result of a SQL injection attack (4287647)
How to recover objects that are missing as a result of a SQL injection attack "<p>All of a sudden, you realize that something’s wrong with your database objects. ... Some stored procedures are missing, functions are there but they don’t work as expected since their code seems to be altered, and some triggers are created and fired which enhances the chaos you’re in.
How to recover data that is missing or damaged as a result of a SQL injection attack (4287539)
How to recover data that is missing or damaged as a result of a SQL injection attack "<b>What is a SQL injection?</b> ... A SQL injection attack is an attack in which a code that attacks the database is inserted into a web site.
Multiple SQL Server data recovery options (4312504)
In the past two weeks we had some interesting Solution center articles describing Microsoft SQL Server topics – each described as the problem (or the challenge) users may encounter with SQL Server data recovery
How to recover deleted SQL data from transaction logs (4277067)
Besides these, there is one more resource you can use when it comes to SQL data recovery - a transaction log</p> ... <p></p><div class=""></div> <p>Every schema and data change in a SQL Server database is added into an online transaction log as a log record.
Recover deleted SQL data from a backup or from online database files (4320865)
Recover deleted SQL data from a backup or from online database files "<p>Recovering DELETED records is something we would all like to avoid, but no matter how careful we are, it can come to that.
The “You need to be a member of the sysadmin role to complete the installation” error is encountered when installing server-side components in ApexSQL Recover 2014” (4304623)
This article shows how to install ApexSQL Recover server-side components to a remote server. ... Symptoms ... When installing server-side components from a client machine, the following error occurs: “You need to be a member of the sysadmin role to complete the installation.
ApexSQL Recover doesn’t recover all lost data (4211453)
This article describes why in some cases ApexSQL Recover cannot recover all lost data. ... ApexSQL Recover doesn’t recover all lost records. ... Cause: Post incident activities have overwritten data necessary for recovery
When to use ApexSQL Recover (4214815)
ApexSQL Recover is a SQL Server data recovery tool which recovers deleted and truncated data. ... It recovers objects and data lost due to drop operations, and recovers BLOBs as files. ... ApexSQL Recover can also be used to investigate transaction log files for DML and DDL changes as well as to rollback or replay any changes found in transaction log files and backups.
The old ApexSQL Recover version isn't removed after the update (4214915)
This article explains what to do when ApexSQL Recover is updated, but the old ApexSQL Recover version isn’t removed. ... After updating ApexSQL Recover using the Get updates option in the Resources tab or from the Auto-update dialog, ApexSQL Recover is updated to the version 2014.
Recover table data from a database backup – ApexSQL Recover (4214813)
This article explains how to use the Recover table data from a database backup option in ApexSQL Recover that allows you to recover multiple tables stored in a SQL database backup, without restoring the backup itself
Recovery possibilities when a database is in simple recovery mode (4216103)
Summary This article explains how to use ApexSQL Recover to retrieve data from an MDF file and offers advice on how to increase the amount of recovered data. ... Description When an incident occurs, it is important to take all precautions in order to protect the data and to increase chances of successful recovery.
Recover lost data due to a TRUNCATE operation – ApexSQL Recover (4213510)
This article explains how to use the "From TRUNCATE" operation option in ApexSQL Recover, in order to recover data lost due to a malicious or accidental TRUNCATE statement. ... Description ... In order to maximize chances for recovery, the time period between the incident and the recovery attempt needs to be minimized.
Recover lost data due to a DROP TABLE operation – ApexSQL Recover (4214811)
This article explains how to use the 'From DROP TABLE' operation option in ApexSQL Recover, in order to recover data lost due to a malicious or accidental DROP TABLE operation. ... In case of lost data due to a DROP TABLE operation scenario:
How to use ApexSQL Recover after data loss? (4213484)
Summary What to do immediately after data loss in order to minimize the chance of the data being overwritten or lost beyond recovery, and therefore maximize recovery success rate. ... Description
Why doesn’t ApexSQL Recover recover indexes and primary keys during lost data recovery (4213515)
Summary When recovering lost data into a new database, ApexSQL Recover does not generate the primary key and indexes on the created tables. ... The same applies to the tables created when recovering data from a drop table operation.
Installing server-side components (4213509)
This article shows how to install ApexSQL Recover server-side components to a remote server. ... Symptoms ... When installing server-side components from a client machine, the following error occurs: “You need to be a member of the sysadmin role to complete the installation.
How to optimize data recovery results in SQL Server using ApexSQL Recover (4214842)
Summary This article describes actions that improve chances for successful recovery of lost SQL Server data using ApexSQL Recover. ... Post-incident activities To maximize the chance of recovery success, it is highly recommended to do the following immediately after the incident:
What information do I need to send to get help with a SQL recovery? (4213608)
The following information can facilitate a successful support/recovery outcome: ... Brief description on what you are trying to recover from. ... Do you have a full database backup available? ... Has the online transaction log file been truncated after/before the disaster has occurred?
ApexSQL Recover evaluation guide for first time users (4212910)
Summary ... This article envelops all of the most important topics and knowledge about ApexSQL Recover and provides brief descriptions and links to core ApexSQL Recover articles that cover them. ... Description
新产品关联性