Log to big in SQL

[Fnv]

Hello,

I'm working with SQL 7 and I have one ldf 30 times the size of the database,
someone knows the way to truncate this log in order to have te correct one
and be able to have free space on disk?

Thanks in advance

Fnv/

[Manoj Rajshekar]

"Fnv" <fn*******@xxx.mi.madritel.es> wrote in message news:<bk*********@noticias.madritel.es>...

Hello,

I'm working with SQL 7 and I have one ldf 30 times the size of the database,
someone knows the way to truncate this log in order to have te correct one
and be able to have free space on disk?

Thanks in advance

Fnv/

Hi,

Use this syntax to truncate the log:

BACKUP LOG database_name WITH NO_LOG

You could use NO_LOG or Truncate_only . They are sysnonyms.

After that you may probably want to do a
dbcc shrinkdatabase database_name

to reduce and gain back the size.

Regards,
-Manoj

[Ray Higdon]

If you require transactional recovery you need to schedule regular
backups, if you do not you might run on truncate log on checkpoint.

Manoj suggestions will definately help, you might need to use dbcc
shrinkfile as well.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!