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

Today, due to the large growth of log files in sql server, the log files are deleted after the separate databases are deleted. When they think that they will attach the database, they will automatically produce log files. As a result, they have thought about a lot of ways to rebuild log files and build the database with the same name. After building the database with the same name, the prompt format of the built log file is incorrect.

Finally, use the command library to build the 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'

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.