Compartilhar via

FileGroup.CheckFileGroupDataOnly Method

  • Artigo

Scans and tests the integrity of database pages that are used to maintain table data in operating system files that implement the file group.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Function CheckFileGroupDataOnly As StringCollection

public StringCollection CheckFileGroupDataOnly ()

public:
StringCollection^ CheckFileGroupDataOnly ()

public StringCollection CheckFileGroupDataOnly ()

public function CheckFileGroupDataOnly () : StringCollection

Return Value

A StringCollection object value that contains the error messages returned for the integrity test.

Remarks

The CheckFileGroupDataOnly method is implemented using the Transact-SQL DBCC CHECKFILEGROUP statement with the NOINDEX option specified.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Add FileGroups and DataFiles to a Database in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

FileGroup Class
FileGroup Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Using Filegroups and Files to Store Data
Using Files and Filegroups
DBCC CHECKFILEGROUP (Transact-SQL)