Following those steps will first empty the transaction log and then shrink the file size
use master
go
dump transaction
go
use
go
DBCC SHRINKFILE (
go
— then you can call to check that all went fine
dbcc checkdb(
Following those steps will first empty the transaction log and then shrink the file size
use master
go
dump transaction
go
use
go
DBCC SHRINKFILE (
go
— then you can call to check that all went fine
dbcc checkdb(