The processing method of database questioning

Data | database | doubt
Step 1:

Create a new database named the original database name.

Step 2:

Stop SQL Server

Step 3:

Replace the MDF file of the old database with the corresponding MDF file in the new database and delete the LDF file.

Step 4:

Restart the SQL Server service, and then run the following command:

Use Master

Go

sp_configure ' allow updates ', 1

Reconfigure with override

Go

BEGIN Tran

Update sysdatabases Set status = 32768 where name = ' Db_name '

--verify one row is updated before committing

Commit Tran

Step 5:

Stop SQL and then restart the SQL Server service, and then run the following command:

DBCC Traceon (3604)

DBCC rebuild_log (' db_name ', ' c:\mssql7\data\dbxxx_3.ldf ')

Go

Step 6:

Stop SQL and then restart the SQL Server service, and then run:

Use master

Update sysdatabases SET status = 8 where name = ' Db_name '

Go

Sp_configue ' allow updates ', 0

Reconfigure with override

Go

Step 7:

Run DBCC CHECKDB (DB_NAME) to check the integrity of the database

Note: All must replace the real database name.