SQL Server Performance

cannot delete a file of a database

Discussion in 'SQL Server 2005 Database Mirroring' started by kirankonduru, Jan 9, 2007.

  1. kirankonduru New Member

    HI,
    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
  2. Luis Martin Moderator

    What is the message when you try to delete it?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page