sql server clear transaction log

File command_string cannot contain more than one pair of double quotation marks, which is incorrect, it seems that the SQL Server help file and the product have also encountered the problem of "the specification and the program do not match ......　　2. Clear Database Log FilesThe problem arises: Our Cutting Process is

Zheng Zuo 2006-6-26 During the BizTalk project, BizTalk Server and SQL The server is not on the same computer, and the SQL adapter is used to send data prompting the error "new transactions cannot be registered to the specified transaction processor". The same problem occurs

Transaction and concurrency Before learning things and concurrency, we should first understand two concepts: 1. What are things? Transactions are the basic unit of work in SQL Server. It usually consists of several SQL commands for reading and updating databases, but these operations are not considered final until a co

Label:Begin transaction--Start TransactionDECLARE @errorSun INT--Define error countersSET @errorSun = 0--yes, 0.UPDATE dbo. Test SET testname= ' 232 'WHERE testid=1--transaction operation SQL statementSET @[email Protected][email protected] @ERROR--whether the accumulation is wrong--waitfor delay ' 0:2:0 '--Delay 2 minutesUPDATE dbo. Testcustorm SET testnickname1

) B. do not enable too long transactions in tempdb (logs cannot be truncated, resulting in excessive logs. If the rollback fails, the server goes down) C generally, the process of intermediate table matching is created in tempdb (fast creation speed depends on the actual situation .) D The speed of using heap tables in tempdb is good (depending on the actual situation) How to clear

is generallyusing (DataTable dt = new DataTable ()){}This implicitly calls the Dispose () method at the end of the curly brace, and DT becomes a local variable immediately out of scope, and there is no call error===============================================================How to take the initiative to recycle the =null?===============================================================Gc. Collect ();All objects are considered recycled regardless of how long the object is in memory, but objects re

Over time, you will find that the log files for the database will be up to 20G or more, and you will need the following methods.--first change the recovery model of the database to SimpleALTER DATABASE [Database] SETRECOVERY Simple;GO--to reduce the log file to 1M, the logical name can be obtained by sp_helpfileDBCCShrinkfile ([Database log name],1); GO--Resettin

The sql2008 shrink log is as follows: The code is as follows Copy Code BACKUP LOG dbname to disk= ' Dbname.log 'DBCC shrinkfile (' Dbname_log ', 1) But remember to perform two times before you can finally perform the contraction; Shrink database files (if not compressed, database files do not reduce Enterprise Manager--right--the database you want to compress--all tas

. there is a SQL Server Agent service in SQL Server that has a " job function ", much like a timer trigger , using a " job " to execute a specific T-SQL statement or process at a specific time is an efficient and effective method . 2. Generate forecast Control Table

Msdn provides a good explanation of transaction and error handling. If you have any questions, you can check that. Here we will extract some important words. "If an error prevents the successful completion of a transaction, SQL Server automatically rolls back the transaction