How to truncate a log file

I've got a SQL V7 server whose log file has grown out of
control.
Could you please enlighten me to the steps to truncate
this log file?
Thanks
BillBackup log dbname with truncate_only
If you do not require point in time recovery you might turn on "truncate log
on checkpoint", if you do, schedule regular log backups. See "backup" in BOL
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:374C8E81-0C23-4F35-A2B2-2985243A864A@.microsoft.com...

quote:

---

> I've got a SQL V7 server whose log file has grown out of
> control.
> Could you please enlighten me to the steps to truncate
> this log file?
> Thanks
> Bill
>

---

|||Thanks Ray.|||Hi,
In addition to Ray's post , do a DBCC SHRINK file on the transaction log
file.
This will shrink your transaction log file to the minimum size.
For more information on DBCC SHRINKFILE, refer BOL
Thanks
Hari
MCDBA
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:68488509-6364-446B-B118-4B41FFCFDAFC@.microsoft.com...

quote:

---

> Thanks Ray.

---

|||Hi
You may want to read
http://msdn.microsoft.com/library/d...r />
_1uzr.asp
and check previous posts in these newsgroups.
John
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:374C8E81-0C23-4F35-A2B2-2985243A864A@.microsoft.com...

quote:

---

> I've got a SQL V7 server whose log file has grown out of
> control.
> Could you please enlighten me to the steps to truncate
> this log file?
> Thanks
> Bill
>

---

sql

How to truncate a log file

I've got a SQL V7 server whose log file has grown out of
control.
Could you please enlighten me to the steps to truncate
this log file
Thank
BillBackup log dbname with truncate_only
If you do not require point in time recovery you might turn on "truncate log
on checkpoint", if you do, schedule regular log backups. See "backup" in BOL
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:374C8E81-0C23-4F35-A2B2-2985243A864A@.microsoft.com...
> I've got a SQL V7 server whose log file has grown out of
> control.
> Could you please enlighten me to the steps to truncate
> this log file?
> Thanks
> Bill
>|||Thanks Ray.|||Hi,
In addition to Ray's post , do a DBCC SHRINK file on the transaction log
file.
This will shrink your transaction log file to the minimum size.
For more information on DBCC SHRINKFILE, refer BOL
Thanks
Hari
MCDBA
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:68488509-6364-446B-B118-4B41FFCFDAFC@.microsoft.com...
> Thanks Ray.|||Hi
You may want to read
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp
and check previous posts in these newsgroups.
John
"bill dunn" <anonymous@.discussions.microsoft.com> wrote in message
news:374C8E81-0C23-4F35-A2B2-2985243A864A@.microsoft.com...
> I've got a SQL V7 server whose log file has grown out of
> control.
> Could you please enlighten me to the steps to truncate
> this log file?
> Thanks
> Bill
>

how to store and retrieve image files in sql server

hi like to knw the steps for storing 1000+ image files in an sql server.....
i/p: 1000+ image files

o/p: should be displayed in an vb6 environment in an pic box.....I would recommend you storing full path to picture file and not file itself then get path from a database and load picture from file into a picture box.
It is extremely slow and complicated to do it on the database side. You should be able to convert picture file into a binary stream to store it on the database and then be able to decode this binary stream back to picture.

Good Luck.