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
)

参数

注释

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.