use DatabaseName
go
checkpoint
DBCC SHRINKFILE('DBlogName', 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY DBCC SHRINKFILE('DBlogName', 1)[@more@]
go
checkpoint
DBCC SHRINKFILE('DBlogName', 1)
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY DBCC SHRINKFILE('DBlogName', 1)[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/208722/viewspace-1053592/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Create Bootable USB Drive
- Disable Dynamic DNS update
- Disable Dynamic DNS Updates in Windows 2008
- Migrate DPM datasource to another hard drive using powershell
- Some Exchange Powershells
- Recovery from LTO3 tapes with LTO5 tape drives using Backup Exec 2010
- Exchange 2000/2003 System Attendant does not start after disaster recovery installation, event ID 90
- SQL Database Maintenance Wizard
- How to change Licence Key for MS Office 2007
- How to change Volume Licence Key for Windows XP and 2003
