sql server login auditing log

Tags: blog http os using AR for file SP dataAfter AlwaysOn is configured, because there is no use of the full recovery model, the simple or bulk-logged mode is not available, so the log is growing and cannot be emptied using the change recovery modeManual operation shrinking or truncating the log is also invalidAfter reading some articles, it was found that someone usedPrimary instance out of availability g

Map existing database users to the SQL Server login name. Note: Sp_change_users_login cannot be used as a Windows login name. Transact-SQL syntax conventions Syntax sp_change_users_login [ @Action = ] 'action' [ , [ @UserNamePatte

I. log on to the control panel-> services-> ms SQL Server-> Local SYSTEM account-> restart ms SQL ServerLog on to the query analyzer using Windows verification -- execute sp_password null, sa new password, 'sa' 2. "unable to connect to the server, user XXX

This article is the third in a series of articles, the first two addresses are as follows:On transaction log in SQL Server (i)----the physical and logical architecture of transaction logsTalking about transaction log in SQL Server

://www.cnblogs.com/killkill/archive/2009/07/17/1525733.html Http://dufei.blog.51cto.com/382644/84645 Http://www.cnblogs.com/wangdong/archive/2008/10/24/1318740.html Ii. database image: Database image: The advantage is that the system can automatically detect master server faults and automatically switch to the backup storage. The disadvantage is that the configuration is complex and the data in the image database is invisible (in

Common logs for diagnosing SQL Server problems There are two main: (1) Windows Event Log (2) SQL Server ErrorLog 1, Windows Event Log event logs As a windows open and Managed service program, Windows logs information about th

This article is the fifth of the SQL Server Agent series, please refer to the original text for more information. As mentioned in the previous series, SQL Server Agent jobs are composed of a series of job steps, each of which is executed by a separate type. In the fourth chapter we see that

: Link database access and permissions BOL the discussion of role changes is limited to step 5, but it ignores an important step: coordinating actions between database access rights and log on after transfer. In order to access the database on the new main server, link the parsed login account to the corresponding database user and its permissions, you must perfo

Cause Analysis and Solution for SQL Server failure to contract log files, SQL Cause Analysis An error is reported when the server executes a job that compresses the log file size recently. One of my batch

In the process of installing SQL Server, the Windows authentication method is the default, and if you want to modify the authentication method after installation, you need to follow the steps below.1. Log in to SQL Server Management Studio, right-click the database engine an

disaster recovery solutions: AlwaysOn availability Groups, database mirroring, and log shipping. 2impact on Database startupWhen the database restarts or restores to the last time, the database will enter the recovery state, normally, this state lasts a few 10 seconds, but in special cases, it will take a very long time, even a few hours, if this step fails, the database enters into the suspended suspect state, Not available for normal use.so,

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

to the login account, unable to obtain all the space capacity of the disk, so changed the administrator's account login, found that the SQL Server has a bad log capacity will be nearly 90G, finally found the disk full reason, The next step is how to solve it.At first, I lis

transactions in T-sql:1 starting transaction: BEGIN TRANSACTION2 COMMIT TRANSACTION: COMMIT Transaction3 Rolling back transactions: ROLLBACK TRANSACTIONTransaction classification:1 Explicit transactions: explicitly specify the beginning of a transaction with BEGIN transaction.2 Implicit transaction: Open implicit transaction: Set implicit_transactions on, when operating in implicit transaction mode, SQL Se

Label:Today is a New Year third day, first with everyone to worship for a year, I wish you all happy.Today, an alwayson problem has been handled--the secondary replica is showing "not synchronized-suspicious" because of insufficient disk space, and in the log you can see that the database is in a suspended state and is out of sync with the primary replica. It would be nice to just clean up the disk of the secondary replica, make a little space, and th

User ' sa ' login failed. Reason: The solution for not connecting to a trusted SQL Server is as follows: I. Control Panel-SERVICE-"MS SQL server-" Login-"Local System account-" Restart MS SQL