Database.IsDatabaseSnapshotBase Database.IsDatabaseSnapshotBase Database.IsDatabaseSnapshotBase Property

정의

데이터베이스가 스냅숏 데이터베이스의 기본 데이터베이스인지 여부를 지정하는 값을 가져옵니다. Gets a value that specifies whether the database is the base database for a snapshot database.

public:
 property bool IsDatabaseSnapshotBase { bool get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDatabaseSnapshotBase { get; }
Public ReadOnly Property IsDatabaseSnapshotBase As Boolean
속성 값

데이터베이스가 스냅숏 데이터베이스에 대해 사용되는 기본 데이터베이스인지 여부를 지정하는 Boolean 값입니다. A Boolean value that specifies whether the database is a base database used for a snapshot database. 경우 True, 데이터베이스가 스냅숏 데이터베이스에 대 한 기본 데이터베이스입니다. If True, the database is a base database for a snapshot database. 그렇지 않으면 False (기본값). Otherwise, False (default).

예제

VBVB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display  information about the database.  
Console.WriteLine("Is Database snapshot : " + _  
db.IsDatabaseSnapshot.ToString)  
Console.WriteLine("Is Database snapshot base : " + _  
db.IsDatabaseSnapshotBase.ToString)  
Console.WriteLine("User is Aministrator : " + _  
db.IsDbAccessAdmin.ToString)  
Console.WriteLine("User is backup operator : " + _  
db.IsDbBackupOperator.ToString)  
Console.WriteLine("User is data reader : " + _  
db.IsDbDatareader.ToString)  
Console.WriteLine("User is data writer : " + _  
db.IsDbDatawriter.ToString)  
Console.WriteLine("User is DDL administrator : " + _  
db.IsDbDdlAdmin.ToString)  
Console.WriteLine("User denied data reader : " + _  
db.IsDbDenyDatareader.ToString)  
Console.WriteLine("User denied data writer : " + _  
db.IsDbDenyDatawriter.ToString)  
Console.WriteLine("User is database owner : " + _  
db.IsDbOwner.ToString)  
Console.WriteLine("User security administrator : " + _  
db.IsDbSecurityAdmin.ToString)  
Console.WriteLine("Full text is enabled : " + _  
db.IsFullTextEnabled.ToString)  
Console.WriteLine("Database is a mail host : " + _  
db.IsMailHost.ToString)  
Console.WriteLine("Mirroring is enabled : " + _  
db.IsMirroringEnabled.ToString)  
Console.WriteLine("Database is a system object : " + _  
db.IsSystemObject.ToString)  
Console.WriteLine("Database is updateable : " + _  
db.IsUpdateable.ToString)  

PowerShellPowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  

Write-Host "Is database snapshot :" $db.IsDatabaseShapshot  
Write-Host "Is database snapshot base :" $db.IsDatabaseShapshotBase  
Write-Host "User is Administrator :" $db.IsDbAccessAdmin  
Write-Host "User is backup operator :" $db.IsDbBackupOperator  
Write-Host "User is data rader :" $db.IsDbDataReader  
Write-Host "User is data writer :" $db.IsDbDataWriter  
Write-Host "User is DDL administrator :" $db.IsDbDdlAdmin  
Write-Host "User denied data reader :" $db.IsDbDenyDatareader  
Write-Host "User denied data writer :" $db.IsDbDenyDatawriter  
Write-Host "User dis database owner :" $db.IsDbOwner  
Write-Host "User security administrator :" $db.IsDbSecurityAdmin  
Write-Host "Full text is enabled :" $db.FullTextEnabled  
Write-Host "Database is a mail host :" $db.IsMailHost  
Write-Host "Mirroring is enabled :" $db.IsMirroringEnabled  
Write-Host "Database is a system object :" $db.IsSystemObject  
Write-Host "Database is updateable :" $db.IsUpdateable  

적용 대상