2006年7月6日
【T_SQL】Clear DataBase Log
USE masterDeclare @DB varchar(50)SELECT @DB='mydbname' --数据库名backup log @DB with NO_LOG backup log @DB with TRUNCATE_ONLY DBCC SHRINKDATABASE(@DB)IF @@Error=0 begin print 'OK!' endELSE BE... Read More
posted @ 2006-07-06 09:47 blueKnight Views(220) Comments(0) Diggs(0) Edit