use master
go
sp_dboption mybase,"trunc. log on chkpt.",false
go
checkpoint
go
dump tran mybase with no_log
go
sp_dboption mybase,"trunc. log on chkpt.",true
go
checkpoint
go
(1)如果是 master 库
dump tran master with no_log
(2)如果是用户数据库(如:mybase)
use master
go
sp_dboption mybase,"trunc. log on chkpt.",false
go
checkpoint
go
dump tran mybase with no_log
go
sp_dboption mybase,"trunc. log on chkpt.",true
go
checkpoint
go
错误信息如下:
There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure SQL Server with more procedure cache.