Restore.SqlVerify Method (Server, Boolean)

Article
12/15/2008

Checks the media on the Microsoft SQL Server instance represented by the specified Server object and loads backup history information into the history tables.

Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public Function SqlVerify ( _
    srv As Server, _
    loadHistory As Boolean _
) As Boolean

public bool SqlVerify (
    Server srv,
    bool loadHistory
)

public:
bool SqlVerify (
    Server^ srv, 
    bool loadHistory
)

public boolean SqlVerify (
    Server srv, 
    boolean loadHistory
)

public function SqlVerify (
    srv : Server, 
    loadHistory : boolean
) : boolean

Paramètres

srv
A Server object that represents the SQL Server instance targeted by the restore operation.

loadHistory
A Boolean value that specifies whether the history tables will be populated with pertinent backup information.

If True, the history tables are populated.

If False, the history tables are not populated.

Valeur de retour

A Boolean value indicating whether targeted backup set is readable and complete. If True, the backup set was successfully verified. If False, the attempt to verify the backup set was unsuccessful.

Notes

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Exemple

How to: Back Up Databases and Transaction Logs in Visual Basic .NET

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Autres ressources

Backing Up and Restoring Databases and Transaction Logs
RESTORE (Transact-SQL)
Sauvegarde et restauration de bases de données dans SQL Server

Partager via