ps (8/11/2009)

---

backup log Artesia_Prod with truncate_only will not create any file on the drive.

After running this, try shrinking the log file usind dbcc shrinkfile and see if the physical size...

OK.

Ran: BACKUP LOG Artesia_Prod TO DISK='F:\\backup' WITH TRUNCATE_ONLY

And got a command completed successfully.

But I don't see a directory being created yet on the F: drive...how do I know this is...

ps (8/11/2009)

---

You didnot run the code i mentioned. YOu just took the snapshot of the properties of that column

I wanted u to paste the code in a query window and...

ps (8/11/2009)

---

Can you run this code and paste the output here:

select log_reuse_wait_desc from sys.databases where name='test'

Replace the word test with actual database name which will tell what is preventing...