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.