The size of my database is growing. There is no need to backup anything
and I could stop the server anytime.

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Re: [MSDE] What is the command to truncate the logs? by Graham

Graham
Thu Aug 17 11:40:29 CDT 2006

Isn't there a DBCC SHRINKFILE command you could use?

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message
news:Ob3tX0ewGHA.2232@TK2MSFTNGP05.phx.gbl...
>
> The size of my database is growing. There is no need to backup anything
> and I could stop the server anytime.
>
> --
> .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
> ^ ^ 19:04:01 up 10 days 0 min 0 users load average: 1.02 1.02 1.00
> news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk



Re: [MSDE] What is the command to truncate the logs? by Man-wai

Man-wai
Fri Aug 18 08:14:10 CDT 2006

Graham Dobson wrote:
> Isn't there a DBCC SHRINKFILE command you could use?

The size of the two files didn't quite shrink...I used:

dbcc shrinkdatabase("tryeasy_db", TRUNCATEONLY)


--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.06) Linux 2.6.17.8
^ ^ 21:13:01 up 11 days 2:09 0 users load average: 1.00 1.01 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk