發行項
04/02/2012

AttachDatabase 方法 (String, StringCollection, AttachOptions)

將具有指定名稱、使用指定的資料檔和附加選項，且包含一個或多個檔案的現有資料庫附加至 SQL Server 的執行個體。

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub AttachDatabase ( _
    name As String, _
    files As StringCollection, _
    attachOptions As AttachOptions _
)
'用途
Dim instance As Server
Dim name As String
Dim files As StringCollection
Dim attachOptions As AttachOptions

instance.AttachDatabase(name, files, attachOptions)

public void AttachDatabase(
    string name,
    StringCollection files,
    AttachOptions attachOptions
)

public:
void AttachDatabase(
    String^ name, 
    StringCollection^ files, 
    AttachOptions attachOptions
)

member AttachDatabase : 
        name:string * 
        files:StringCollection * 
        attachOptions:AttachOptions -> unit

public function AttachDatabase(
    name : String, 
    files : StringCollection, 
    attachOptions : AttachOptions
)

參數

name
型別：System. . :: . .String
String 值，指定要附加的資料庫名稱。

files
型別：System.Collections.Specialized. . :: . .StringCollection
StringCollection 物件值，包含清單資料庫檔案。

attachOptions
型別：Microsoft.SqlServer.Management.Smo. . :: . .AttachOptions
AttachOptions 物件值，包含擷取的附件選項。

備註

The data and transaction log files of a database can be detached and then reattached to the same or another instance of SQL Server. Detaching and attaching a database is useful if you want to change the database to a different instance of SQL Server on the same computer, or if you want to move the database.