MSSQL Compressed database Check backup set repair Database SQL statement

The MSSQL compression database tutorial Check backup set Repair Database SQL statement

This tutorial provides an example of an SQL statement that examines the backup set repair database for the MSSQL server compressed database, and how the instance describes it.
3, compressed database

DBCC SHRINKDATABASE (dbname)

4, transfer the database to new users with existing user rights

exec sp_change_users_login ' update_one ', ' newname ', ' oldname '

Go
5. Check backup set

Restore VERIFYONLY from disk= ' E:dvbbs.bak '

6, repair the database

ALTER DATABASE [DVBBS] set Single_user
Go
DBCC CHECKDB (' Dvbbs ', repair_allow_data_loss) with Tablock
Go
ALTER DATABASE [DVBBS] set Multi_user
Go

The above SQL statement is simple, but it works very well, hopefully it will be useful to you.