Database.SetOnline 메서드
Sets the database online.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Sub SetOnline
‘사용 방법
Dim instance As Database
instance.SetOnline()
public void SetOnline()
public:
void SetOnline()
member SetOnline : unit -> unit
public function SetOnline()
주의
When the database is offline, you can use this method to bring it back online.
예
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")
'Take the database offline
db.SetOffline()
'Bring the database back online.
db.SetOnline()
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
$db.SetOffline()
$db.SetOnline()
참고 항목
참조
Microsoft.SqlServer.Management.Smo 네임스페이스