Transcation log backup RRS feed

  • Question

  • Hi All,

    Size of  .ldf file is 2gb option is not coming to take transcation log backup & Size of .ldf file 4gb option is coming to take transcation log backups  (SQL2005).

    plz help us.what is logic behind these functions ?


    Rahul Sharma
    Friday, July 3, 2009 9:19 AM

All replies

  • Have you checked the recovery model? NO log backups can be taken for a database configured to use the SIMPLE recovery model
    bass_player http://bassplayerdoc.blogspot.com/
    Tuesday, July 7, 2009 11:43 PM