Catégorie
Rubrique
Sous-rubrique
La langue
Retourner votre base de données SQL Server à un point précis dans le temps (4307326)
Il y a certaines circonstances dans lesquelles vous pouvez avoir besoin de restaurer votre base de données à un point précis dans le temps (point in time recovery). ... Ces raisons sont généralement liées à l'exécution d’instructions DML ou DDL accidentelles.
Comment récupérer des données SQL Server suite à des mises à jour accidentelles lorsque vous ne disposez pas de sauvegardes (4300028)
Oups! Dites-vous lorsque vous avez exécuté une requête UPDATE sans condition WHERE sur une base de données et écrasé un tas de lignes avec des données incorrectes. ... Comment pouvez-vous ramener les bonnes valeurs?
4 techniques pour la récupération des tables perdues en raison de l'opération de DROP Table (4216013)
4 techniques pour la récupération des tables perdues en raison de l'opération de DROP Table <p>Une table accidentellement supprimée peut être recupérée de plusieurs façons. ... Le choix de la technique dépend des ressources disponibles pour la récupération.
Comment récupérer des données SQL Server après un UPDATE / DELETE accidentel (4214724)
Comment récupérer des données SQL Server après un UPDATE / DELETE accidentel Le pire cauchemar d’un DBA SQL est la perte de données en raison d’une erreur de leur part. ... Il n'est pas rare d'exécuter ou d’oublier une clause WHERE lors de l'exécution d’un DELETE ou d’un UPDATE, ce qui compromet potentiellement des millions de lignes de données.
Does ApexSQL Log supports TDE encryption? (4378592)
Unfortunately, the use of TDE encryption is not supported by ApexSQL Log. ... 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.
Does the latest version of the ApexSQL Log supports SQL Server 2022? (4378311)
Does the latest version of the ApexSQL Log supports SQL Server 2022? ... WORKAROUND
How to see transactions in the ApexSQL Log that occurred few hours ago? (4377125)
How to see transactions in the ApexSQL Log that occurred few hours ago?
"ERROR : CreateFile() failed (4) for "C:\Backup\******.bak: The system cannot find the path specified" error encountered in the application log files when filtering log results (4377123)
"ERROR : CreateFile() failed (4) for "C:\Backup\******.bak: The system cannot find the path specified" error encountered in the application log files when filtering log results To fix this issue, check whether the automatic backup verification is unchecked.<br><br>To check this, perform the following:<br>Start ApexSQL Log and had over to Options->General->UNCHECK: “The session wizard auto-loads SQL logs to analyze”
"WARN : Found UNKNOWN backup block: 0 at: **********" message is encountered within the application log files when investigating data source (4377124)
" message is encountered within the application log files when investigating source data In these type of situations, ApexSQL Log is unsuccessfully trying to read an unknown backup block, ie the one that cannot be labeled to other database backup or transaction log backups you're reading at present moment.<br>This process of trying to find out the source of the data is causing tool to slow down, hang or even unexpectedly crash.<br><br>The solution here would be to, when reading trn files,
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.
ApexSQL Log with encrypted backups files (4370326)
While using ApexSQL Log to try to recover operations from a backup file that was created with any level of encryption, the application times out and show no results in any way the application offer (Grid, database, file) <br><br>Log file shows operations like: <br><br>WARN : Skipped operations at 844D0705:E29AD42D:91B6 since they don't belong to D0735EEF:00000004:9398 ApexSQL Log does not support reading and recovering operations from encrypted backup file.
Hands free, no-coding SQL Server database replication of a reporting database (4295803)
Hands free, no-coding SQL Server database replication of a reporting database "<p> ApexSQL Log is an amazing tool for reading the transaction log and reading the transaction log can form the basis of a lot of great features, functionality.
How to implement compliance with the PCI DSS regulatory standard for SQL Server - Part 4 (4277159)
Logs and security events for all system components, must be reviewed to identify anomalies or suspicious activity ... The plan and procedures must be capable of responding immediately to a system breach in order to ensure the process of business continuity and recovery, data backup processes, analysis of the all critical SQL Server components
Checklist for suspicious activity on SQL Server (4282447)
It seems something went awry with the SQL Server. ... It’s sluggish, behaves erratically, produces heavy network traffic, there is a significant increase in the server processor or memory utilization, and to top it all there are reports of or database objects and data being damaged or missing.
SQL Server true detective - Solving the case of the broken database (4282414)
In this series of articles, we’ll present various solutions for solving this “crime” by detecting the DDL change that broke a SQL Server database and even fixing the broken SQL Server database. ... The goal is to detect a bad change as quickly as possible (since there will be a lot of other changes) and to find a way to fix it.
Automating daily transaction log reading (4314095)
One of the common questions our customers have about auditing is – how to automate transaction log reading and have all the information you might need at hand. ... Another common request is – how to save the transactions I see in the ApexSQL Log grid, so I can easily filter, group, order and query them without running the whole ApexSQL Log reading process again?
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
SQL Server database auditing techniques (4261616)
SQL Server database auditing is not used only to address auditing requirements for compliance. ... It has become necessary for the analysis of database actions, troubleshooting problems, investigating the suspicious and malicious activity.
Continuous auditing of SQL Server database using the transaction log (4287874)
Continuous auditing of SQL Server database using the transaction log "<h2>Challenge</h2> <p> Imagine if you could decrypt and pump all the wealth of transactional information and details contained in the SQL Server transaction log, in human readable format, and then store this as data directly in SQL Server tables, ensuring it wasn’t lost when the log was truncated, and such that data could be queried, reported on etc. using T-SQL.
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.
Continuous SQL Server database auditing and reporting using the transaction log (4287743)
Continuous SQL Server database auditing and reporting using the transaction log "<p> SQL Server database transaction log files are continuously pumped with the transactional information and details on database changes by the SQL Server itself.
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.
Load testing: Recording production transactions and replaying on a test server (4270430)
Load testing: Recording production transactions and replaying on a test server "<p> Load testing not always the same as stress testing. ... Stress testing seeks to maximize the load on a server to see when and where it breaks.
Synchronizing databases using the transaction log - SQL Server Log shipping (4322560)
Synchronizing databases using the transaction log - SQL Server Log shipping "<p> No matter how well managed your systems are, accidents may still occur, and potentially lead to disastrous consequences.
Nouvelle association de produits
- Outils libre-service
- Base de connaissances
- Notifications et alertes
- Support produits
- Téléchargements de logiciels
- Documentation technique
- Forums utilisateurs
- Didacticiels vidéo
- Flux RSS
- Nous contacter
- Support Technique
- Afficher tout