sql server login auditing log

Recently, it was found that the log files of a system SQL Server database are large and need to be cleaned up. I thought it was a very simple task. SQLServerManagementStudio has a ready-made menu function. Just click twice. However, it does not work in actual operations. Because data is involved and Misoperation causes irreparable losses Recently, it was found th

Transaction Log (Transaction logs) isDatabaseStructure that is very important but often ignored. Since it is not as active as the schema in the database, few people are concerned about transaction logs.Transaction logs are records of database changes. They can record any operations on the database and save the record results in an independent file. Transaction logs are fully recorded for every transaction process. Based on these records, data files ca

This error occurs when you connect to SQL Server in Windows Server 2003 using a trusted connection (that is, when the value of integrated security is set to true,In Windows XP, the ASP. NET running account is ASPnet, while in Windows Server 2003, the running account is changed to network service. Solution:Step 1: Add

SQL Server divides transaction Log files into multiple VLFVirtual Log files), that is, virtual Log files. 650) this. width = 650; "border =" 0 "src =" http://www.bkjia.com/uploads/allimg/131228/230034D28-0.png "alt =" 112954536.png"/> 1. Four statuses of VLF 1,Active. Indic

log on the production database unless you have sufficient reason and sufficient certainty, or ... It's not you who take responsibility. Now that this method is unsafe, I'll introduce a secure approach. As you know, SQL Server automatically truncates the inactive portions of the transaction log when it completes a tra

The transaction log, or 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

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

You can narrow the SQL server log file to the desired size. COPY the code to the query analyzer and modify the three parameters (Database Name, log file name, and target log file size ), run the command (I have used it many times) How to reduce the size of the

An attractive service for RDS is to provide users with a slow log health report. Reports provide TOP20 SQL for users from different dimensions (total execution time, total execution times, total logical reads, total physical reads). RDS hopes to provide users with stable, fast service, while users can get more personalized optimization recommendations from RDS.This information is important, and users can ta

SQL Server 2005, compared to SQL Server 2000来, says that there is a considerable improvement in performance and functionality, even the "revolution" to describe the upgrade. SQL Server 2005 makes

In the use of the process, we often encounter a very large database log, here are two ways to deal with ... Method One In general, the contraction of the SQL database does not greatly reduce the size of the database, its primary role is to shrink the log size, you should do this periodically to avoid the database log

Problem: Login Failed for user 'sa '. Reason: not associated with a trusted SQL server connection. You can connect to the database on the local SQL Server, but there is a problem with the connection to the server, the reason is a

Tag: SQL Server transaction is fullError description: The transaction log for the database is full. To find out why the space in the log cannot be reused, see the Log_reuse_wait_desc column in sys.databases.First introduce the concept of transaction log (from Baidu Encyclope

Label: [Top] SQL Server more than 2008 error-handling Database recovery Method--Log tail backup Category: Database management logs Best Practices FAQ Backup Restore misoperation Integrity SQL Server Databases Enterprise Management DBA security 2013-01-10 20:48 34970 people