Clean up the log file for SQL server2008

Today because SQL Server's log file grows so large that the detached database deletes the log file after it is automatically produced when the database is attached to the log file results It blinds me to a lot of ways to rebuild the log file to use the built-in log file after building the library with the same name. Incorrect format

Finally use the command library to create a log file using the original library

CREATE DATABASE "Masterdb"

On (filename= ' C:\Program Files\Microsoft SQL Server\mssql10. Mssqlserver\mssql\data\masterdb.mdf ')

For Attach_rebuild_log;

exec sp_detach_db ' Masterdb '

This article is from the "Let Me Men Grow Together" blog, please be sure to keep this source http://wujingfeng.blog.51cto.com/5725921/1878848

Clean up the log file for SQL server2008