Want to reomove transaction log

[uraj]

Hi All,
As I new to SQL server DBA activity here i need some help form u expert ppl on -
1. How we will make transaction log file to 0 mb.
because my .ldf file size is 3 GB and I am not going to use
it more now so I want to clear all this transaction log.
or
2.Can we create a new database using this database backup
and restore with some option that it will not restore log files.

As I try with Shrink command but my .ldf file is physicaly showing same size.
What to do ...?? n How to ......???

Thanks in Advance
Uv

[rmiao]

1. you can't disable log. If the db is in full or bulk-logged recovery model, you have to do log backup periodically to keep log file in reasonable size.

2. No.

3. Run 'backup log db_name with truncate_only' first then try shrink log file.

[uraj]

Thanks a lot rmiao
Ya it's working fine now I able to reduce physical size of ldf file

Thanks.

UV