Свойство Audit.MaximumFileSize

Статья
04/26/2013

Gets or sets the maximum size of the audit in megabytes.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property MaximumFileSize As Integer 
    Get 
    Set
'Применение
Dim instance As Audit 
Dim value As Integer 

value = instance.MaximumFileSize

instance.MaximumFileSize = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int MaximumFileSize { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int MaximumFileSize {
    int get ();
    void set (int value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member MaximumFileSize : int with get, set

function get MaximumFileSize () : int 
function set MaximumFileSize (value : int)

Значение свойства

Тип: System.Int32
A Int64 value that specifies the maximum size of the audit in megabytes.

Замечания

The minimum size that you can specify is 1024 KB and the maximum is 2,147,483,647 terabytes. You can also specify 0, which does not place a limit on the size of the file. If you specify a value lower than 1024, an error is raised.

Примеры

The following code example shows how to set the maximum size of the audit log file to 10 megabytes and display that information on the console.

using System;
using Microsoft.SqlServer.Management.Smo;

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create the audit and set the maximum file size
            Server dbServer = new Server("(local)");
            Audit dbAudit = new Audit(dbServer, "Test Audit");
            dbAudit.DestinationType = AuditDestinationType.File;
            dbAudit.FilePath = "C:\\AuditDirectory";
            dbAudit.MaximumFileSize = (int)10;
            dbAudit.Create()
                       
            //Display the maximum file size on the console
            Console.WriteLine("The maximum size the audit log file is "
                              + dbAudit.MaximumFileSize + " 
                              megabytes.");
        }
    }
}

Powershell

#Create the audit and set the maximum file size
$dbServer = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$dbAudit = New-Object Microsoft.SqlServer.Management.Smo.Audit($dbServer, "Test Audit")
$dbAudit.DestinationType = [Microsoft.SqlServer.Management.Smo.AuditDestinationType]'File'
$dbAudit.FilePath = "C:\AuditDirectory"
$dbAudit.MaximumFileSize = 10
$dbAudit.Create()

#Display the maximum file size
Write-Host "The maximum size of the audit log file is:" 
           $dbAudit.MaximumFileSize "megabytes."

См. также

Справочник

Audit Класс

Пространство имен Microsoft.SqlServer.Management.Smo

Поделиться через