清空SQL数据库日志|数据库开发|SQL|web开发|快速开发|中间件平台|方正飞鸿|ES2007|
declare @DataBaseName varchar(50)
declare @LogoFileName varchar(50)
declare @NewSize int
select @DataBaseName = 'mainstay'
select @LogoFileName = 'wftest_log'
select @NewSize = 0
DUMP TRANSACTION @DataBaseName WITH NO_LOG
DBCC SHRINKFILE( @LogoFileName, @NewSize )
declare @LogoFileName varchar(50)
declare @NewSize int
select @DataBaseName = 'mainstay'
select @LogoFileName = 'wftest_log'
select @NewSize = 0
DUMP TRANSACTION @DataBaseName WITH NO_LOG
DBCC SHRINKFILE( @LogoFileName, @NewSize )
方正中间件工具_方正飞鸿_ES2007
www.founderfix.com