Mssql Compressed database check backup set Repair Database SQL statement

Mssql compression database check backup set Repair Database SQL statement this tutorial provides SQL statements about mssqlserver compression database check backup set repair database, and the operation method described by the instance.

Mssql compression database check backup set Repair Database SQL statements this tutorial provides SQL statements about mssql server compression database check backup set repair database, and the operation method described by the instance.

Mssql compression check backup set restoration Database SQL statement

This tutorial provides SQL statements about how mssql server compresses the database, checks the backup set, and fixes the database, and describes the operation methods.
3. compress the database

Dbcc shrinkdatabase (dbname)

4. transfer the database to a new user with the existing user permission

Exec sp_change_users_login 'update _ one', 'newname', 'oldname'

Go
5. check the backup set

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

6. restore 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 preceding SQL statement is simple, but it has a great effect and is expected to be useful to you.