cannot delete a file of a database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cannot delete a file of a database

We are on sql2005 sp1
I have to databases in miroring with automatic fail over option and a witness. On the principal, i have a old transaction log which I am trying to delete. THis file is not present on the mirroring server. I checekd the entries in sysaltfiles of the primary server, it does noth ave any reference to it. Any ideas on how to remove this file? Regards, Shiva
What is the message when you try to delete it?
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.