read sql log file

First of allUse [database name];exec sp_helpfile; Use the sp_helpfile query to know the logical name of the log file, and then you can use DBCC to reduce the log fileBACKUP LOG [database name] WITH TRUNCATE_ONLYDBCC SHRINKFILE (logical name of log

Label:The company has to standardize the size of the personnel library every month.The following is a SQL Server with the size of the SQL repository:SELECT db_name(database_id) as [Database Name], [Name] as [Logical Name], ((Size* 8)/ 1024x768) as [Size (MB)],--the original unit of size is bit, so multiply 8 to byte and multiply by 1024 to MByte. [Differential_base_time] as [differential Base ti

always closed), normal after the big file can be deleted.Of course, the best way is to plan in advance, set up, add a job schedule, so that will automatically back up, shrinkage and the like, control in a certain size range.After learning, the other simple processing methods:1: Empty the LogDUMP TRANSACTION Library name with NO_LOG2: Shrink LogEnterprise Manager--Right click on the database you want to shrink--all tasks--shrink the database--Shrink t

Original: SQL Server bulk log file processingOptimized processing for SqlServer2000, SqlServer2005, SqlServer2008, SqlServer2012, and SqlServer2014 library log files, reducing disk space.Processing method:The following columns are SqlServer2012:　　Recovery mode: Complete-Simple, then click OK　　Right-click the database,

When you restore a database from a database backup, you find that the log file actually has more than 120 g, not through the SQL management, resolute use DBCC statement cleanup success! Free space! and clear and speed! First of all, it's important to look at the type of backup data, or not to clean up Select Name, Recovery_model_desc from sys.databases After e

-:Wuyi: -[dubboserverhandler-thread-1] TRACE Org.hibernate.type.descriptor.sql.BasicExtractor ( the)-Found [1] ascolumn [parmvalue65_0_] .- the- to -:Wuyi: -[dubboserverhandler-thread-1] TRACE Org.hibernate.type.descriptor.sql.BasicExtractor ( the)-Found [NULL] ascolumn [parmdesc65_0_] .- the- to -:Wuyi: -[dubboserverhandler-thread-1] TRACE Org.hibernate.type.descriptor.sql.BasicExtractor ( the)-Found [0] ascolumn [modifiable65_0_] .- the- to -:Wuyi: -[dubboserverhandler-thread-1] TRACE Org

A valid method is to execute the following script: (Bigdata is the database name) use database name; go alter database database name set RECOVERY Simple; -- Set the simple recovery model go DBCC Shrinkfile (database name _log, 1 go alter database database name set RECOVERY full ; -- revert to original mode go Back up the database first before executing. Reference: http://www.cnblogs.com/downmoon/archive/2009/12/13/1623004.html[Go] How to clear the large

DECLARE W_file_path VARCHAR2 (4000): = ' xxif_input '; --all_directories.directory_name w_file_name VARCHAR2 (4000): = ' lcytest001.csv '; --the file name W_file_exists BOOLEAN; W_file_length Number (Ten) DEFAULT 0; W_file_type Utl_file.file_type; W_line VARCHAR2 (4000) DEFAULT NULL; W_rec_count number: = 1; W_block_size Binary_integer; --TYPE Tbl_varchar2 is TABLE of VARCHAR2 (4000) INDEX by Binary_integer; Rec_record tbl_varchar2;

DECLARE W_file_path VARCHAR2 (4000): = ' xxif_input '; --all_directories.directory_name w_file_name VARCHAR2 (4000): = ' lcytest001.csv '; --the file name W_file_exists BOOLEAN; W_file_length Number (Ten) DEFAULT 0; W_file_type Utl_file.file_type; W_line VARCHAR2 (4000) DEFAULT NULL; W_rec_count number: = 1; W_block_size Binary_integer; --TYPE Tbl_varchar2 is TABLE of VARCHAR2 (4000) INDEX by Binary_integer; Rec_record tbl_varchar2;

With the Lognet component, you can view the site log later without having to go to the server to downloadLog component: LogNet.DLL, reference can be usedWrite Method:1, LogNet.Log.WriteLog (" log title " " log content ");2, LogNet.Log.WriteLog (" log title ",new Exception ());Log