Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008

    Unanswered: Master Log Backup Issue

    We run a script to check the blocking issues every morning. We find a LogBack up job for master db running everyday. But the Backup team doesn't see it on their systems. The backup team says, they are not running any backup job . But this backup job shows up in the process Info. So, we manually kill it everyday. It takes a lot of wait time. We can't find where it comes from ?

    Below is the info from the Process Info Page

    Process ID : 86
    User: ABC\Admistrator
    Database: Master
    Status: Runnable
    Open Transactions: 0
    Command: Backup Log
    Application: Symantec Backup Exec for Windows
    Wait Time: 42600844
    WaitType: NetworkIO
    CPU : 0
    Physical IO: 12
    memory Used: 1
    Login Time: 5/19/2008 10:04:53 PM
    Host: XYZ
    Network Library : LPC
    Network Address: 0015C58947C3
    Blocked by : 0
    Blocking : 0

    This is the info from the Process details
    BACKUP LOG [abc_xyc] TO virtual_device = 'abc_xyz_00__bfbdb0fa_9b94_4392_8ce0_0719ad2a00c5_ ' WITH NO_TRUNCATE

    Master DB Properties
    Size: 71MB
    Space Available : 17MB
    No of users: 49
    Data File location: c:\ProgramFiles\MicrosoftSQLserver\MSSQL\data\mast er.mdf
    Automatically grow file (enabled) 10%
    Transaction Log File: c:\ProgramFiles\MicrosoftSQLserver\MSSQL\data\mast log.ldf
    Automatically grow file (enabled) 10%
    Reocovery Model (Master): Simple
    Auto update stats, and Auto create stats enabled.

    Please let me know if any one knows what the problem was??



  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    It's not a MASTER database log backup job, it's you [abc_xyc(may be Z?)] log backup, that is being invoked by backup exec. The latter can maintain its own scheduling, or rely on AT. You need to open backup exec management tool (I don't know what it's called, nor where to look for it), and see where and how this job is configured.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts