Normal backup SQL database and Backup transaction log

[cc929]

I have a question about backup transaction log.
My transaction log file is 18MB and I did backup log file under SQL enterprise manager. After that, my backup file is 18MB and I still see the transaction log file also 18MB. Then I did backup log file again and my backup file is only 135KB and when I check the transaction log file that is still 18MB.
Please tell me it is correct or some wrong in my SQL server or I did something wrong in the backup log file

Can you also tell me what is the normal backup for SQL server? I backup SQL database every night (Full Backup).
Can you give me the normal backup schedule?

Thanks in advance!

 

[nigelrivett]

Backing up the tr log will just free up entries for reuse. You need to shrink the file to reduce the size.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[cc929]

nigelrivett,

Thanks for your help!
Please tell me in detail how to shrink the file after backup the tr log?
Can I setup a schedule to do this?
Please help me!

cc929

 

[ecobb]

check out the DBCC SHRINKFILE command in Books Online. It has a several options, such as the target size to shrink the file to.



Hope This Helps!

Ecobb
- I hate computers!