Wednesday, September 12, 2012

BIML BackUp Database

Example file for creating a Backup DataBase SSIS Package
<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <AdoNetConnection
            Name ="CnAdoAdventureWorks2012"
            Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
            ConnectionString ="Data Source=.\MSSQL2012;Integrated Security=SSPI;Connect Timeout=30;"
            RetainSameConnection="true">
        </AdoNetConnection>
    </Connections>
    <Packages>
        <Package Name ="Maintenance.BackUpDataBase" ConstraintMode="Linear">
            <Annotations>
                <Annotation>
                    File: Maintenance.BackUpDataBase.biml
                    Demo biml for setting up a BackUp DataBase package
                    Enviroment:
                    DB: MS-SQL2012
                    BIML: 1.6 VS2010 BIDS Helper
                    (c) John Minkjan biml101.blogspot.com
                </Annotation>
            </Annotations>
            <Tasks>
                <BackupDatabase
                    Name="BU AdventureWorks2012"
                    ConnectionName="CnAdoAdventureWorks2012"
                    BackupAction="Full" BackupCompressionOption="NoCompression"
                    BackupDeviceType="Disk"  RetainDays="5" IgnoreDatabasesInNotOnlineState="true"
                    DatabaseSelectionMode="Specific">
                    <AutomaticBackupDestination
                        BackupFileExtension="bak"
                        CreateSubfolder="true"
                        Folder="c:\temp">                       
                    </AutomaticBackupDestination>
                   
                    <Databases>
                        <Database>AdventureWorks2012</Database>
                    </Databases>
                </BackupDatabase>
            </Tasks>
        </Package>
    </Packages>
</Biml>
Till Next Time

No comments:

Post a Comment