Regenerate the log file for the database

1. Create a new database with the same name

2. Stop SQL Server again (be careful not to detach the database)

3. Overwrite the new database with the data file of the original database

4. Restart SQL Server

5. When you open Enterprise Manager, you will be questioned, regardless, execute the following statement (note that the database name is modified)

Use MASTER
GO

sp_configure ' Allow UPDATES ', 1 RECONFIGURE with OVERRIDE
GO

UPDATE sysdatabases SET STATUS =32768 WHERE name= ' suspect database name '
Go

sp_dboption ' suspect database name ', ' Single user ', ' true '
Go

DBCC CHECKDB (' Suspect database name ')
Go

Update sysdatabases set status =28 where Name= ' suspect database name '
Go

sp_configure ' allow updates ', 0 reconfigure with override
Go

sp_dboption ' suspect database name ', ' Single user ', ' false '
Go

Regenerate the log file for the database