Post reply

Prob w/Master Log backup

  • April 29, 2005 at 7:33 am

    #110122

    Our Maintenance plan is failing to backup the Transaction Log for the master db on one of our Dev PCs. using SQL Server 2000 on Windows 2000. Recovery model set to Full. I see the following when I look at the properties:

    Backup can not be performed on this database. This sub task is ignored.

    The job has the following command:

    EXECUTE master.dbo.xp_sqlmaint N'-PlanID 00403206-32A6-4F55-8FC4-55BD06A30903 -To "Gaurang" -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "C:\SQLBak" -DelBkUps 2WEEKS -BkExt "TRN"'

    can someone point me in the right direction?

     

    TIA

    Dean

  • April 29, 2005 at 7:43 am

    #555906

    Hi Dean,

    It's exactly as the error message says, you can't do a transaction log backup on the master database.

    It's generally so small that a full backup would complete in seconds anyhow, so if you feel that you need to back several times each day then just create a maintenance plan for that.

    I tend to just do a full backup of Master to disk each night, the only time I do more is when I make a change to security or otherwise in a database.

    Hope this helps,

    Mike

  • April 29, 2005 at 7:47 am

    #555912

    thanks for the quick response. Any idea why the Maintenance Plan wizard includes this if it can not be done?

  • April 29, 2005 at 7:50 am

    #555920

    None whatsoever, lets call it a MS design feature

  • April 29, 2005 at 3:39 pm

    #556095

    Be sure to change the recovery model of your Master database back to Simple.  Otherwise the log will grow continually.

    Steve

Viewing 5 posts - 1 through 4 (of 4 total)

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