Post reply

Retrieving the T-SQL command syntax for a full and differential backup within a maintenance plan

  • March 6, 2013 at 7:28 am

    #274951

    Hello --

    I have created several maintenance plans for backing up the databases on our server which include Full, Differential, and Transaction Log backups. When I created the plans, I made sure to have a text file generated for the transaction log backup which includes the T-SQL command syntax. However, I forgot to do the same for the Full and Differential backups.

    I would like to get the command syntax being used for the aforementioned backups, and I wanted to know how would I go about doing that?

    Thanks.

  • March 6, 2013 at 8:59 pm

    #1594252

    Create a duplicate maintenance plan for both the full and diff, then script it out, delete the duplicate plan OR you could just script it out yourself? 😉

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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