SMO Study Notes (III)-verify database backup files

After the database is backed up, the database backup file may be damaged due to other reasons. This article describes how to verify the correctness of the database backup file.

SMO verify the database backup file code: // <summary>
/// Verify the database backup file
/// </Summary>
/// <Param name = "string"> </param>
/// <Returns> </returns>
Public static bool verifyingbackups (string sqlsqlconnectionstring, out string errormessage)
{
Using (sqlconnection connection = new sqlconnection (sqlsqlconnectionstring ))
{
Server = new server (New serverconnection (connection ));
Restore res = new restore ();
Res. devices. adddevice (string. format (@ "{0} \ {1 }. {2} "," d: "," db_back "," Bak "), devicetype. file );
Return res. sqlverify (server, out errormessage );
}
}