Re: Is there any easy way to truncate the LDF file of SQL SERVER?# Database - 数据库
a*a
1 楼
not ridiculous, if you have tons of transactions.
have you tried DBCC sth..
have you tried DBCC sth..
y*e
2 楼
LDF has all the transaction log, so it keeps growing when you use your
database. You can do a backup to truncate the log. There seems to be a setting
that let you to specify how many log files and how often you can have your log
file truncated. DBCC can help of course.
【在 a*****a 的大作中提到】
: not ridiculous, if you have tons of transactions.
: have you tried DBCC sth..
database. You can do a backup to truncate the log. There seems to be a setting
that let you to specify how many log files and how often you can have your log
file truncated. DBCC can help of course.
【在 a*****a 的大作中提到】
: not ridiculous, if you have tons of transactions.
: have you tried DBCC sth..
d*o
3 楼
Ok, Calvin, here is your answer:
First of all which version of SQL you have?
You can do DBCC SHRINKDATABASE first ( note it is not DBCC ShrinkDB)
Then do a full backup
Then do DBCC SHRINKFILE
Then you should be fine.
For later maintainence, you can run backup log every 30 minutes +/- depends
your transaction load, and it should keep you log small.
David Gao
MCSE, MCDBA
setting
log
【在 y***e 的大作中提到】
: LDF has all the transaction log, so it keeps growing when you use your
: database. You can do a backup to truncate the log. There seems to be a setting
: that let you to specify how many log files and how often you can have your log
: file truncated. DBCC can help of course.
First of all which version of SQL you have?
You can do DBCC SHRINKDATABASE first ( note it is not DBCC ShrinkDB)
Then do a full backup
Then do DBCC SHRINKFILE
Then you should be fine.
For later maintainence, you can run backup log every 30 minutes +/- depends
your transaction load, and it should keep you log small.
David Gao
MCSE, MCDBA
setting
log
【在 y***e 的大作中提到】
: LDF has all the transaction log, so it keeps growing when you use your
: database. You can do a backup to truncate the log. There seems to be a setting
: that let you to specify how many log files and how often you can have your log
: file truncated. DBCC can help of course.
相关阅读
career choicesTempdb fullScientific Database Administratorjournal for sql server求助：mySQL怎么学习呀请教一下这个report的query应该怎么样写?Help? what does "--" mean in Teradata?University of California, Merced, Ph.D. positions available出道oracle dba 面试题OCP 怎样的path 比较好，请教一个数据输入的问题有没有用Sybase系统的？请推荐一本初级的sql server的书吧(面试用)MS SQL 2008 column permissionsMAX I/O WAIT为什么总是很高请问那种很复杂的sql语句，有什么套路吗？设计数据库用什么东西最好?oracle要收购amd了 (转载)各位大爷, 求求各位考过70-431的大爷给我指点(下星期就考了)刚提升为数据库部门经理，寻同道支持和交流！