Home Forums SQL Server 2012 SQL 2012 - General Tail log tsql staement not working before restoring database in sql 2012 RE: Tail log tsql staement not working before restoring database in sql 2012

  • September 2, 2014 at 2:27 am

    #1742324

    sej2008 (9/1/2014)

    I make changes in datatbase and before restoring take last log backup

    Backup log db1

    to disk='c:\myfolder\Taillog.trn'

    That's not a tail-log backup. That's just a normal log backup. It doesn't have the option specified that would make it a tail log backup (calling it one doesn't make it so)

    The message is perfectly correct, no tail log backup has been taken.

    See BACKUP LOG in books online for the details of all the options. There's a section in there on tail log backups.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass