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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Retrieving the T-SQL command syntax for a...

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

Rate Topic

Display Mode

Topic Options

Author

Message

kaplan71

Posted Wednesday, March 06, 2013 7:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 2:11 PM
Points: 31, Visits: 74

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.

Post #1427393

MyDoggieJessie

Posted Wednesday, March 06, 2013 8:59 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 2,035, Visits: 3,759

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? Wink

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" Wink

Post #1427737

« Prev Topic | Next Topic »

Permissions