Shulou(Shulou.com)06/01 Report--

-- enter the database that needs to be shrunk, and get the data file name and log name, because these names may not be the same as the database name, but you need to execute DBCC.

Select * from sysfiles

Truncate the transaction log, where the database name is written, not the file name

Backup log common with no_log

Go

-- shrink log files

Dbcc shrinkfile (bi_log)

Go

-- shrink database files

Dbcc shrinkfile (bi)

Go

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.