SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
SQL Server Management Objects (SMO) Class Library
Microsoft.SqlServer.Management.Smo Namespace
Database Class
Database Methods
AddDatabaseContext Method
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.EnumBackupSets Method

SQL Server 2008 R2

Returns a DataTable listing the backup sets associated with a database.

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

Return Value

Type: System.Data.DataTable
A DataTable listing all the backup sets associated with a database.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.