But what does "last resort" mean? What happens when you use this command? Which command should you use to replace it? Finally, if the order is so problematic, why does Sybase have to provide it?
Sybase Technical Support recommends that you periodically dump your transaction log. You have to determine how the dump is based on the amount of activity in your database and the size of your database. In some places the monthly dump transaction, in some places every night dump transaction.
Note: If you are running SQL Server10.0, you can use Sp_thresholdaction to automatically dump Tran before space is scarce, and backup server will ensure that the task is not suspended while the dump is in progress. Please get more detailed information in your SQL Server reference manual. The remainder of this article will apply to the realm of running system 10 prior to SQL Server.
If you never dump TRANSACTION, TransactionLog will eventually be full. SQL Server uses log (log) for recovery purposes. When the log is full, the server stops things from continuing, because the server will not be able to write these things into the log, and the server cannot run most of the dump TRAN commands, because SQL Server also needs to log these commands in the logs.
This is why NO_LOG can be executed when other dump TRAN commands do not execute. But think about the environment in which the dump transaction with NO_LOG is designed to execute. All pairs do not do concurrency checks.
If you use the DUMP TRANSACTION with NO_LOG when you change the database, you risk the entire database crash. In most cases, they are reflected as 813 or 605 errors. In order to delete inactive parts of the transaction log when the database is modified, you can use the DUMP transaction with Trancate_only. This command is written in transaction log, and it does not have a concurrency check. These two commands have warnings associated with them and are seen in the command reference manual. Make sure that you understand these warnings and instructions before using either of these commands. Syase provides a dump transaction with NO_LOG to handle some of the most pressing situations. To try to make sure your database is consistent, you should use it as a "last resort".
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
