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

Database.PrimaryFilePath Property

Gets the operating system directory that contains the primary file for the database.

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public string PrimaryFilePath { get; }

Property Value

Type: System.String
A String value that specifies the path to the primary database file.

Implements

IDatabaseOptions.PrimaryFilePath

VB

' compile with:'
' /r:Microsoft.SqlServer.Smo.dll
' /r:Microsoft.SqlServer.Management.Sdk.Sfc.dll
' /r:Microsoft.SqlServer.ConnectionInfo.dll
' /r:Microsoft.SqlServer.SqlEnum.dll 

Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Sdk.Sfc

Public Class A
   Public Shared Sub Main()
      ' Connect to the local, default instance of SQL Server.
      Dim srv As Server
      srv = New Server

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

      'Display information about the database.
      Console.WriteLine("Name = " + db.Name.ToString)
      Console.WriteLine("ID = " + db.ID.ToString)
      Console.WriteLine("Owner = " + db.Owner.ToString)
      Console.WriteLine("Parent = " + db.Parent.ToString)
      Console.WriteLine("State = " + db.State.ToString)
      Console.WriteLine("Status = " + db.Status.ToString)
      Console.WriteLine("User Name = " + db.UserName.ToString)
      Console.WriteLine("DBO Login = " + db.DboLogin.ToString)
      Console.WriteLine("Version = " + db.Version.ToString)
      Console.WriteLine("Primary File Path = " + db.PrimaryFilePath.ToString)
      Console.WriteLine("Service Broker = " + db.ServiceBroker.ToString)
      Console.WriteLine("Replication Options = " + db.ReplicationOptions.ToString)
      Console.WriteLine("Default File Group = " + db.DefaultFileGroup.ToString)
      Console.WriteLine("Default FTS catalog = " + db.DefaultFullTextCatalog.ToString)
      Console.WriteLine("Default Schema = " + db.DefaultSchema.ToString)
   End Sub
End Class

PowerShell

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

Write-Host "Name =" $db.Name
Write-Host "ID =" $db.ID
Write-Host "Owner =" $db.Ownder
Write-Host "Parent =" $db.Parent
Write-Host "State =" $db.State
Write-Host "Status =" $db.Status
Write-Host "User Name =" $db.UserName
Write-Host "DBO Login =" $db.DboLogin
Write-Host "Version =" $db.Version
Write-Host "Primary File Path =" $db.PrimaryFilePath
Write-Host "Service Broker =" $db.ServiceBroker
Write-Host "Replication Options =" $db.ReplicationOptions
Write-Host "Default File Group =" $db.DefaultFileGroup
Write-Host "Default FTS catalog =" $db.DefaultFullTextCatalog
Write-Host "Default Schema =" $db.DefaultSchema

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft