Database.SetOffline Database.SetOffline Database.SetOffline Method

Definition

Sets the database offline.

public:
 void SetOffline();
public void SetOffline ();
Public Sub SetOffline ()

Examples

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()  

Remarks

When the database is online, you can use this method to take it offline.

Applies to