read sql log file

The transaction log (Transaction logs) is a very important but often overlooked part of the database structure. Because it is not as active as the schema in the database, few people are concerned about the transaction log. The transaction log is a record of changes to a database that can record any action against the database and save the record results in a sep

Label:Today made a very annoying thing, accidentally put a 40 more g of the database log files deleted, and before the deletion I made a log in, dead or alive can not attach to the server has been prompted multiple logs cannot be automatically created, wasted a night of my time, and then constantly Google, Finally in a foreigner's blog found a few statements, directly, thank him on the way to record.

number of MB allowed to be shrunk is displayed. Enter this number directly and click OK. You can also use SQL statements. (Note: the LDF file size does not change after you use the Enterprise Manager to perform the shrink operation. Use the following SQL command) -- Shrink DatabaseDBCC shrinkdatabase (database name) -- Contract the specified data

Label: USE [master] GO -- Method 1: I use this method EXECsp_attach_single_file_db @dbname=‘TestDb‘, @physname=N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘ GO -- Method 2: CREATEDATABASETestDbON (FILENAME = N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘) FORATTACH_REBUILD_LOG GO Statement 1 is to attach

can also use SQL statements to complete-- Shrink DatabaseDBCC shrinkdatabase (customer profile) -- Contract the specified data file. 1 is the file number. You can use this statement to query: Select * From sysfilesDBCC shrinkfile (1) 4. To minimize log files (for SQL 7.

Tags: run right-click Database PNG default transaction file log file LLBObjectiveNext we end up with the last few sections of the SQL Server Basic series, and then we'll talk about SQL Server performance tuning, and we'll get to the topic.SQL Server transactions affect local

Tags: des style c Class Blog codeOriginal: What is the size of the SQL Server log file's write operation to the disk?The SQL Server database has three file types, data files, secondary data files, and log files, where the log file

The SQL Server database has three file types, data files, secondary data files, and log files, where the log files contain all the log information used to recover the database, SQL Server always writes the

"Problem scene" has a database, its name is called Cnblogstext, the log file occupies 23G hard disk space, and the transaction log has been truncated (Truncate), the actual log content is very small, 1G are not. 23G of space only put 1G log, like a villa with a pet, too extr

Original: SQL Server log file large shrinkage method (measured and useful)These two commands are executed consecutively, with less time and more apparent (multiple runs) until the effect is reached-- truncate BACKUP LOG to DISK = ' NUL ' -- Shrinkage DBCC Shrinkfile ('cloudmonitor_log')You can use regular regular back

Tags: sql server2008Today because SQL Server's log file grows so large that the detached database deletes the log file after it is automatically produced when the database is attached to the l