DUMP TRANSACTION ZGJT WITH NO_LOG
--清空事务日志:
DUMP TRANSACTION 数据库名称 WITH NO_LOG BACKUP LOG 数据库名称 WITH NO_LOG DBCC SHRINKDATABASE(数据库名称) DUMP TRANSACTION zgjtyunshu WITH NO_LOG BACKUP LOG zgjtyunshu WITH NO_LOG DBCC SHRINKDATABASE(zgjtyunshu)select top(1)* from ZGJT_information order by id desc
DUMP TRANSACTION ZGJT WITH NO_LOG
BACKUP LOG ZGJT WITH NO_LOG DBCC SHRINKDATABASE(ZGJT) --大容量日志ALTER DATABASE zgjtyunshuSET RECOVERY BULK_LOGGED
--执行完成后将恢复模式改回完整恢复模式ALTER DATABASE zgjtyunshuSET RECOVERY FULL
--改变数据库的恢复模式
--本练习将数据库恢复模式改变为大容量日志,以获得大容量日志操作的良好性能,然后恢复到完整恢复模式。----1. 通过执行如下ALTER DATABASE语句,将AdventureWorks数据库的数据库恢复模式设置为大容量日志恢复模式。(在改变恢复模式前,对该数据库作完整备份。)------ Note that you should create the C:\Backup folder at Operating -- System level before running this backup.----BACKUP DATABASE AdventureWorks TO DISK='C:\Backup\--AdventureWorks.Bak'----GO------Change the Recovery Model to Bulk Logged----ALTER DATABASE AdventureWorks----SET RECOVERY BULK_LOGGED----2. 在执行大容量日志操作以后,输入并运行如下ALTER DATABASE语句,将恢复模式改回完整恢复模式,然后执行另一次完整的数据库备份,以备份刚刚装入的数据。----ALTER DATABASE AdventureWorks----SET RECOVERY FULL------Perform a Full database backup----BACKUP DATABASE AdventureWorks TO DISK='C:\Backup\--AdventureWorks.Bak'----GO