PlainCopy
LOGPARSER-I:IISW3C file:c:\inetpub\slowpage.sql-o:datagrid-q:off
Log Parser Lizard Query method:Open the Log Parser Lizard visual interface, for example, copy the SQL command into the Query window and click Generate [Generate].can also be displayed in a variety of graphical way, more convenient
Recently, some customers have requested website logs for analysis. Because the newly installed server has an external system installed, a binary (. IBL) log function. This function is enabled by default in the off-star system. After this function is enabled, all websites on the server write log data to a single log file. The
Log parser 2.2 is a powerful universal tool for text-based data (such as log files, XML files, and CSV files) and important data sources on Windows operating systems (such as Event Logs, registries, file systems, and Active Directory) for general queries. Log parser can comp
Original: SQL Server full, differential, and transaction log backup and restore (script and GUI implementation) [original]A Scripts for full backups, differential backups, and transaction log backups--Full backup DatabaseBACKUP DATABASE to DISK = ' E:\20150609_75\bak\Test_bak_full.bak ' with Init--Differential BACKUP DatabaseBACKUP DATABASE to DISK = ' E:\2015
need to modify the differential backup restore of the database file path Attention: For a differential backup restore that does not need to modify the database file path, it is no problem to use SQL Server visual interface restore. Here, the differential backup was successful because the file was the directory under the C drive when the backup was restored, or the directory was restored to the C drive, and no path modification was required. For database full, differential, and transaction
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.