Example Analysis of sqlserver2008 Log shrinkage

This article mainly introduces the sqlserver2008 log shrinking example analysis, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

To shrink logs or data files in sql server2000, you must first change the running mode of the database to simple mode, and file shrinkage can also be carried out in full mode in sql server2008.

Shrink on the console:

Right-click the database to shrink the log, task-"shrink -" file, select log in the file type, and click OK to shrink the log.

To shrink by statement:

Alter database db_name set recovery simple

Go

Dbcc shrinkfile ('db_name_Log',0,truncateonly)' 'db_name_Log is the log logical file name

Go

Alter database db_name set recovery full

Go

The advantage of statement contraction is that jobs similar to scheduled tasks can be set up in the sql server agent, automatically shrinking periodically according to the volume of business.

Thank you for reading this article carefully. I hope the article "sample Analysis of sqlserver2008 Log shrinkage" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!