Backup Log DNName with no_log??????????

USE [master] GO ALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE DNName SET RECOVERY SIMPLE --簡(jiǎn)單模式 GO USE DNName GO DBCC SHRINKFILE (N'DNName_Log' , 11, TRUNCATEONLY)

?

GO

?'這里的DNName_Log 如果不知道在sys.database_files里是什么名字的話，可以用以下注釋的語句進(jìn)行查詢

'USE DNName

'GO

'SELECT file_id, nameFROM sys.database_files;

'GO USE [master] GO ALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE DNName SET RECOVERY FULL --還原為完全模式 GO

DUMP TRANSACTION [jb51] WITH NO_LOG
BACKUP LOG [jb51] WITH NO_LOG DBCC SHRINKDATABASE([jb51])