sql 常用命令

重设Identity字段的初始值
DBCC CHECKIDENT(tablename, reseed,1)

清除sql server日志
backup log databasename with no_log
dbcc shrinkdatabase(databasename)