how to check event log in windows server 2008

In SQL SERVER 2008, BACKUP Log with TRUNCATE_ONLY is no longer supported, and to shrink the database log, you first need to truncate the file by setting the database recovery mode to simple.The statements are as follows:Use DATABASENAME;GO--Truncate The log by changing the d

Tags: SQL Server--First query dbname_log in Sys.database_files name, here take xxx instead ofUse DBNameGOSELECT file_id, name from Sys.database_files;GO--the real contraction statement. SQL Server 2008 First changes the mode to Simple mode, then shrinks and then changes back to full mode.SE [Master]GOALTER DATABASE DBName SET RECOVERY simple with no_waitGOALTER D

Open itControl Panel- Administrative Tools (Administrative Tools ) (if you cannot find the administrative tools you need to change how to view)- Terminal Services (Remote Desktop Services)-Terminal Services Provisioning (Remote Desktop Session Host configuration)1. Connection: Rdp-tcp Right-click, properties. network adapter-Maximum number of connections, 2.. By default, if you do not add the Terminal Services feature, the maximum can only be adjusted to 2 connections at a time. 2. Terminal

SQL2005 Empty Delete log:Backup Log with no_log ' The dnname here is the name of the database you want to shrink, and notice that you modify the database name below and I'm not commenting anymore. Godump transaction dnname with no_log gouse dnnamedbcc shrinkfile (2) GoSQL2008 Empty Delete log: Use [Master]GOALTER DATABASEDnnameSETRECOVERY Simple withno_waitGOALTER DATABASEDnnameSETRECOVERY Simple--Simple

\username] from WINDOWS with Default_database=[master] GO EXEC sp_addsrvrolemember @loginame =n ' domain\username ', @rolename =n ' sysadmin ' GO To avoid errors, you can add an SQL account for a rainy-out or enable the SA command: --Add user T1 and give administrator permissions use [master] GO to CREATE LOGIN [T1] with password=n ' [email protected] ', default_database= [Master], Check_expiration=off, Check_policy=off GO EXEC master. sp_addsrvrolemember @loginame = n ' T1 ', @rolename = n '

--Database log name QueryUse DBNAMEGOSELECT file_id, name,* from Sys.database_files;GO---------------------------------------------------------------------------------------------------------sql SERVER 2005 Cleanup methodsUse [master]BACKUP LOG DBNAME with no_logUse APPDBCC shrinkfile (' Dbname_log ', 100)----------------------------------------------------------

. Item ($col) = $event. $col}$dt. Rows.Add ($row)}# Write to the database!$bulkCopy. WriteToServer ($DT)The above paragraph:Filter current log taken from forwarded eventXML contentAfter execution can go to SQL to check whether the log has been written into SQLSELECT * FROM GeneraleventsYou can see that the

--Instructions for use--HDOCSN is the name of the database to be modified--hdocsn_log is the name of the log file to be purged--Modify all the HDOCSN you see as the name of the database to be purged--Modify the log file name of Hdocsn_log for all purged databases--This name is the response database Xxx_log file where the local database residesGOUse[master]GOALTER DATABASE HDOCSN SET RECOVERY simple with no_

Do project database file more than 200G, search the method of compressing data log everywhere, but a lot of log file's physical size has not changed, execute the following script can change the physical file size, the formal production environment is used with caution, can first local test decide whether to use (db_name for the corresponding database name);Use [master]GOALTER DATABASE db_name SET RECOVERY s

You cannot create a session when an error occurs. check the PHP or website server logs and correctly configure the fastest solution for installing PHP. Sometimes, when phpMyAdmin is used, the error message "you cannot create a session when an error occurs. check the PHP or website server logs, and correctly configure t

This is a problem that students encountered when they used Phpwamp. (other environment or set up to encounter this problem, the same way)In fact, this problem is not related to the Phpwamp itself , is the problem of computer settings, generally normal situation will not appear this problem. Now put the students ' problems to tidy up, release Cheng Bowen.Students ' questions are as follows:Teacher, help Ah, may be phpwamp configuration file was I messed up, before all normal, change a computer

Workaround under Windows: Check for the existence of this directory or whether the directory has write permissions for everyone or authenticated users by locating the path to the Session.save_path = "" of php.ini. It's generally possible. How to solve Linux:Updated PHP today, the results of the configuration of the phpMyAdmin login to appear "Unable to create a session in the event of an error, please

Solutions under Windows: Check to see if the directory exists or if the directory has write permissions for everyone or authenticated users by looking for a path to PHP.ini's Session.save_path = "". It's generally okay. Solutions for Linux:Today updated PHP, the result of the configuration of the phpMyAdmin landing in the "cannot create a session when an error occurs, check the PHP or Web

phpMyAdmin error Causes and solutions: Unable to create the session in the event of an error, check the PHP or Web server logs and properly configure the PHP installation.

Script: check_log.shMain function: Used to check whether the log file is uploaded to the FTP server, if not uploaded, send an email alarm-------------------#!/bin/bash#autochecklogfilesandnoticebyemail#bycolin#revision on2015-11-03# #Useage: ./check_log.sh/home/upload/#10*** */root/check_log.sh################################ #RUN_LOG = '/var/

Operation Steps: 1, SSH connection to the IMM management port (username and password with the Web login) 2. Show all logs System> readlog-a 3, available TFTP or SFTP server to save the log system> readlog-a-I IP address-l filename Report System> Readlog? Usage Readlog [-options]-Display the IMM event log entri

Changed the root password under phpMyAdmin. As soon as you log on, the system reports "The session cannot be created when an error occurs. Please check the PHP or website server log" error Because XAMPP is used for direct installation, find the PHP Directory under the XAMPP installation directory, find the php5.ini

First, about how to cancel by remote Desktop log error caused by client printer redirection when connecting to server, this kind of error will not affect the server normal operation and use, only because the client in the remote Desktop A log error occurred while connecting to the