Post reply

Transactionlog backup, how?

  • October 9, 2006 at 4:14 am

    #192613

    I'm playing around with the maintenanceplan editor/creator and try to find how I can create a backup for a transactionlog. When I look at the SQL after creating a Plan I cannot see anything which indicates a backup of the transactionlog. WHen I look in the DIR where the backup is created, I only see 1 file, which I presume is the databasefile...

    I cannot find an option in the Backup Database Task to backup ALSO or even ONLY the T-log. I see no other task in the toolbar to backup or even truncate the T-log.

    Ofcourse, I can write the SQL and add an SQL Task to the Plan, but that's not why I wish to create a Maintenance Plan.

    So, do I miss something here?

    Greetz,
    Hans Brouwer

  • October 9, 2006 at 4:37 am

    #664761

    Found it. It seems I need to create a NEW Backup Database Task and then choose Transaction log as a backup type. Confusing, but that's what you get when you create a new GUI.

    Greetz,
    Hans Brouwer

  • October 9, 2006 at 4:39 am

    #664762

    Hi,

    If you're using the wizard to create the maintenance plan select the database and then click next after you have clicked 5 times next you get to the page where you can set up your log backup.

    Hope that helps.

    Regards,

    Holger

  • October 9, 2006 at 5:06 am

    #664765

    Hi Holger, tnx for responding.

    I am confused, however. I can not see a Maintenance Wizard as you describe. We ARE talking about SQL Server 2005, right?

    EDIT:

    Found it, sorry...

    Greetz,
    Hans Brouwer

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

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