MysteryJimbo (10/11/2012)

---

baabhu (10/11/2012)

---

MysteryJimbo (10/10/2012)

---

I'd do each step in order as a precaution.

Are you managing your transaction log with regular backups? If so, why do you say the log file is going to continue growing?

Thank you very much for your suggestion. I tried in the dev environment.

This the message I get.

Msg 5020, Level 16, State 1, Line 3

The primary data or log file cannot be removed from a database

It seems like the primary file group cannot be dropped. Any suggestions.

To be honest I've never tried with a primary log file before, only additional. Adding an additional log file will buy you time until you can get an outage

You never answered my question though as this shouldnt be needed.

MysteryJimbo (10/10/2012)

---

Are you managing your transaction log with regular backups? If so, why do you say the log file is going to continue growing?