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.
相关阅读