use [master]goalter database yourdb set recovery simple with no_waitgoalter database yourdb set recovery simple --简单模式gouse yourdb godbcc shrinkfile (n'yourdb _log' , 11, truncateonly) gouse [master]goalter database yourdb set recovery
use [master]goalter database yourdb set recovery simple with no_waitgoalter database yourdb set recovery simple --简单模式gouse yourdb godbcc shrinkfile (n'yourdb _log' , 11, truncateonly) gouse [master]goalter database yourdb set recovery full with no_waitgoalter database yourdb set recovery full --还原为完全模式go
'这里的yourdb_log 如果不知道在sys.database_files里是什么名字的话，可以用以下注释的语句进行查询
'use yourdb
'go
'select file_id, name from sys.database_files;
'go