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.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |