Thank you for ur helps. I will try in later.

By the way, how to prevent the transaction log grow?

Full backup will reduce the LDF file size ?

Thank...

Thank you for ur helps. I will try in later.

By the way, how to prevent the transaction log grow?

Full backup will reduce...

Any impact to my MDF if i follow the below method ?

quote:

---

How to reduce the log file size:

1.Open Query Analyzer

2.sp_detach_db 'database-name'

3.Delete...