SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Microsoft.SqlServer.Management.Smo Namespace
Database Class
Database Methods
Alter Method
ChangeMirroringState Method
CheckAllocations Method
CheckAllocationsDataOnly Method
CheckCatalog Method
CheckIdentityValues Method
CheckObjectState Method
Checkpoint Method
CheckTables Method
CheckTablesDataOnly Method
Create Method
Deny Method
DisableAllPlanGuides Method
Drop Method
DropAllPlanGuides Method
DropBackupHistory Method
EnableAllPlanGuides Method
EnumBackupSetFiles Method
EnumBackupSets Method
EnumCandidateKeys Method
EnumDatabasePermissions Method
EnumLocks Method
EnumLoginMappings Method
EnumMatchingSPs Method
EnumObjectPermissions Method
EnumObjects Method
EnumTransactions Method
EnumWindowsGroups Method
ExecuteNonQuery Method
ExecuteWithResults Method
GetBoolParameter Method
GetParameter Method
GetStringParameter Method
GetTextBody Method
GetTextForScript Method
GetTextProperty Method
GetTransactionCount Method
GetUrnRecursive Method
Grant Method
Initialize Method
IsMember Method
PrefetchObjects Method
RecalculateSpaceUsage Method
Refresh Method
RemoveFullTextCatalogs Method
Rename Method
Revoke Method
Script Method
ScriptImpl Method
SetDefaultFileGroup Method
SetDefaultFileStreamFileGroup Method
SetDefaultFullTextCatalog Method
SetOffline Method
SetOnline Method
SetOwner Method
SetSnapshotIsolation Method
Shrink Method
TruncateLog Method
UpdateIndexStatistics Method
ValidateAllPlanGuides Method
Expand Minimize
This topic has not yet been rated - Rate this topic

Database.SetOffline Method

SQL Server 2008

Sets the database offline.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
C#
C++
F#
JScript
VB
Copy 
public void SetOffline()

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

Copy 
  'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'Take the database offline
db.SetOffline()

'Bring the database back online.
db.SetOnline()
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.