Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Database.RecoveryForkGuid Property

Gets the GUID value that specifies the recovery fork on which the database is currently active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Matrix)> _
Public ReadOnly Property RecoveryForkGuid As Guid 
	Get
'Usage
Dim instance As Database 
Dim value As Guid 

value = instance.RecoveryForkGuid

Property Value

Type: Guid
A Guid value that specifies the recovery fork on which the database is currently active.

VB

'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 the database GUIDs.
Console.WriteLine("Database GUID is " + _
db.DatabaseGuid.ToString)
Console.WriteLine("Service Broker GUID is " + _
db.ServiceBrokerGuid.ToString)
Console.WriteLine("Recovery Fork GUID is " + _
db.RecoveryForkGuid.ToString)

PowerShell

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

$db.UpdateIndexStatistics()
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft