Backups

  • We using SQL Litespeed and doing daily diff backups and once a week full backups. I see weird entry in event viewer only when full backups occur and I dont see when SQL diff backups are running. The event viewer has following 3 messages in row for every database.

    Source:SQL Server Instance Name

    category:2

    Event ID:3197

    user:NT Authority

    Description:I/O is frozen on database SMS_ . No user action is required. However, if I/O is not resumed promptly, you could cancel backup.

    and the very next event viewr is

    Source:SQL Server Instance Name

    category:2

    Event ID:3198

    user:NT Authority

    Description:I/O was resumed on database SMS_ . No user action is required.

    and the next one says database was backed up successfully.

  • Please don't create new threads for existing questions.

    http://qa.sqlservercentral.com/Forums/Topic616604-357-1.aspx

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply