This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › SQL Server log file is too large How to clean up large log file without separating data ...
View: 11295|Reply: 0

[Source] SQL Server log files are too large The method of cleaning large log files does not separate the database

[Copy link]
Posted on 9/18/2018 9:53:59 AM | | |
SQL Server log files are too large How to clean large log files, there are many methods of separating databases - deleting log files - attaching databases, this method is too risky, the process is relatively long, and sometimes the separation is unsuccessful. The following method does not require database separation and additional operations.


SQL 2008 Shrink Empty Log Method:

1. Clearing the log in the SQL2008 must be carried out in simple mode, and then return to full mode after the clearing action is completed.
1). Select Database – Properties – Options – Recovery Mode – Select Simple.
2). After shrinking the database, it is returned to complete.
2. Can be operated directly with commands

More than 90G log files were opened and cleaned in more than 3 minutes





Previous:SQL statement notes that are not commonly used in SQL Server
Next:How to find and check your Baidu Bear Paw number?

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com